Login   Register  
PHP Classes
elePHPant
Icontem

File: anyDB.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of L  >  anyDB  >  anyDB.php  
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
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: 9 years ago
Size: 11,312 bytes

You need to be a registered user and login to get this file.

Login Immediately with your account on:

Facebook ConnectGmail or other Google AccountHotmail or Microsoft Windows LiveStackOverflowGitHubYahoo