Ive ran a few sites on windows servers, which partly used some FP generated ASP which connected to an access db. All is fine....but I am sure many are aware of the whole windows/asp PHP/linux approach/perception by people. Keeping it short...I want to get into the latter , open source etc etc
I was looking up old threads about MySQL v Access etc....and lots of good info. That is great, its what site search is for :)
I'm looking for a good tutorial on MySQL, PHP and all the related bumph...just stuff that will make me more proficient in the "big picture"....of course....starting from the bottom up
Bear in mind I have been using FP and Access, do dont be using any big words :) Any information on the broad subject would be great...
Cheers!
Richard
Do the following.
- Setup MySQL/PHP
- Insert some values.
Code the following.
- Connection to MySQL
- select some values.
- update some values.
Don't follow a tuturial! If you learn how to do this on your own you will learn a lot.
forget to mention, im using PHP Admin, which seems to take some of the nastiness away
first thing that struck me was all those options for starters!
That got set up and no probs there...its just the background info like whether a field should be "null" or "not null" and stuff like that.........cos I was doing exactly what you suggested and came across a fanciful array of errors :) trial and error is cool but i will need background stuff too
I realise its a fairly broad question I asked.
1 thing I want to do is to be able to render the PHP on my own PC. Currently, I have IIS on my computer :o
Is it a no-no to install PHP within IIS? Is it difficult? Im sure someone has done it around here.
I use a dial-up and have 'limited' time online....so it would be much handier if I could render the PHP within the confinements of my PC. Also....can I install MySQL within IIS?
I have PHP 4.21 and MySQL 3.23.49 ZIP's sitting pretty on my desktop
Any advancement on this would be a gem :)
If you're not attached to IIS then I'd recommend getting a copy of Nusphere's PHPAdvantage product. It comes with a PHP code tool, Apache, MySQL, and PHP all on one easy installation CD. Makes life very easy to install and manage your development environment.
As for MySQL with IIS - I believe it's possible but I don't know for sure. I've only installed MySQL for use with Apache.
Several.....years ago I was using Pagemaker 2.0 on my Mac 512KE. It was great. Then Quark 1.0 came out and I was considering switching to Quark. My software dealer, who could have sold me the more expensive Quark, chided me with this : "Do you really want to throw away all your learning investment in one product and prepare a new investment in a product that essentially does the same thing?"
So I bought pagemaker 3.0 instead.
It's nice to know about new technologies and to keep up with the latest.
If you have a comfort level with IIS there is still a lot of learning and opportunity with IIS. It already comes with an app server built in.
The debate will rage about PHP vs. ASP vs. JSP vs. CFM, but people will still continue to use and swear by all of them. That's what makes the world go around.
As for NULL and questions like that. I suggest you read www.mysql.com, lots of good info about how to use it. There is no wrong was to do something, just less optimal ways. If it works it works. I found that when I coded in the beginning I did things less optimal. But when my code started to touch millions of rows of data in mysql you learn the most optimal stuff really quick.
Having some coding experince in other languages will help you. I am not really sure you need to have a tutorial. There is just to much to cover. Just tackle one problem at a time.
If you have specfic questions just start a thread, if no ones answers it I will eventually come along and answer it.
I think I might get apache....turn off IIS and vice versa for a little experimenting on the desktop. Basically, Im open to learning "the next best thing". From what I read on here, I would be better off using a Linux server and all the open source as opposed to M$
This is like "my first week in the world of open source". Thanks all for the pointers.
I would be better off using a Linux server and all the open source as opposed to M$
To which I would ask... Why?
Other than the free programs, why would you be better off with all open source?
im just going by the general consensus of what I read.....mostly of which is in here.
I understand that you use alot of Microsoft products, and really, I have no quams with them. I too have dabbled with them (probably not as long as you)....and admire the ease in which I could do things.
I asked my tech why they run windows servers, safe in the knowledge he was going to be biased in some way :) This was to counter-act all the bad stuff i hear about Microsoft (mostly in here - but I appreciate they are just opinions).
In regards to ASP/PHP, his answer was that ASP and other windows related 'stuff' required less resources on the server. Thus, If I wanted to use anything open source, non-windows would be better from my understanding.
Bottom line is im new to it, and dabbling ..... listening what others have to say about it. TX, id be most welcome to hear why you preference resides with microsoft (if this is the case!)
Though from what ive seen with PHP/Linux .. and all other things non-microsoftish, Im gonna try and focus more on these and spend my time learning more about em
The whole idea of open source is pretty new to me!
If you go with Apache, you also need some type of application server on top of it. TomCat is free as well, but that requires configuration and is indeed another layer of resoucres.
What I like about MS solution is the ease of getting up and running. Basically out of the box, IIS runs, and you can run ASP without adding extra layers.
When I installed PERL for windows to run perl scripts, the process was so easy it was scary. There is no chmod command, and the permission process was simple.
Access came as part of the Office package, so it too was quick and easy to get going.
I have installed JRun and mySql to dabble in JSP and will probably use mySQL since I don't want to spend thousands for msSQL SERVER, but I've been happy with MS server products.
Plus, I like the graphic interface for networking. To transfer files from one server to another, or to run a backup server is drag and drop.
I think people are resentful that Windows cost money and you are locked into MS products for the long haul. But it's not like MS is going away.
I'm really ambivilent about it. I had the W2000 server disk, so I used it. I suppose If I had to start from scratch I'd use Linux, but I have other fish to fry.
If you go with Apache, you also need some type of application server on top of it.
hmmm, let me see. I have never used Tom Cat. Are you sure this is true? Why would he need an application server? Maybe if he is running Java. But who would want to do that. Runs everywhere. But runs everywhere slow. I think I will stick to true open source not Sun Source.
Yeah, IIS is great if you only know how to use a mouse. But if you want to trick out your website and not have to install a security patch every month stick with the most used web server in the world.
As for uptime. I think everyone knows which platforms win at that.
tx, I have to agree with you. If you have a simple website then install IIS and be done with it. Lots of people don't need all the power apache enables. (but don't forget to update your OS and webserver every month when a security issue or virus is found)
Ive read a tutorial on PHP/MySQL and all looks good.
Since I run Windows XP where I am situated, I am going to use FP and Access to create templates and 'easy on the eye forms' for updating info that is to be put on to the site. Access has some tools to change it to text format that I can import to the 'live website' when needs be.
So its pretty cool. Ive just read a tutorial and Im looking forward to looking more deeper into open source.
I have never used Tom Cat. Are you sure this is true? Why would he need an application server? Maybe if he is running Java. But who would want to do that. Runs everywhere. But runs everywhere slow. I think I will stick to true open source not Sun Source
Tomcat is open source. Its the reference implementation of Sun's servlet and JSP APIs, its part of the apache jakarta project [jakarta.apache.org]
