Just published today on the Oracle Technology Network is my article on PDO, giving an overview of what it is, installation, sample code, portability and so on.
Although it has a focus on Oracle, pretty much everything covered there should be portable to the other available pdo drivers with minimal changes (essentially just the parameters to your connection), if you are writing portable SQL.
Please do read it, even if you're only mildly curious, as the stipend I earned from writing the article effectively paid for some of my time working on PDO. As it was actually written a few weeks back (OTN has a long publishing process), the "Future of" section is missing details of the iterator (eg: foreach) support that Marcus keeps nagging me to merge in.
I would of liked to use pdo in some new stuff im working on but there is currently no mysqli driver ;)
Also, a suggested method for pdo
fetch_all()
Pulls ever row returned as and assoc array. Having something like this at the "interface" C level code would benifit so many people I am sure.
This article is a better niveau than the preceding : "ASP.NET vs PHP5" :D
Ilia added this one a while back:
proto array PDOStatement::fetchAll([int $how = PDO_FETCH_BOTH]) Returns an array of all of the results.
Wez Furlong in
Comment.
Sweet, I got a few class librarys I have been meaning to translate over to php5 and mysqli, I think I will hold off now for a mysqli driver to do it, PDO is sweet