Expert PHP and MySQL


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
Wiley / Wrox
March 2010
Paperback, Kindle, iBook, Google Play, ePub, Mobi, PDF

What people are saying

For once, an "Expert" book where you not only can, but must take the title seriously. Carsten Pedersen