|
Agile Toolkit
4.2
Agile Toolkit is a powerful web development framework. Inspired by GUI Applications development
|
Public Member Functions | |
| connect ($dsn=null) | |
| dsql ($class=null) | |
| query ($query, $params=array()) | |
| getOne ($query, $params=array()) | |
| lastID ($statement=null, $table=null) | |
| beginTransaction () | |
| commit () | |
| inTransaction () | |
| rollBack ($option=null) | |
Data Fields | |
| $dbh = null | |
| $type = null | |
| $dsql_class = 'DB_dsql' | |
| $transaction_depth = 0 | |
Implementation of PDO support in Agile Toolkit
Use: $this->api->dbConnect(); $query = $this->api->db->dsql();
| beginTransaction | ( | ) |
| commit | ( | ) |
| connect | ( | $ | dsn = null | ) |
| dsql | ( | $ | class = null | ) |
Returns Dynamic Query object compatible with this database driver (PDO)
Reimplemented in DB_prefixed.
| getOne | ( | $ | query, |
| $ | params = array() |
||
| ) |
Executes query and returns first column of first row
| inTransaction | ( | ) |
| lastID | ( | $ | statement = null, |
| $ | table = null |
||
| ) |
Returns last ID after insert. Driver-dependant. Redefine if needed.
| query | ( | $ | query, |
| $ | params = array() |
||
| ) |
Query database with SQL statement
| rollBack | ( | $ | option = null | ) |
| $dbh = null |
Link to PDO database handle
| $dsql_class = 'DB_dsql' |
| $transaction_depth = 0 |
| $type = null |
Contains name of the PDO driver used such as "mysql", "sqlite" etc