PHP / MySQL

This page contains links to recommended information about using PHP and MySQL. You will find links to the current PHP and MySQL reference manuals, articles, tutorials, tips, scripts written in PHP as well as recommended PHP and MySQL books.

Sections

• PHP and MySQL Reference Manuals
• PHP and MySQL Tutorials & Articles
• PHP Scripts
• PHP Recommended Books
• MySQL Recommended Books

PHP and MySQL References

PHP Documentation
PHP manual.

MySQL 5 Reference Manual
The MySQL 5.0 reference manual, documentation and tutorials.

PHP and MySQL Tutorials & Articles

PHP Tutorial
PHP tutorials by w3schools.

PHP and MySQL Tutorial
Learn PHP and MySql from installation to using PHP to access your MySQL database. Example tutorials on how to create a shopping cart, bookstore, CMS, guestbook, image gallery and user authentication.

PHP 101 Tutorials
These tutorials teach the basics of PHP in a fifteen part series.

PHP Scripts

The PHP Resource Index
Hundreds of free PHP scripts and programs.

HotScripts
Both free and commercial PHP scripts with ratings.

PHP Scripts
Free PHP scripts as well as some for sale.

Free-Scripts.net
Free Perl CGI scripts in many categories.

PHP Recommended Books

The books shown below are highly recommended. For Canadian visitors, click on the box on the right, for a Canadian distributor.

 

United States customer links		Canadian customer links
	Programming PHP (2nd edition) by Kevin Tatroe, Rasmus Lerdorf, Peter MacIntyre from the O'Reilly series. The first six chapters explain PHP essentials, including data types, functions, string manipulation, arrays and objects. Next comes a look at basic Web techniques, followed by an introduction to database access. There is a chapter on generating graphics with the GD extension library and another on creating Adobe PDF documents. The authors then show how to parse XML, and there is a section on security with some handy tips for protecting PHP sites. A chapter on application techniques looks at code libraries, performance tuning and handling errors. Next there is an explanation of how to build extensions to PHP using C, followed by a look at Windows issues such as COM and ODBC. Finally, there is a complete reference to the standard functions in PHP 4.0.
	Learning PHP 5 by David Sklar from the O'Reilly series. With attention to both PHP 4 and the new PHP version 5, it provides everything from a explanation of how PHP works with your web server and web browser to the ins and outs of working with databases and HTML forms.
	PHP Cookbook (2nd edition) by David Sklar and Adam Trachtenberg from the O'Reilly series. "PHP Cookbook" has a wealth of solutions for problems that you'll face regularly. With topics that range from beginner questions to advanced web programming techniques, this guide contains practical examples -- or "recipes" -- for anyone who uses this scripting language to generate dynamic web content. Updated for PHP 5, this book provides solutions that explain how to use the new language features in detail, including the vastly improved object-oriented capabilities and the new PDO data access extension. New sections on classes and objects are included, along with new material on processing XML, building web services with PHP, and working with SOAP/REST architectures.

MySQL Recommended Books

The books shown below are highly recommended. For Canadian visitors, click on the box on the right, for a Canadian distributor.

United States customer links		Canadian customer links
	Web Database Applications with PHP & MySQL by Hugh E Williams and David Lane. Web Database Applications with PHP and MySQL," Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional.
	High Performance MySQL: Optimization, Backups, Replication, and More by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz and Derek Balling. The definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power.