Overview
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.
