Expert PHP and MySQL

Description

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.

CONTENTS:

INTRODUCTION.

  
CHAPTER 1: TECHNIQUES EVERY EXPERT PROGRAMMER NEEDS TO KNOW.

  
CHAPTER 2: ADVANCED PHP CONCEPTS.

  
CHAPTER 3: MYSQL DRIVERS AND STORAGE ENGINES.

  
CHAPTER 4: IMPROVING RFORMANCE THROUGH CACHING.

  
CHAPTER 5: MEMCACHED AND MYSQL.

  
CHAPTER 6: ADVANCED MYSQL.

  
CHAPTER 7: DEFINED FUNCTIONS.

  
CHAPTER 8: WRITING PHP EXTENSIONS.

  
CHAPTER 9: FULL-TEXT SEARCHING.

  
CHAPTER 10: MULTI-TASKING IN PHP AND MYSQL.

  
CHAPTER 11: REWRITE RULES.

  
CHAPTER 12: USER AUTHENTICATION.

  
CHAPTER 13: UNDERSTANDING THE INFORMATION_SCHEMA.

  
CHAPTER 14: SECURITY.

  
CHAPTER 15: COMMAND-LINE AND WEB SERVICES.

  
CHAPTER 16: OPTIMIZATION AND DEBUGGING.

  
INDEX.