Expert PHP and MySQL®

✍ Scribed by Andrew Curioso, Ronald Bradford, Patrick Galbraith(auth.)

• Year: 2010
• Tongue: English
• Leaves: 606
• Category: Library

✦ Synopsis

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.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.Content:
Chapter 1 Techniques Every Expert Programmer Needs to Know (pages 1–63):
Chapter 2 Advanced PHP Concepts (pages 65–85):
Chapter 3 MySQL Drivers and Storage Engines (pages 87–129):
Chapter 4 Improving Performance through Caching (pages 131–189):
Chapter 5 Memcached and MySQL (pages 191–220):
Chapter 6 Advanced MySQL (pages 221–270):
Chapter 7 Extending MySQL with User?Defined Functions (pages 271–305):
Chapter 8 Writing PHP Extensions (pages 307–364):
Chapter 9 Full?Text Searching (pages 365–399):
Chapter 10 Multi?tasking in PHP and MySQL (pages 401–442):
Chapter 11 Rewrite Rules (pages 443–456):
Chapter 12 User Authentication (pages 457–475):
Chapter 13 Understanding the INFORMATION_SCHEMA (pages 477–492):
Chapter 14 Security (pages 493–516):
Chapter 15 Command?Line and Web Services (pages 517–542):
Chapter 16 Optimization and Debugging (pages 543–566):