These questions seem to be asked a lot here in the PHP section of the Web Developer Forums.
“Where can I find more information about PHP?” and “Where can I learn about PHP?” etc…
One would think that a simple search would turn up many results on this topic, and it does, but after someone said “why doesn't someone just post a pinned topic with alot of places to learn it if its being asked so much”[sic] Well I don’t know! I agree there should be. So hopefully maybe this will be stickyfied... maybe not... I can only hope
Here are some of the most informative places to learn all about PHP/MySQL on the web
http://php.net or http://php.net/manual
php.net has made it so it is easy to search for various functions within there website. All you have to do is append the function name to the end of the URL and it will take you there. So for instance if you wanted to learn more about how the function explode() works then all you have to do is type http://php.net/explode and it will take you there (you don’t even have to type ‘manual’
Of course, you can also use their search feature in the top right hand corner.
Tutorials of what you will need to get started with PHP. Very handy for those who will be installing and/or using PHP for the first time!
zend.net however does not have the same ease of use URL that php.net has. Their main feature that is extremely helpful though is that they have many tutorials written by the “PHP Gods” themselves! This is very nice if you are looking for top-grade expert knowledge on how to do something. For example, if you are looking for tutorials that are designed for absolute beginners this is a fantastic place to visit http://www.zend.com/php/beginners/index.php
They also have more advanced articles if you need them
Both of the main websites above (php.net & zend.com) are extremely handy as reference resources! I highly recommend keeping them in a place that is easy to get to such as your bookmarks. I keep them in a bookmark folder on my FireFox toolbar.
Naturally http://mysql.com is the place to go for all things MySQL. Unfortunatly it can be kinda confusing navigating their site. So here are links straight to what I think would be the most used resources.
This is the “Developer’s Manual” for MySQL. It contains just about everything you would want to know about using MySQL. It has a lot of information, but don’t feel overwhelmed there are key links to follow
Installing MySQL on Windows OS platforms
Here is a good area to visit if you are looking for a “tutorial” on how to use MySQL
Nice index of all the statements used in MySQL such as GROUP BY (http://dev.mysql.com/doc/mysql/en/group-by-optimization.html)
Tools for PHP & MySQL –
Here you will find handy tools that make programming with PHP and MySQL easy and efficient.
MySQL 4.0 download page. If you scroll down about 40% of the way down you will find “Windows Downloads” click the link ‘pick a mirror’ and download the installation. I recommend using the version with the installer.
MySQL Administrator GUI client. This comes in handy for administrating your MySQL installation. It is pretty straight forward to use.
MySQL Query Browser graphical client. This tool can help you create SQL statements.
For those people who need an quick and painless sever package I highly recommend AppServ http://www.appservnetwork.com/
This install package is about as hard to install as double clicking the file you download! Here is a pretty quick little tutorial on how to install it http://www.webdeveloper.com/forum/showthread.php?p=412731#post412731
It is an all inclusive package.
It contains all of the following (basically all you will need to get a full fledged server up and running locally):
If you must install PHP only then you can find the installation packages here:
The very best place that I have found to date that runs you through installing php on Windows is http://www.peterguy.com/php/install_IIS6.html (note: this is for PHP 5.x but can be applied to PHP 4.x)
I am sure that there are many more places and products that could and should be added here but these are the ones that I could think of off the top of my head.
I hope this helps in your quest to become a PHP Master
Enjoy and happy coding and most importantly HAVE FUN :p !
p.s. I just noticed that this post happened to be exactly my 800th post WOOT!