ADODB

ADOdb is a database abstraction library for PHP.

The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: 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.

Many popular web applications such as ACID, PostNuke, Xaraya, phpWiki, Mambo, PHP GACL, TikiWiki, eGroupWare and phpLens App Server are using ADOdb as their database abstraction layer.

Features:

• Designed for speed. It is probably the fastest open source database abstraction library available for PHP. See benchmarks.
• Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
• Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
• Easy to learn, especially if you have Window's programming experience, as it uses many ADO conventions.
• Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
• Mature, continiously developed since August 2000. Has a large community of users.
• Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release. Also dual-licensed (Lesser GPL).

What is new in this release:

• oci8 driver: For backward compat oci8 driver $this->sysTimeStamp reverted back to "SYSDATE" from "SYSTIMESTAMP";
• ads driver: Driver file wrongly named. Fixed.

What is new in version 509:

• Removed all ereg().
• Ensure all function parameters are consistent with parent class
• Now DBDate and DBTimeStamp will use PHP5 DateTime class for date/time conversion
• New datadict type TS for timestamp that supports subsecond accuracy. Currently only available for postgresql, mssql and oci8 datadict drivers.
• Improved adodb-sessions2 driver. All users encouraged to upgrade.
• Added new DSN parameters to support memcache:
• we have a memcache servers mem1,mem2 on port 8888, compression=off and cachesecs=120
• $dsn = 'mysql://user:pwd@localhost/mydb?memcache=mem1,mem2:8888:0&cachesecs=120';
• $db = NewADOConnection($dsn);
• Various bug fixes as usual.

What is new in version 508:

• adodb-sybase.inc.php driver. Added $conn->charSet support. Thx Luis Henrique Mulinari (luis.mulinari#gmail.com)
• adodb-ado5.inc.php. Fixed some bind param issues. Thx Jirka Novak.
• adodb-ado5.inc.php. Now has improved error handling.
• Fixed typo in adodb-xmlschema03.inc.php. See XMLS_EXISTING_DATA, line 1501. Thx james johnson.
• Made $inputarr optional for _query() in all drivers.
• Fixed spelling mistake in flushall() in adodb.inc.ophp.
• Fixed handling of quotes in adodb_active_record::doquote. Thx Jonathan Hohle (jhohle#godaddy.com).
• Added new index parameter to adodb_active_record::setdatabaseadaptor. Thx Jonathan Hohle
• Fixed & readcache() reference compat problem with php 5.3 in adodb.Thx Jonathan Hohle.
• Some minor $ADODB_CACHE_CLASS definition issues in adodb.inc.php.
• Added Reset() function to adodb_active_record. Thx marcus.
• Minor dsn fix for pdo_sqlite in adodb.inc.php. Thx Sergey Chvalyuk.
• Fixed adodb-datadict _CreateSuffix() inconsistencies. Thx Chris Miller.
• Option to delete old fields $dropOldFlds in datadict ChangeTableSQL($table, $flds, $tableOptions, $dropOldFlds=false) added. Thx Philipp Niethammer.
• Memcache caching did not expire properly. Fixed.
• MetaForeignKeys for postgres7 driver changed from adodb_movenext to $rs->MoveNext (also in 4.99)
• Added support for ldap and ldaps url format in ldap driver.

What is new in version 507:

• BeginTrans/CommitTrans/RollbackTrans return true/false correctly on success/failure now for mssql, odbc, oci8, mysqlt, mysqli, postgres, pdo.
• Replace() now quotes all non-null values including numeric ones.
• Postgresql qstr() now returns booleans as true and false without quotes.
• MetaForeignKeys in mysql and mysqli drivers had this problem: A table can have two foreign keys pointing to the same column in the same table. The original code will incorrectly report only the last column. Fixed. https://sourceforge.net/tracker/index.php?func=detail&aid=2287278&group_id=42718&atid=433976
• Passing in full ado connection string in $argHostname with ado drivers was failing in adodb5 due to bug. Fixed.
• Fixed memcachelib flushcache and flushall bugs. Also fixed possible timeCreated = 0 problem in readcache. (Also in adodb 4.992). Thanks AlexB_UK (alexbarnes#hotmail.com).
• Fixed a notice in adodb-sessions2.inc.php, in _conn(). Thx bober m.derlukiewicz#rocktech.remove_me.pl;
• ADOdb Active Record: Fixed some issues with incompatible fetch modes (ADODB_FETCH_ASSOC) causing problems in UpdateActiveTable().
• ADOdb Active Record: Added support for functions that support predefining one-to-many relationships: ClassHasMany ClassBelongsTo TableHasMany TableBelongsTo TableKeyHasMany TableKeyBelongsTo. You can also define your child/parent class in these functions, instead of the default ADODB_Active_Record. Thx Arialdo Martini & Chris R for idea.
• ADOdb Active Record: HasMany hardcoded primary key to "id". Fixed.
• Many pdo and pdo-sqlite fixes from Sid Dunayer [sdunayer#interserv.com].
• CacheSelectLimit not working for mssql. Fixed. Thx AlexB.
• The rs2html function did not display hours in timestamps correctly. Now 24hr clock used.
• Changed ereg* functions to use preg* functions as ereg* is deprecated in PHP 5.3. Modified sybase and postgresql drivers.

What is new in version 506:

• Added driver adodb-pdo_sqlite.inc.php. Thanks Diogo Toscano (diogo#scriptcase.net) for the code.
• Added support for one-to-many relationships with BelongsTo() and HasMany() in adodb_active_record.
• Added BINARY type to mysql.inc.php (also in 4.991).
• Added support for SelectLimit($sql,-1,100) in oci8. (also in 4.991).
• New $conn->GetMedian($table, $field, $where='') to get median account no. (also in 4.991)
• The rs2html() function in tohtml.inc.php did not handle dates with ':' in it properly. Fixed. (also in 4.991)
• Added support for connecting to oci8 using $DB->Connect($ip, $user, $pwd, "SID=$sid"); (also in 4.991)
• Added mysql type 'VAR_STRING' to MetaType(). (also in 4.991)
• The session and session2 code supports setfetchmode assoc properly now (also in 4.991).
• Added concat support to pdo. Thx Andrea Baron.
• Changed db2 driver to use format "Y-m-d H-i-s" for datetime instead of "Y-m-d-H-i-s" which was legacy from odbc_db2 conversion.
• Removed vestigal break on adodb_tz_offset in adodb-time.inc.php.
• MetaForeignKeys did not work for views in MySQL 5. Fixed.
• Changed error handling in GetActiveRecordsClass.
• Added better support for using existing driver when $ADODB_NEWCONNECTION function returns false.
• In _CreateSuffix in adodb-datadict.inc.php, adding unsigned variable for mysql.
• In adodb-xmlschema03.inc.php, changed addTableOpt to include db name.
• If bytea blob in postgresql is null, empty string was formerly returned. Now null is returned.
• Changed db2 driver CreateSequence to support $start parameter.
• rs2html() now does not add nbsp to end if length of string > 0
• The oci8po FetchField() now only lowercases field names if ADODB_ASSOC_CASE is set to 0.
• New mssqlnative drivers for php. TQ Garrett Serack of M'soft. Note that this is still in beta.
• Fixed bugs in memcache support.
• You can now change the return value of GetOne if no records are found using the global variable $ADODB_GETONE_EOF. The default is null. To change it back to the pre-4.99/5.00 behaviour of false, set $ADODB_GETONE_EOF = false;
• In Postgresql 8.2/8.3 MetaForeignkeys did not work. Fixed William Kolodny William.Kolodny#gt-t.net

Requirements:

• Python