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 51
__construct(array $config)
No description
at line 128
void
disconnect()
Disconnects from a database.
at line 137
bool
ping()
Pings a server connection, or tries to reconnect if the connection has gone down.
at line 147
ResultDriver|null
query(string $sql)
Executes the SQL query.
at line 165
static DriverException
createException(string $message, int|string $code, string $sql)
No description
at line 185
array
getInfo()
Retrieves information about the most recently executed query.
at line 204
int|null
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 215
int|null
getInsertId(string|null $sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 225
void
begin(string|null $savepoint = null)
Begins a transaction (if supported).
at line 235
void
commit(string|null $savepoint = null)
Commits statements in a transaction.
at line 245
void
rollback(string|null $savepoint = null)
Rollback changes in a transaction.
at line 254
mixed
getResource()
Returns the connection resource.
at line 267
Reflector
getReflector()
Returns the connection reflector.
at line 276
MySqliResult
createResultDriver(mysqli_result $result)
Result set driver factory.
at line 288
string
escapeText(string $value)
Encodes data for use in a SQL statement.
at line 294
string
escapeBinary(string $value)
No description
at line 300
string
escapeIdentifier(string $value)
No description
at line 306
string
escapeBool(bool $value)
No description
at line 312
string
escapeDate(DateTimeInterface $value)
No description
at line 318
string
escapeDateTime(DateTimeInterface $value)
No description
at line 324
string
escapeDateInterval(DateInterval $value)
No description
at line 337
string
escapeLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 347
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
Traits
Better OOP experience.