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 +