anyDB is a PHP database class which provides easy access the most important database functions. It contains classes to access MySQL, Postgres, ODBC, and SQLite and provides wrapper classes to other popular database classes like PEAR:DB, PHPLIB, ADOdb, and METABASE.
|Tags||Software Development Libraries php classes Database|
Release Notes: This release has a new database layer for ODBC, an enhanced getTables() function, and adds the functions getDBs(), setDB(), getInsertId(), getDataId(), and getMapped(). It changes getValue(), updates PageWidget, enhances DBHelper::selectBox(), adds DBHelper::checkBoxes(), DBHelper::radioButtons(), and DBHelper::cloneDataset(), enhances DBHelper::dumpAll(), dumpColumn, and dumpNext(), fixes a bug in escapeStr(), and fixes a bug in anyDB::getLayer().
Release Notes: A class was added for DBX, an XML-based database. SQLite is now also supported. It is now possible to pass a WHERE clause to the PageWidget class. A dbxLimitFunction() was included for DBX. All of the example files were rewritten and the documentation was updated.
No changes have been submitted for this release.
Release Notes: A directory structure was implemented to make things easier to find. AbstractDB.php was redesigned and BasicDB.php was added to seperate interface from implementation. The names of the getXXX functions were changed. Support for MetabaseDB and ADODB was improved, and a new QueryHelper helper class was added for generating SELECT, INSERT, DELETE, UPDATE, and REPLACE queries. New dumpColumn, getCount, and getMax functions were added to DBHelper.
Release Notes: A new class (PageWidget.php) for presenting page-based information like in guestbooks, a new function execute() for AbstractDB (it incorporates the query() and allResults() methods for faster access), and new functions with shorter names but equal functionality for accessing results (next(), all(), nextValue(), allValues(), free()). Old functions still work and won't be deprecated for quite a while. A selectBox() function was added in DBHelper.php for dumping a result array in a html select box, and error message handling was improved in MysqlDB.php's constructor.