anyDB

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().

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.

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.

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.