Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Johannes Schluter's Blog:
Direct MySQL Stream Access
Nov 05, 2008 @ 11:18:57

In a recent post to his blog Johannes Schluter looks at how you can use the new experimental MySQL driver for PHP, mysqlnd, and get into the streams that connect PHP and your MySQL database connections.

Ever wondered what your PHP application and MySQL actually do? An experimental mysqlnd branch will give you full access to the network communication stream. Using a custom PHP stream filter you can then intercept the communication.

He shows how to attach a filter on to the stream and what sort of output it would give for a query that wasn't valid SQL (including all of the "behind the scenes" queries that the database does to get table information from the schema).

tagged: mysqlnd mysql stream access driver filter output

Link: