ADOdb Database Library for PHP

PHP is a wonderful language for building dynamic web pages. Unfortunately, PHP's database access functions are not standardised. Every database extension uses a different and incompatibile API. This creates a need for a database class library to hide the differences between the different databases (encapsulate the differences) so we can easily switch databases.

ADOdb stands for Active Data Objects Data Base. We currently support MySQL, PostgreSQL, Interbase, Informix, Oracle, MS SQL 7, Foxpro, Access, ADO, Sybase, DB2 and generic ODBC. The Sybase, Informix and PostgreSQL drivers are community contributions. We hope more people will contribute drivers to support more databases.
Unique Features of ADOdb

* Easy for Windows programmers to understand. Makes porting ASP code to PHP easy because many of the conventions are similar to Microsoft's ADO.
* We provide support code to handle inserts and updates which can be adapted to multiple databases quickly. Methods are provided for date handling, string concatenation and string quoting characters for differing databases.
* A metatype system is built in so that we can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases.
* Easy to port because all the database dependant code are stored in stub functions. You do not need to port the core logic of the classes.
* SQL to popup menu (<SELECT>) support included
* PHP4 Session support.

Added:  Saturday, January 18, 2003
Reviewer:  Charles Maguire
Score:
Related Link:  ADOdb Web Site
hits: 1138