Abstract

Best practices and expert techniques for even the most demanding MySQL-driven PHP applications

PHP is the world's most popular, general-purpose, open-source scripting language and MySQL is the world's most popular open-source database. This expert-level book begins with a brief overview of the two technologies and quickly moves on to coverage of advanced programming techniques, as well as the exciting new features of the PHP 5.3 release.

Written by three of PHP and MySQL experts and veteran authors, this resource focuses on best practices and expert techniques that can be applied to the most difficult MySQL-driven PHP applications. The authors share design patterns and tools that they themselves have tested in order to save you valuable time usually spent on figuring things out via trial and error.

• Reveals best practices and advanced techniques for handling challenges you may face with MySQL-driven PHP apps
• Reviews practical data reporting techniques for separating business logic from presentation
• Explains how to obtain improved performance and flexibility through caching, multi-tasking, PHP extensions, and MySQL user defined functions
• Discusses security, optimization, and debugging
• Shares author-tested design patterns and tools to save you time and effort

Packed with helpful examples and indispensable advice, this book shares tips and tricks that you can immediately apply to your projects.

Table of Contents

1. Techniques Every Expert Programmer Needs to Know
2. Advanced PHP Concepts
3. MySQL Drivers and Storage Enginers
4. Improving Performance Through Caching
5. memcached and MySQL
6. Advanced MySQL
7. Extending MySQL with User-Defined Functions
8. Writing PHP Extensions
9. Full-Text Searching
10. Multi-Tasking in PHP and MySQL
11. Rewrite Rules
12. User Authentication
13. Understanding the INFORMATION_SCHEMA
14. Security
15. Command-Line and Web Services
16. Optimizing and Debugging