Overview of MySQL Connectors for PHP
summary
Compares actual PHP MySQL runtime options and APIs, showing that mysqlnd vs libmysqlclient matters (mysqlnd becomes default in PHP 5.4; 5.3 can emit header mismatch warnings), details mysqli prepared statements and character-set/plugin support, and explains that PDO is unbuffered by default and requires a DSN and explicit attribute to allow LOAD DATA LOCAL INFILE. Demonstrates a working SimpleDAL wrapper that exposes legacy-style functions over PDO for hybrid migration and notes when to use buffered versus unbuffered queries.
AI-written summary · about
chapters (11)
- 0:00MySQL PHP connectors intro
- 0:44Native vs legacy driver
- 2:08Legacy MySQL API risks
- 3:12MySQLi features and usage
- 7:24MySQLi interfaces
- 9:58MySQLi prepared statements
- 11:02PDO MySQL intro
- 12:30PDO MySQL attributes
- 13:53PDO MySQL queries
- 14:14SimpleDAL overview
- 15:41Summary
related talks
45mPHP's biggest bottleneck, MySQL
40mImproving Observability, Reliability, and Security of Relational Database...
01h 00mMySQL: a checklist for the high-load newcomer
43mState of the Dolphin
44mModern PHP Standards and Community
56mWhat's new in PHP
41mMariaDB The New MySQL
44mChallenges of Efficiently Using MySQL on Modern Hardware