MySqliDriver
class MySqliDriver implements Driver
The driver for MySQL database.
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
Constants
| ERROR_ACCESS_DENIED |
|
| ERROR_DUPLICATE_ENTRY |
|
| ERROR_DATA_TRUNCATED |
|
Methods
No description
Disconnects from a database.
Pings a server connection, or tries to reconnect if the connection has gone down.
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
Encodes string for use in a LIKE statement.
Injects LIMIT/OFFSET to the SQL query.
Details
at line 44
__construct(array $config)
No description
at line 121
void
disconnect()
Disconnects from a database.
at line 130
bool
ping()
Pings a server connection, or tries to reconnect if the connection has gone down.
at line 140
ResultDriver|null
query(string $sql)
Executes the SQL query.
at line 155
static DriverException
createException(string $message, int|string $code, string $sql)
No description
at line 175
array
getInfo()
Retrieves information about the most recently executed query.
at line 194
int|null
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 205
int|null
getInsertId(string|null $sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 215
void
begin(string|null $savepoint = null)
Begins a transaction (if supported).
at line 225
void
commit(string|null $savepoint = null)
Commits statements in a transaction.
at line 235
void
rollback(string|null $savepoint = null)
Rollback changes in a transaction.
at line 244
mixed
getResource()
Returns the connection resource.
at line 257
Reflector
getReflector()
Returns the connection reflector.
at line 266
MySqliResult
createResultDriver(mysqli_result $result)
Result set driver factory.
at line 278
string
escapeText(string $value)
Encodes data for use in a SQL statement.
at line 284
string
escapeBinary(string $value)
No description
at line 290
string
escapeIdentifier(string $value)
No description
at line 296
string
escapeBool(bool $value)
No description
at line 302
string
escapeDate(DateTimeInterface $value)
No description
at line 308
string
escapeDateTime(DateTimeInterface $value)
No description
at line 314
string
escapeDateInterval(DateInterval $value)
No description
at line 327
string
escapeLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 337
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.