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 127
void
disconnect()
Disconnects from a database.
at line 136
bool
ping()
Pings a server connection, or tries to reconnect if the connection has gone down.
at line 146
ResultDriver|null
query(string $sql)
Executes the SQL query.
at line 163
static DriverException
createException(string $message, int|string $code, string $sql)
No description
at line 183
array
getInfo()
Retrieves information about the most recently executed query.
at line 201
int|null
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 212
int|null
getInsertId(string|null $sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 222
void
begin(string $savepoint = null)
Begins a transaction (if supported).
at line 232
void
commit(string $savepoint = null)
Commits statements in a transaction.
at line 242
void
rollback(string $savepoint = null)
Rollback changes in a transaction.
at line 251
mixed
getResource()
Returns the connection resource.
at line 260
Reflector
getReflector()
Returns the connection reflector.
at line 269
MySqliResult
createResultDriver(mysqli_result $result)
Result set driver factory.
at line 281
string
escapeText(string $value)
Encodes data for use in a SQL statement.
at line 287
string
escapeBinary(string $value)
No description
at line 293
string
escapeIdentifier(string $value)
No description
at line 299
string
escapeBool(bool $value)
No description
at line 305
string
escapeDate(DateTimeInterface $value)
No description
at line 311
string
escapeDateTime(DateTimeInterface $value)
No description
at line 317
string
escapeDateInterval(DateInterval $value)
No description
at line 329
string
escapeLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 339
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
Traits
Better OOP experience.