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 Internet Web Dynamic Content Software Development Libraries php classes
Licenses LGPL BSD Original
Operating Systems Windows Windows Windows Windows POSIX BSD Linux Solaris
Implementation PHP

Tweet this project Short link

Rss Recent releases

  • Rrelease-mid
  •  04 May 2006 12:21
  • Rrelease-after

Changes: 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().

  • Rrelease-mid
  •  29 Mar 2006 01:42
  • Rrelease-after

Changes: 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.

  • Rrelease-mid
  •  20 Dec 2005 16:52
  • Rrelease-after

Changes: 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.

  • Rrelease-mid
  •  17 Nov 2005 06:41
  • Rrelease-after

Changes: 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.

  • Rrelease-mid
  •  11 Nov 2004 11:39
  • Rrelease-after

    Changes: 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

    Rcomment-before 11 Apr 2001 17:03 Rcomment-trans jlim Rcomment-after

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

    Rcomment-before 01 Feb 2001 15:49 Rcomment-trans devnull000 Rcomment-after

    Re: New version 0.20

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

    The "93" is a nice touch, though.

    WILL
    LOVE

    Rcomment-before 12 Sep 2000 08:05 Rcomment-trans jlim Rcomment-after

    New version 0.20
    Added ADO support.

    See http://php.weblogs.com/adodb_manual#changes

    C98a845b7d975e66f3a9ff98ada599d5_thumb

    Project Spotlight

    Bluefish

    A GTK-based Web development editor.

    78698f74b1474080b49b4abbf7c7312c_thumb

    Project Spotlight

    Chestnut FTP Search

    A Web application to search files on FTP servers.