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 MySQL 1.Introducing PHP and MySQL 2.Setting up a PHP-MySQL Development Environment 3.Getting Started with PHP Basics 4.Getting Started with MySQL Basics 5.Connecting PHP to MySQL Part II: Achieving Results 6.Input Validation and Output Formatting 7.Working with Binary Data 8.Performing Transactions 9.Authenticating Users 10.Porting Your Application Using Database Abstraction Part III: Putting It Together in the Real World 11.Creating a Voting System 12.Tracking Time-and-Materials 13.Managing Information Resources Appendices: A. PHP/MySQL API Reference B. MySQL Command and Function Reference C. Online and Offline Resources D. 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.