Expert PHP and MySQL -- ABOUT THE AUTHORS -- ABOUT THE TECHNICAL EDITORS -- ACKNOWLEDGMENTS -- CONTENTS -- INTRODUCTION -- Chapter 1: Techniques Every Expert Programmer Needs to Know -- OBJECT-ORIENTED PHP -- USING MYSQL JOINS -- MYSQL UNIONS -- GROUP BY IN MYSQL QUERIES -- LOGICAL OPERATIONS AND FLOW CONTROL IN MYSQL -- MAINTAINING RELATIONAL INTEGRITY -- SUBQUERIES IN MYSQL -- USING REGULAR EXPRESSIONS -- SUMMARY -- Chapter 2: Advanced PHP Concepts -- A PROBLEM THAT NEEDS SOLVING -- ITERATORS AND THE SPL -- LAMBDA FUNCTIONS AND CLOSURES -- SUMMARY -- Chapter 3: MySQL Drivers and Storage Engines -- MYSQL DRIVERS -- ABOUT MYSQL STORAGE ENGINES -- DEFAULT STORAGE ENGINES -- OTHER MYSQL SUPPLIED ENGINES -- PLUGGABLE ENGINES -- ENGINES AS STANDALONE PRODUCTS -- OTHER MYSQL OFFERINGS -- SUMMARY -- Chapter 4: Improving Performance through Caching -- EACCELERATOR AND APC -- MEMCACHED -- INSTALLING MEMCACHED -- STARTING MEMCACHED -- LIBMEMCACHED -- LIBMEMCACHED UTILITY PROGRAMS -- PECL/MEMCACHED -- PRACTICAL CACHING -- SUMMARY -- Chapter 5: memcached and MySQL -- THE MEMCACHED FUNCTIONS FOR MYSQL -- HOW THE MEMCACHED FUNCTIONS FOR MYSQL WORK -- INSTALLING THE MEMCACHED FUNCTIONS FOR MYSQL -- USING THE MEMCACHED FUNCTIONS FOR MYSQL -- SUMMARY -- Chapter 6: Advanced MySQL -- VIEWS -- STORED PROCEDURES AND FUNCTIONS -- TRIGGERS -- TRANSACTIONS -- REPLICATION -- EVENTS -- SUMMARY -- Chapter 7: Extending MySQL with User-Defined Functions -- INTRODUCTION TO UDFS -- DEVELOPING A UDF -- A PRACTICAL UDF EXAMPLE -- USING A UDF WITH PHP -- OTHER UDF SQL STATEMENTS -- DEBUGGING A UDF -- SUMMARY -- Chapter 8: Writing PHP Extensions -- SETTING UP THE BUILD ENVIRONMENT -- CREATING AN EXTENSION WITH EXT_SKEL -- CREATING AN EXTENSION WITH CODEGEN_PECL -- VARIABLES IN PHP EXTENSIONS -- USING FUNCTIONS IN EXTENSIONS -- INPUT/OUTPUT -- ARRAYS AND HASH TABLES.

OBJECTS AND INTERFACES -- CONSTANTS, INI DIRECTIVES, AND GLOBALS -- DESCRIBING AN EXTENSION -- SUMMARY -- Chapter 9: Full-Text Searching -- MYSQL FULLTEXT INDEXES -- A BETTER SOLUTION: THE SPHINX FULL-TEXT SEARCH ENGINE -- DEVELOPING APPLICATIONS THAT USE SPHINX -- SUMMARY -- Chapter 10: Multi-tasking in PHP and MySQL -- GEARMAN -- WHAT IS GEARMAN? -- NARADA: A SEARCH ENGINE APPLICATION -- SUMMARY -- Chapter 11: Rewrite Rules -- USING REWRITE RULES -- REWRITE MAPS -- SUMMARY -- Chapter 12: User Authentication -- DESIGNING THE DATABASE -- HTTP-BASED AUTHENTICATION -- PURE PHP AUTHENTICATION -- ACCESS CONTROL LISTS -- SUMMARY -- Chapter 13: Understanding the INFORMATION_SCHEMA -- USING THE INFORMATION_SCHEMA -- TABLE OBJECTS TABLES -- OTHER DATABASE OBJECTS TABLES -- MYSQL STATUS TABLES -- MYSQL META DATA TABLES -- MYSQL ACL PERMISSIONS TABLES -- INFORMATION_SCHEMA EXTENSIONS -- SHOW CROSS REFERENCE -- SUMMARY -- Chapter 14: Security -- HARDENING YOUR MYSQL SERVER -- ENCODING DATA -- PHP SECURITY RECIPES -- SUMMARY -- Chapter 15: Command-Line and Web Services -- CREATING COMMAND-LINE SCRIPTS -- CREATING WEB SERVICES -- SUMMARY -- Chapter 16: Optimization and Debugging -- DEBUGGING PHP -- OPTIMIZING QUERIES -- DEBUGGING MYSQL -- SUMMARY -- INDEX.