Expert PHP and MySQL

by Andrew Curioso; Ronald Bradford; Patrick Galbraith

• ISBN13: 9780470881644
• ISBN10: 047088164X
• Format: eBook
• Copyright: 2010-04-01
• Publisher: Wrox

Summary

Best practices and expert techniques for today's most demanding appsAs 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 expressionAddresses advanced PHP concepts, such as iterators and closuresDemonstrates using Gearman for multitasking in your web applicationsDiscusses caching using memcached with MySQL and your PHP web applicationsDiscusses ways to create PHP Extensions and MySQL User Defined FunctionsShows how to use Sphinx for search functionality in your PHP web applicationsWrox 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.wrox.com Programmer ForumsJoin our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.Code DownloadsTake advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.Read MoreFind articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

Table of Contents

Introduction

Techniques Every Expert Programmer Needs To Know

Advanced PHP Concepts

Mysql Drivers and Storage Engines

Improving Rformance Through Caching

Memcached and Mysql

Advanced Mysql

Defined Functions

Writing PHP Extensions

Full-Text Searching

Multi-Tasking In PHP and Mysql

Rewrite Rules

User Authentication

Understanding The Information_Schema

Security

Command-Line and Web Services

Optimization and Debugging

Index

Table of Contents provided by Publisher. All Rights Reserved.