[{"_1":2,"_64":-5,"_65":-5},"loaderData",{"_3":4,"_33":34,"_62":-5,"_63":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_20":-5,"_21":22,"_23":24,"_27":28},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":12},"count",0,"free",true,"updatedAt","2025-12-29T19:26:29.461Z","paymentGateway","STRIPE","cartItems",[],"loading","toast","locale","en","constants",{"_25":26},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_29":30,"_31":32},"companies",[],"universities",[],"routes/_store+/_readers+/email_author.$slug/route",{"_35":36,"_61":-5},"book",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMTU5ODg","title","PHP and MySQL: The Definitive Guide","state","unpublished","contactAuthorMethod","email","aboutText","

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?\n
- Relational vs NoSQL vs Non-relational
\n
Introduction to SQL (for MySQL)\n
- Data Types
- Queries
- Conditions
\n
Essential SQL\n
- Constraints
- Features
\n
Advanced SQL\n
- Indexes
- JOINs
- Stored Procedures
- Triggers
\n
Introduction to PDO/MySQL
Advanced PDO/MySQL
Introduction to MySQLi
Advanced MySQLi
MySQL Native Driver\n
- 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
\n

","authors",[49],{"_37":50,"_51":52,"_5":53},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8xNjY0Mg","name","Davey Shafik",{"_54":55},"avatar",{"_56":57,"_58":59,"_60":12},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/78949/medium/daveyshafik-headshot-2014-large.jpg?1425583617","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author