| File: |
anyDB.php |
| Role: |
Class source |
| Content type: |
text/plain |
| Description: |
class for instancating instances of AbstractDB |
| Class: |
anyDB
DB class for MYSQL, POSTGRES, SQLITE, PHPLIB, ODBC |
| Author: |
By L |
| Last change: |
GENERAL:
- I stopped supporting PHLIB and IDYA.DBX, since they did not release any updates
since last year to their code. They seem to be dead. Let me know if you still need them.
- more information for errors
array $errors[] contains timestamp, string, function and stack trace of all errors
- results can now be returned as objects
works with: MYSQL, POSTGRESQL, SQLITE, ADODB, PEAR
DBS:
- new database layer for ODBC
- layers check if their php extension is installed
for POSTGRESQL and SQLITE
- added function to extend SQLITE to support the UPDATE statement
ALTER TABLE tbl_name alter_specification [, alter_specification] ...
alter_specification:
ADD column_definition
| DROP column_definition
| CHANGE old_col_name column_definition
column_definition:
same as for create table statements
INTERFACE:
- enhanced getTables() function
works with: MYSQL, POSTGRES, ADODB, ODBC, SQLITE, PEAR
- new function getDBs()
returns an array with the available databases
works with: MYSQL, POSTGRES, ADODB
- new function setDB()
changes the current database
- new function getInsertId()
returns the id of the last INSERT statement
- new function getDataId()
checks if a certain dataset already exists and returns the id
- new function getMapped()
works like getAll() but uses one of the result fields as an array key
- changed getValue()
it can now return strings, boolean, integer and float values
ADDONS:
- updated PageWidget
predefined paging functions for MYSQL, POSTGRESQL, MS ACCESS, SQLITE, DBX
- enhanced DBHelper::selectBox()
you can now pass names and (optionally) values to the drop down
- added DBHelper::checkBoxes(), DBHelper::radioButtons()
similar functionality to selectBox()
- added DBHelper::cloneDataset()
creates a copy of a dataset
-enhanced DBHelper::dumpAll(), dumpColumn, dumpNext()
you can now pass additional string to the TABLE, TR, TH and TD tags
BUGS:
- fixed bug in escapeStr()
- fixed bug in anyDB::getLayer() |
| Date: |
20 years ago |
| Size: |
11,312 bytes |
|
|
|
