Synopses & Reviews
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 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.
wrox.com
Programmer Forums
Join 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 Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Read More
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Synopsis
Expert PHP and MySQL targets developers who work on mission-critical and high-traffic applications on a daily basis. There are plenty of books that teach people the basics of PHP and MySQL. This book takes a different approach and focuses on best practices and expert techniques that can be applied directly to today's most demanding MySQL-driven PHP applications.
The book begins with an overview of PHP, MySQL, and regular expressions. These chapters will not only be a foundation for the rest of the book but also provide tips and tricks that the readers can immediately apply to their projects. It then continues onto progressively more advanced topics, including: MySQL storage engines and their real-world uses Practical data reporting techniques for separating business logic from presentation Improved performance and flexibility through caching, multi-tasking, PHP extensions, and MySQL User Defined Functions Security, optimization, and debugging Building high-performance full-text search applications
The book uses proven, author-tested design patterns and tools that save developers valuable time but are rarely covered in other PHP or MySQL books. The authors also show how to solve problems when PHP and MySQL alone are not enough and other techniques or third-party tools are necessary. Such is often the case with dynamic applications that handle immense amounts of data. (For example, the authors show how to use the C language for writing PHP extensions and MySQL User Defined Functions.)
Synopsis
Best practices and expert techniques for even the most demanding MySQL-driven PHP applicationsPHP 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.
About the Author
Andrew Curioso is a senior software engineer at MyVBO (Virtual Business Office) creating an innovative and scalable infrastructure for Rich Internet Applications using PHP and MySQL.
Ronald Bradford is a technology strategist and advisor specializing in MySQL, Drizzle and related web technologies. With a primary focus on architecture, design, performance analysis and scalability of web applications, his consulting portfolio ranges from Internet startups to Fortune 500 companies.
Patrick Galbraith is a principal software engineer at Lycos, adding new PHP and MySQL offerings for Tripod Users, switching remaining apps using Oracle to MySQL as well as other interesting projects.
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.
INDEX.