Projects / ADODB


ADODB is a set of advanced PHP database abstraction classes. It supports MySQL, PostgreSQL, Interbase/Firebird, Informix, Sybase SQL Anywhere, Oracle, MS SQL 7 and 2000, SAP DB, Sybase, DB2, FrontBase, Foxpro, Access, Netezza, LDAP, ODBTP, ADO, and generic ODBC. A metatype system is built in, making it possible to figure out that types such as CHAR, TEXT, and STRING are equivalent in different databases. It also features portable database creation, database-backed session support (with encryption), SQL performance monitoring, and database health checks.

Operating Systems

Recent releases

  •  04 May 2006 19:21

    Release Notes: This release can cache table metadata (field names, types, and other info such primary keys). It only updates fields that have changed. Variable ref errors in have been fixed. There is a Mysqli setcharset fix using method_exists(). The CreateLogTable() code now works for user-defined table names. An error in ibase_blob_open() has been fixed. This release no longer includes auto_increment fields in replace().

    •  29 Mar 2006 09:42

      Release Notes: Activerecord support was added. A flag for choosing compatibility with MySQL 3.23 was added. GetOne() Select-Limit problems were fixed. was added to support XML Schema version 3. The adodb-datadict.htm documents were updated.

      •  21 Dec 2005 00:52

        Release Notes: Fixes to PostgreSQL drivers to support PHP 5.1, partial PDO support, support for PHP 5.1, PHP 5 compatibility for mysqli, and many PDO improvements. A spelling error has been fixed in the MySQL MetaForeignKeys $associative parameter. MetaForeignKeys was repeated twice and the MYSQLI_BINARY_FLAG was missing. PHP 5.1 support for PostgreSQL bind parameters using ? now works.

        •  17 Nov 2005 14:41

          Release Notes: The Sqlite driver is now PHP 5 compliant. The PostgreSQL not_null flag is now set to false correctly. A check is now done in Replace() to test whether a key is in fieldArray. The _file_get_contents() function was missing in xmlschema. Week in year support was added to SQLDate(), using the "W" flag. In sqlite, metacolumns was repeated twice, causing a PHP 5 crash. The debug output XHTML was made compliant.

          •  11 Nov 2004 19:39

            Release Notes: Extensive data dictionary changes. The BlobDecode API for PostgreSQL has changed. This might continue to change in the next release. Support for the charSet feature in oci8's P/N/Connect(). Some bugfixes, and compatibility changes for PHP5.

            Recent comments

            11 Apr 2001 17:03 jlim

            Re: New version 0.20
            For examples of how ADODB is used, visit (

            01 Feb 2001 15:49 devnull000

            Re: New version 0.20

            Hmm... haven't we seen this name (ADODB) somewhere before?

            The "93" is a nice touch, though.


            12 Sep 2000 08:05 jlim

            New version 0.20
            Added ADO support.



            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.