PHP Script Codes > ADOdb Database Library for PHP
A PHP4 and PHP5 database abstraction library.
Supports MySQL, PostgreSQL, Interbase/Firebird, Oracle (Oci8), MS SQL 7, ADO, Foxpro, Access, Sybase, Sybase SQL Anywhere, DB2, Informix, Frontbase, SQLite, LDAP, Netezza, SAPDB, generic ODBC/ODBTP, PDO etc.
ADOdb provides code to handle inserts and updates that can be adapted to multiple databases quickly. A basic paginated grid is also provided, and support for database-backed session variables.
Support for PHP5 iterators and exceptions included.
Methods are provided for date handling, string concatenation and string quoting characters for differing databases. A metatype system is built in so that you can figure out that types such as CHAR, TEXT and STRING are equivalent in different databases. Able to create databases, tables, indexes portably using an xml schema or programatically. Also has sql performance monitoring and schema creation using XML.