PDO wrapper. - More...
-
- 
Inheritance diagram for DB\SQL:
- Inheritance diagram for DB\SQL:
-
-
-
-
- -Public Member Functions | |
| begin () | |
| rollback () | |
| commit () | |
| type ($val) | |
| value ($type, $val) | |
| exec ($cmds, $args=NULL, $ttl=0, $log=TRUE) | |
| count () | |
| log () | |
| schema ($table, $fields=NULL, $ttl=0) | |
| quote ($val, $type=\PDO::PARAM_STR) | |
| uuid () | |
| driver () | |
| version () | |
| name () | |
| quotekey ($key) | |
| __construct ($dsn, $user=NULL, $pw=NULL, array $options=NULL) | |
-Public Attributes | |
| - | $dsn |
| Data source name. | |
| - | $engine |
| Database engine. | |
| - | $dbname |
| Database name. | |
| - | $trans =FALSE |
| Transaction flag. | |
| - | $rows =0 |
| Number of rows affected by query. | |
| - | $log |
| SQL log. | |
-Protected Attributes | |
| - | $uuid |
| UUID. | |
Detailed Description
-PDO wrapper.
-Constructor & Destructor Documentation
- -
-
-
-
-
-
| DB\SQL::__construct | -( | -- | $dsn, | -
| - | - | - | $user = NULL, |
-
| - | - | - | $pw = NULL, |
-
| - | - | array | -$options = NULL |
-
| - | ) | -- |
-
-Instantiate class
-- Parameters
-
-
-
-$dsn string $user string $pw string $options array
-
Member Function Documentation
- -
-
-
-
-
-
-
| DB\SQL::begin | -( | -) | -- |
-
-Begin SQL transaction
-- Returns
- bool
-
-
-
-
-
-
| DB\SQL::commit | -( | -) | -- |
-
-Commit SQL transaction
-- Returns
- bool
-
-
-
-
-
-
| DB\SQL::count | -( | -) | -- |
-
-Return number of rows affected by last query
-- Returns
- int
-
-
-
-
-
-
| DB\SQL::driver | -( | -) | -- |
-
-Return database engine
-- Returns
- string
-
-
-
-
-
-
| DB\SQL::exec | -( | -- | $cmds, | -
| - | - | - | $args = NULL, |
-
| - | - | - | $ttl = 0, |
-
| - | - | - | $log = TRUE |
-
| - | ) | -- |
-
-Execute SQL statement(s)
-- Returns
- array|int|FALSE
- Parameters
-
-
-
-$cmds string|array $args string|array $ttl int $log bool
-
-
-
-
-
-
-
| DB\SQL::log | -( | -) | -- |
-
-Return SQL profiler results
-- Returns
- string
-
-
-
-
-
-
| DB\SQL::name | -( | -) | -- |
-
-Return database name
-- Returns
- string
-
-
-
-
-
-
| DB\SQL::quote | -( | -- | $val, | -
| - | - | - | $type = \PDO::PARAM_STR |
-
| - | ) | -- |
-
-Quote string
-- Returns
- string
- Parameters
-
-
-
-$val mixed $type int
-
-
-
-
-
-
-
| DB\SQL::quotekey | -( | -- | $key | ) | -- |
-
-Return quoted identifier name
-- Returns
- string
- Parameters
-
-
-
-$key
-
-
-
-
-
-
-
| DB\SQL::rollback | -( | -) | -- |
-
-Rollback SQL transaction
-- Returns
- bool
-
-
-
-
-
-
| DB\SQL::schema | -( | -- | $table, | -
| - | - | - | $fields = NULL, |
-
| - | - | - | $ttl = 0 |
-
| - | ) | -- |
-
-Retrieve schema of SQL table
-- Returns
- array|FALSE
- Parameters
-
-
-
-$table string $fields array|string $ttl int
-
-
-
-
-
-
-
| DB\SQL::type | -( | -- | $val | ) | -- |
-
-Map data type of argument to a PDO constant
-- Returns
- int
- Parameters
-
-
-
-$val scalar
-
-
-
-
-
-
-
| DB\SQL::uuid | -( | -) | -- |
-
-Return UUID
-- Returns
- string
-
-
-
-
-
-
| DB\SQL::value | -( | -- | $type, | -
| - | - | - | $val | -
| - | ) | -- |
-
-Cast value to PHP type
-- Returns
- scalar
- Parameters
-
-
-
-$type string $val scalar
-
-
-
-
-
-
| DB\SQL::version | -( | -) | -- |
-
-Return server version
-- Returns
- string
The documentation for this class was generated from the following file:
-
-
- db/sql.php -