How to Do Everything with PHP and MySQL

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.



March 21, 2005


Electronic book text, 400 pages

Other Formats


0071466541 / 9780071466547

Adobe Digital Editions® is required to view your downloaded eBooks.
Click here to get Adobe Digital Editions
To learn more about eBooks please see our eBook FAQ.

If you're having problems installing due to firewall issues please go here:


Your Price



Main description

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.

Table of contents

Part I: Learning The Basics of PHP and MySQL1. Introducing PHP and MySQL2. Setting up a PHP-MySQL Development Environment3. Getting Started with PHP Basics4. Getting Started with MySQL Basics5. Connecting PHP to MySQLPart II: Achieving Results6. Input Validation and Output Formatting7. Working with Binary Data8. Performing Transactions9. Authenticating Users10. Porting Your Application Using Database AbstractionPart III: Putting It Together in the Real World11. Creating a Voting System12. Tracking Time-and-Materials13. Managing Information ResourcesAppendices:A. PHP/MySQL API ReferenceB. MySQL Command and Function ReferenceC. Online and Offline ResourcesD. Glossary

Back cover copy

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.

Copyright 2014 McGraw-Hill Global Education Holdings, LLC


Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.

Yes, I want to receive other special offer.