Projects / ADODB

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.

Tags
Licenses
Operating Systems
Implementation

RSS Recent releases

  •  04 May 2006 12: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 adodb-ado5.inc.php have been fixed. There is a Mysqli setcharset fix using method_exists(). The adodb-perf.inc.php 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 01:42

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

  •  20 Dec 2005 16: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 06: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 11: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.

    RSS Recent comments

    11 Apr 2001 17:03 jlim Thumbs up

    Re: New version 0.20
    For examples of how ADODB is used, visit php.weblogs.com/adodb-.... (php.weblogs.com/adodb-...)

    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.

    WILL
    LOVE

    12 Sep 2000 08:05 jlim Thumbs up

    New version 0.20
    Added ADO support.

    See php.weblogs.com/adodb_...

    Screenshot

    Project Spotlight

    r-nu

    An R-Type-based game.

    Screenshot

    Project Spotlight

    NetXMS

    A network monitoring and management system.