ADOdb Database Library for PHP

Visit Publisher Site

A PHP4 and PHP5 database abstraction library. Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, PDO etc. ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly. A basic paginated grid is also provided, and support for database-backed session variables. Support for PHP5 iterators and exceptions included. Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML.

Visit publisher site: ADOdb Database Library for PHP
  • Thanks for your rating. Consider leaving a review and let others know more about your experience. Add ReviewClose
    Rated 4.78 out of 5 (983 ratings)
  • 2 Member Reviews
  • Views: 58,777
  • Price: Free

Listing Details

Filed in:
Scripts / PHP / Scripts & Programs / Database Tools
Submitted on:
Last Updated:
Feb 11, 2009 
Other listings by this publisher

License & Pricing Information

License Type:
Additional Info:
LGPL also
License Type:
Additional Info:
LGPL also

User Reviews 

Add/Edit Your Review
Average Member Rating: 4.78/5

Displaying 1-2 out of 2 reviews

  • Sure, you're using MySQL and PHP has built-in functions for MySQL... But a year from now you decide you want transactions and stored functions and you decide to go with PostgreSQL. Then you gotta take the time to re-write all you code for the new db. Save the grief and go with ADOdb! As a pleasant side effect you'll get a wonderful caching recordset object with all the methods you'll (likely) ever want and auto-generated SQL. The only bad thing about ADOdb is keeping up with all the frequent and useful updates (just package installs, not API changes)!

  • This abstraction library goes well beyond the call of duty, it includes database abstraction for most database servers but it also includes database result set caching and more. I've found it very powerful and now use it even in some applications that don't require database abstraction because it provides a common interface to the server.

See all 2 reviews for ADOdb Database Library for PHP