Expert PHP and MySQL

  • 10h 10m
  • Andrew Curioso, Ronald Bradford
  • John Wiley & Sons (US)
  • 2010

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

About the Authors

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.

In this Book

  • Techniques Every Expert Programmer Needs to Know
  • Advanced PHP Concepts
  • MySQL Drivers and Storage Engines
  • Improving Performance through Caching
  • Memcached and MySQL
  • Advanced MySQL
  • Extending MySQL with User-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
SHOW MORE
FREE ACCESS