ADOdb

ADOdb is a database abstraction library for PHP. It currently supports the following databases: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions.

Usage

The database interface is accessed via the wrapper class eaDB located in code/base/db.class.php. The wrapper provides basic set-up procedures and database functions.

It’s integrated by:

require_once('code/base/db.class.php')

$db = new eaDB($conf['dsn']);

$conf[‘dsn’] is set in config/config.php

$conf['dsn'] = 'driver://user:password@server/database';

with

driver ..... type of database - e.g. <i>mysql</i>
user ....... the username of the database account
password ... the password of the database account
server ..... the server, where the database is located - e.g. <i>localhost</i>
database ... the name of the database - e.g. <i>eageier</i>

See the Reference Guide for more detailed information.

Bundling

The ADOdb library will be bundled with production releases.

But as 3rd-party product it will not be checked into the repository.

If the ADOdb code is missing in your ea-Geier distribution, please download it from the ADOdb homepage.

Unzip the code into the 3party/adodb/ folder – e.g.:

3party/adodb/adodb516/

and make sure the eaADODB_DIR definition is configured properly. To do this, open the the file code/config.php. Look for eaADODB_DIR and change the value to the name of the folder you have just uploaded – e.g.:

define('eaADODB_DIR', '3party/adodb/adodb516/');

Note

Since the ADOdb library is not E_STRICT compatible we disabled E_STRICT for the complete project.