Recently at work, I was tasked with finding a method to retrieve data from a third-party SQL Server 2000-based system into our own MySQL-based application. It's worth noting that both system are behind their own firewalls and I was trying to bear security in mind as I did this.

Some highlights of his work included using GoToAssist to get to the system, using EMS SQL Manager to work with the SQL server itself and some of the PHP code he "threw at it" to grab the info he needed from the database (with the PDO drivers).

I am glad to announce the availability of the first alpha version of PDO_MYSQLND. PDO_MYSQLND is a PHP PDO driver for MySQL based on the MySQL native driver. PDO_MYSQLND 1.0.2-alpha is available for download on http://downloads.mysql.com/forge/pdo_mysqlnd_preview.

Updates include fixes for return values, patches for memory leaks, more code coverage and some "very promising results" running on a set of dedicated testing machines.

Packt Publishing recently sent me a couple of books to review. This post is about the second one I received, Learning PHP Data Objects by Dennis Popel. I was excited to receive this book as PDO underlies a lot of the Zend_Db_Adapter objects that I use in my day to day programming. It seemed like a good idea that I should know more about it.

He provides some good detail of what the book covers (chapter by chapter) as well as a summary including his recommendation for who should use the book and how they can best enjoy its contents.

Despite the fact that you may not have a choice in the matter, upgrading comes with a number of bonus new features that can help you write better code and gain access to new functionality that required a fair amount of hacking in previous version. Here's a quick list of 5 personal favourites.

The feature to make his list are SimpleXML, JSON/SOAP, PDO, the Standard PHP Library and SQLite. Each has their own bonus feature(s) included too for a little extra incentive to check them out.

The post explains what each of the technologies are for and where they fit in most development. The PDO_MYSQLND functionality is a direct connection for the PDO libraries to connect to MySQL using the native driver.

PDO_MYSQLND inherits all benefits of the MySQL native driver for PHP. In addition to the shared advantages you get the first PDO driver for MySQL developed by Sun/MySQL!

Every so often I try to use PDO under PHP5, and every time I run in to basic functionality problems with no ability to find out what's going on under the hood.

He includes a few comments supporting his statement including an issue where a prepare() call didn't work, his frustration with not being able to see what's "under the hood" and the lack of documentation to help with these sorts of issues.

I spent quite a lot of time comparing the different behaviours of the various drivers in the hope I could find out how PDO drivers are supposed to work. The PDO documentation and the specification do not cover each and every detail. PDO really needs some love...

He picks out the FETCH_UNIQUE constant as one that needs a little work and tries to track down exactly what it's doing. One issue he found was that it requires combination with other flags to make the unique part of it work correctly (like FETCH_OBJ or FETCH_COLUMN). He works through several examples, both ones that apply the unique call and others that don't, comparing the results.

If you try to get informations about parameters from methods of internal classes - forget that. Examining several internal classes my key findings are: either there is no information about parameters available and the reflection API says the method does not have any parameters, or the information about the parameter is wrong.

He includes code examples along side the output from the script to illustrate his point.

It became apparent over the past year or so that PDO has been a good and valuable addition to PHP. [...] We believe that having direct involvement from the data access providers would be most effective, which is why we set out to try and get them on board.

There were three steps they would need to make to push things to version two (documentation, define scope/direction and organize data provider integration methods) and the proposal that has caused a huge stir in the community - the idea of requiring a CLA contributors would need to sign.

Comments to this point from the community include:

• Richard Thomas
• Antony Dovgal
• some of Wez's own comments
• Mike Willbanks
• Christopher Jones
• Lukas Smith
• Paul Jones
• Pierre-Alain Joye
• Jay Pipes
• Derick Rethans
• Marco Tabini
• Kristian Kohntopp
• Some PDO humor from David Coallier and Travis Swicegood
• Marcus Borger (and his part two)
• Richard Heyes
• Till's blog entry
• Say No to the CLA

While Core does ship with a large list of extensions (which are all QA'd and supported by Zend) there are times when you would like to include non-official extensions from PECL for various reasons.

He breaks it down into a few simple steps - download, "phpize" the extension, compile it and add the extension to the php.ini. He details the second step of the process (the phpize) because of some of the differences there are between doing it for a normal PHP install and a Zend Core install.

He also provides directions for an exception to the rule - compiling a PDO driver for your ZC install. You'll have to trick the Zend Core installation into using the right files, though. Full instructions are included.