<XSTYLE body,td {font-family:Arial,Helvetica,sans-serif;font-size:11pt} pre {font-size:9pt} .toplink {font-size:8pt} />

### ADOdb Library for PHP

ADOdb is a suite of database libraries that allow you to connect to multiple databases in a portable manner. Download from http://php.weblogs.com/adodb.

- The ADOdb documentation has moved to docs-adodb.htm. This allows you to query, update and insert records using a portable API.
- The ADOdb data dictionary docs are at docs-datadict.htm. This allows you to create database tables and indexes in a portable manner.
- The ADOdb database performance monitoring docs are at docs-perf.htm. This allows you to perform health checks, tune and monitor your database.
- The ADOdb database-backed session docs are at docs-session.htm.
- The ADOdb Date Time Library documentation to support dates outside the 32-bit range, at adodb_date_time_library.

### Installation

Make sure you are running PHP4.0.4 or later. Unpack all the files into a directory accessible by your webserver.

To test, try modifying some of the tutorial examples. Make sure you customize the connection settings correctly. You can debug using:

    <?php
    include('adodb/adodb.inc.php');

    $db = ADONewConnection($driver); # eg. 'mysql' or 'oci8'
    $db->debug = true;
    $db->Connect($server, $user, $password, $database);
    $rs = $db->Execute('select * from some_small_table');
    print "<pre>";
    print_r($rs->GetRows());
    print "</pre>";
    ?>

### How are people using ADOdb

Here are some examples of how people are using ADOdb (for a much longer list, visit http://php.weblogs.com/adodb-cool-applications):

- PhpLens is a commercial data grid component that allows both cool Web designers and serious unshaved programmers to develop and maintain databases on the Web easily. Developed by the author of ADOdb.
- PHAkt: PHP Extension for DreamWeaver Ultradev allows you to script PHP in the popular Web page editor. Database handling provided by ADOdb.
- Analysis Console for Intrusion Databases (ACID): PHP-based analysis engine to search and process a database of security incidents generated by security-related software such as IDSes and firewalls (e.g. Snort, ipchains). By Roman Danyliw.
- PostNuke is a very popular free content management system and weblog system. It offers full CSS support, HTML 4.01 transitional compliance throughout, an advanced blocks system, and is fully multi-lingual enabled.
- EasyPublish CMS is another free content management system for managing information and integrated modules on your internet, intranet- and extranet-sites. From Norway.
- NOLA is a full featured accounting, inventory, and job tracking application. It is licensed under the GPL, and developed by Noguska.