MySqliDriver
class MySqliDriver implements Driver, ResultDriver
The dibi driver for MySQL database via improved extension.
Driver options:
- host => the MySQL server host name
- port (int) => the port number to attempt to connect to the MySQL server
- socket => the socket or named pipe
- username (or user)
- password (or pass)
- database => the database name to select
- options (array) => array of driver specific constants (MYSQLI_*) and values {\Dibi\Drivers\mysqli_options}
- flags (int) => driver specific constants (MYSQLICLIENT*) {\Dibi\Drivers\mysqli_real_connect}
- charset => character encoding to set (default is utf8)
- persistent (bool) => try to find a persistent link?
- unbuffered (bool) => sends query without fetching and buffering the result rows automatically?
- sqlmode => see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
- resource (mysqli) => existing connection resource
- lazy, profiler, result, substitutes, ... => see Dibi\Connection options
Constants
ERROR_ACCESS_DENIED |
|
ERROR_DUPLICATE_ENTRY |
|
ERROR_DATA_TRUNCATED |
|
Methods
No description
Connects to a database.
Disconnects from a database.
Executes the SQL query.
No description
Retrieves information about the most recently executed query.
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Begins a transaction (if supported).
Commits statements in a transaction.
Rollback changes in a transaction.
Returns the connection resource.
Returns the connection reflector.
Result set driver factory.
Encodes data for use in a SQL statement.
No description
No description
No description
No description
No description
Encodes string for use in a LIKE statement.
Decodes data from result set.
Injects LIMIT/OFFSET to the SQL query.
Automatically frees the resources allocated for this result set.
Returns the number of rows in a result set.
Fetches the row at current position and moves the internal cursor to the next position.
Moves cursor position without fetching row.
Frees the resources allocated for this result set.
Returns metadata for all columns in a result set.
Returns the result set resource.
Details
at line 56
__construct()
No description
at line 69
void
connect(array $config)
Connects to a database.
at line 139
void
disconnect()
Disconnects from a database.
at line 151
ResultDriver|null
query($sql)
Executes the SQL query.
at line 168
static DriverException
createException($message, $code, $sql)
No description
at line 189
array
getInfo()
Retrieves information about the most recently executed query.
at line 208
int|false
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 218
int|false
getInsertId($sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 230
void
begin($savepoint = NULL)
Begins a transaction (if supported).
at line 242
void
commit($savepoint = NULL)
Commits statements in a transaction.
at line 254
void
rollback($savepoint = NULL)
Rollback changes in a transaction.
at line 264
mixed
getResource()
Returns the connection resource.
at line 274
Reflector
getReflector()
Returns the connection reflector.
at line 284
ResultDriver
createResultDriver(mysqli_result $resource)
Result set driver factory.
at line 300
string
escapeText($value)
Encodes data for use in a SQL statement.
at line 310
string
escapeBinary($value)
No description
at line 320
string
escapeIdentifier($value)
No description
at line 330
string
escapeBool($value)
No description
at line 340
string
escapeDate($value)
No description
at line 353
string
escapeDateTime($value)
No description
at line 368
string
escapeLike($value, $pos)
Encodes string for use in a LIKE statement.
at line 380
string
unescapeBinary($value)
Decodes data from result set.
at line 387
escape($value, $type)
deprecated
deprecated
No description
at line 401
void
applyLimit($sql, $limit, $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 421
void
__destruct()
Automatically frees the resources allocated for this result set.
at line 431
int
getRowCount()
Returns the number of rows in a result set.
at line 445
array
fetch($assoc)
Fetches the row at current position and moves the internal cursor to the next position.
at line 457
bool
seek($row)
Moves cursor position without fetching row.
at line 470
void
free()
Frees the resources allocated for this result set.
at line 481
array
getResultColumns()
Returns metadata for all columns in a result set.
at line 516
mixed
getResultResource()
Returns the result set resource.
Traits
Better OOP experience.