How to Do Everything with PHP & MySQL

This new release in the popular How to Do Everything series explains how to build open source web applications with MySQL and PHP 5. Using these two tools, you’ll be able to create highly functional, interactive web sites easily. Follow along with a step-by-step sample application and, as a bonus, download three full-length case studies complete with code trees.

Create MySQL database-driven Web sites and applications with PHP quickly and easily. This step-by-step guide explains how to take full advantage of PHP’s built-in support for MySQL and link the results of database queries to Web pages. You’ll get full details on PHP programming and MySQL database development, and then you’ll learn to use these two cutting-edge technologies together. Easy-to-follow sample applications include a PHP online shopping cart, a MySQL order tracking system, and a PHP/MySQL news publishing system.

• Set up a PHP/MySQL development environment on Windows or UNIX
• Write PHP scripts and use variables, statements, and operators
• Create reusable code with arrays and custom functions
• Use files, sessions, cookies, and external programs
• Create a MySQL database and use SQL commands
• Edit database records and perform queries
• Control access and privileges with the MySQL security system
• Query a MySQL database with PHP
• Validate user input to maintain database integrity
• Format query output for optimal results

About the author: Vikram Vaswani is the founder and CEO of Melonfire, a company specializing in Web development and content creation for a variety of clients. He is the author of MySQL: The Complete Reference.

Vikram Vaswani is the founder and CEO of Melonfire (http://www.melonfire.com/), a company specializing in software consultancy and content creation and syndication services. He is also the author of PHP Programming Solutions, How to do Everything with PHP and MySQL, and MySQL: The Complete Reference (all McGraw-Hill/Osborne titles) and XML and PHP (New Riders Publishing). He is also the author of numerous well-received articles on open-source technologies (including Perl, Python, XML and the very popular PHP 101 series), all written with the goal of making complex technologies accessible and understandable to novice users. He has been developing software since 1995, was first introduced to PHP in 1998, and hasn't looked back since. He is regular columnist with Zend Technologies (creators of PHP), as well as with IBM DeveloperWorks, CNET Builder.com, DevX.com and other OSS sites.