Expert PHP and MySQL

Best practices and expert techniques for today's most demanding apps
As the world's most popular, general purpose, open source scripting language, PHP is frequently used with MySQL to create high-traffic, mission-critical applications. This indispensable book shares proven, author-tested best practices and expert techniques that can be applied to even the most demanding MySQL-driven PHP apps. You'll explore ways to extend MySQL with user-defined functions, write PHP extensions, and solve problems when PHP and MySQL alone are not enough and other techniques or third-party tools are necessary.

Expert PHP and MySQL:
Reviews essential techniques, such as design patterns, complex queries, and advanced regular expression
Addresses advanced PHP concepts, such as iterators and closures
Demonstrates using Gearman for multitasking in your web applications
Discusses caching using memcached with MySQL and your PHP web applications
Discusses ways to create PHP Extensions and MySQL User Defined Functions
Shows how to use Sphinx for search functionality in your PHP web applications
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.

Table of 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.








Download:
download
or
download
or
download