This in-depth guide to everything PHP and MySQL will take you from beginner to advanced in no time at all. Including a comprehensive SQL guide, as well as introductory and advanced looks at PDO, MySQLi, and MySQLnd.

This book intends to provide a comprehensive guide to PHP and MySQL. It does not cover ORMs (such as Doctrine), frameworks, or other tools. A rough (subject to change) Table of Contents looks like:

• What is a Database?
  • Relational vs NoSQL vs Non-relational
• Introduction to SQL (for MySQL)
  • Data Types
  • Queries
  • Conditions
• Essential SQL
  • Constraints
  • Features
• Advanced SQL
  • Indexes
  • JOINs
  • Stored Procedures
  • Triggers
• Introduction to PDO/MySQL
• Advanced PDO/MySQL
• Introduction to MySQLi
• Advanced MySQLi
• MySQL Native Driver
  • Introduction to MySQLnd
  • Read/Write Splitting with mysqlnd_ms
  • Advanced Read/Write Splitting with mysqlnd_ms
  • Using MySQL’s NoSQL memcache interface with mysqlnd_memcache
  • Query Caching with mysqlnd_qc
  • Writing Custom MySQLnd Plugins with mysqlnd_uh