How to Do Everything with PHP and MySQL (How to Do Everything)

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 PHPs built-in support for MySQL and link the results of database queries to Web pages. Youll get full details on PHP programming and MySQL database development, and then youll 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.

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.

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.

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

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