ezPDO

ezPDO is a PHP database access library. It provides the same interface (mostly) as the popular library ezSQL, but uses PDO internally. PDO provides a number of benefits:

Multiple database support - the library supports any database that PDO supports
Prepared statements to prevent SQL injection and improve performance in case multiple queries are being performed in a loop
Completely object oriented - can throw exceptions(!)
Google around for more details on what PDO is capable of. It's very cool...

Download or check out from:

http://208.78.102.143/svn/ezpdo/trunk/

Why?

If you've used both ezSQL and PDO, you'll be wondering why ezPDO is even required as you can do most of the things that ezSQL is good at (a simple API to connect to a DB and retrieve multiple rows, single row or column in multiple formats like an object, associative array etc.) out of the box with PDO. The main reason I wrote this is because I needed a drop in replacement to ezSQL with minimal changes to code in large existing projects. Of course, I've taken care to implement all the features of ezSQL I used, so it may not be a drop in replacement for you.

That said, ezPDO does retain the same familiar API, while providing the power of PDO underneath. In case you need to access some advanced features of PDO that ezPDO does not expose, it provides access to the connection handle, giving you the flexibility of using PDO directly. It also retains the useful debug output facilities. Having a wrapper around PDO is not a performance hit unless you see traffic on the scale of a Yahoo!, Flickr or Facebook.

The library also provides a pooling mechanism to hold ezPDO connection handles when connecting to multiple databases at the same time. It also allows easy retrieval of a handle without having to declare it as global in functions and class methods.

Bugs, suggestions or feedback? Please send it to thejo@kote.in

Home