//////////////////////////////////////////////////////////////////////// NOTE: You need to download the whole package, otherwise things will probably not work! //////////////////////////////////////////////////////////////////////// Version 1.2: DBS: - new layer for ODBC connections - pgsql and sqlite check if php extension dll is installed - reworked code DONE: msql, postgres, sqlite, adodb GENERAL: - more information for errors array $errors[] contains timestamp, string, function and stacktrace DONE: mysql, postgres, sqlite, adodb - getTables() supported by now by postgres, odbc, mysql and sqlite INTERFACE: - new function setDB() changes the db - new function getDataId() checks if a certain dataset already exists and returns the id DONE: mysql, postgres, sqlite, adodb - new function getMapped() works as getAll() but uses one of the result fields as an array key - changed getValue() it can now return strings, boolean, integer and float values - changed getNext() supports now result objects - new function getInsertId() returns the id of the last INSERT statement DONE: mysql, postgres, sqlite, adodb - sqlites' connect() checks if database file exists and does not create a new one ADDONS: - enhanced DBHelper::getSelectBox() you can now pass names and (optionally) values to the drop down BUGS: - fixed bug in escapeStr() - fixed bug in anyDB::getLayer //////////////////////////////////////////////////////////////////////// Version 1.0: GENERAL: - fixed bug in QueryHelper DBS: - added db class for DBX (http://dbx.idya.net/) a flatfile xml-based db class - added db class for SQLite (http://www.sqlite.org/, http://www.php.net/manual/de/ref.sqlite.php) a binary flatfile db class ADDONS: - added possible to pass a where clause to the PageWidget class - added function dbxLimitFunction() for supporting DBX DOCS: - rewrote all example files - enhanced the documentation - updated apidoc //////////////////////////////////////////////////////////////////////// Version 0.9: GENERAL: - changed project name to anyDB - changed name of AbstractDB.php to anyDB.phy - possible to choose between persistent and non-persistent connections - phpdoc for all classes (use phpDoucmentor to generate it yourself) - added directory with test scripts for easy functionality test - fixed bug within the error storage - made include paths more secure - renamed all the constants: NUMERIC_RESULT --> ANYDB_RES_NUM ASSOCIATIVE_RESULT --> ANYDB_RES_ASSOC BOTH --> ANYDB_RES_BOTH PREDEFINED_VALUE --> ANYDB_PREDEFINED_VALUE INTERFACE: - new function getVersion() - new function escapeStr() for all dbs - new function getTables() for all dbs - new function anyDB::wrapDB() to use an existing connection of ADODB, Metabase, etc. for usage with anyDB - renamed getDbLayer() to getLayer() in anyDB.php ADDONS: - new class for exporting db and table contents to SQL and CSV: Exporter - function getMin() added in DBHelper - improved object hierachy for the helper classes DBS: - added native POSTGRESQL wrapper class PostgresDB.php - removed unnecessary code from AdodbDB.php - cleaned up PhplibDB.php and MetabaseDB.php ARCHITECTURE: - changed the inheritance structure - introduced a new base class 'UtilityClass' //////////////////////////////////////////////////////////////////////// Version 0.8: GENERAL: - created directory structure to make things easier to find - redesigned AbstractDB.php and added BasicDB.php to seperate interface from implementation INTERFACE: - due to request I changed the names (yes, it will be the last change, I promise!) for the getXXX functions. DBS: - improved MetabaseDB and ADODB ADDONS: - new helper class QueryHelper for generating SELECT, INSERT, DELETE, UPDATE and REPLACE queries - new functions in DBHelper: function dumpColumn($array, $horizontal = true, $headerTitle = '') function getCount(& $db, $tableName) function getMax(& $db, $tableName) ////////////////////////////////////////////////////////////////////////