pdo

Uh, uh… about a year ago Mayflower OpenSource Labs released the mysqlnd user handler plugin (PECL/mysqlnd_uh).

The extension lets you extend and replace mysqlnd internal function calls with PHP. Uh, uh… mysqlnd internals exported to user space?

Who cares as long as it does the trick?! Let me show you seven lines of PHP code to monitor all queries issued by any PHP MySQL application using any PHP MySQL extension (mysql, mysqli, PDO_MySQL) compiled to use the mysqlnd library.

Roughly three years ago I was writing about Direct MySQL Stream Access - a way to access the low-level stream PHP's mysqlnd library is using.

Back then this had been a patch against PHP's mysqli extension. As such a feature is quite dangerous (you can easily mess with the connection state which confuses mysqlnd and/or the MySQL server) we didn't push it into the main PHP tree.

Now three years later it's time to look at this again as we don't need to patch PHP anymore.

Replication is as old as life on earth.

No life without replication. MySQL replication is as old as MySQL, almost.

No MySQL without replication. The PECL/mysqlnd_ms 1.0.0 alpha release is brand new.

Chad Lung has posted an introduction to PDO, PHP Data Objects, in a simple PHP script:

For those using (or wanting to use) the SQL Server driver for PHP via PDO, Brian Swan has a handy resource for you - a PDO Cheat Sheet.

• WorldCat XISBN
• Mail Parser
• PDO Singleton
• dbf2mysql
• S Upload
• SAMA_g

Rob Allen and Juozas Kaziukenas are both wrapping up their entries for this year's WinPHP Challenge and have posted about it (and some of their thoughts on the competition) to their blogs.

From Rob: