Class DibiMySqliDriver
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
{@see mysqli_options}
- flags (int) ⇒ driver specific constants (MYSQLI_CLIENT_*) {@see
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/…ql-mode.html
- resource (mysqli) ⇒ existing connection resource
- lazy, profiler, result, substitutes, … ⇒ see DibiConnection options
- DibiObject
-
DibiMySqliDriver implements IDibiDriver, IDibiResultDriver
public
|
#
__construct(
)
Throws |
public
void
|
#
connect(
array
& $config
)
Connects to a database. |
public
void
|
#
disconnect(
)
Disconnects from a database. |
public
IDibiResultDriver|NULL
|
#
query(
string
$sql
)
Executes the SQL query. Executes the SQL query. Parameters$sql string SQL statement.ThrowsImplementation of |
public
array
|
#
getInfo(
)
Retrieves information about the most recently executed query. Retrieves information about the most recently executed query. |
public
int|FALSE
|
#
getAffectedRows(
)
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Returnsint|FALSE number of rows or FALSE on error
Implementation of |
public
int|FALSE
|
#
getInsertId(
$sequence
)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Returnsint|FALSE int on success or FALSE on failure
Implementation of |
public
void
|
#
begin(
string
$savepoint = NULL
)
Begins a transaction (if supported). Begins a transaction (if supported). Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
void
|
#
commit(
string
$savepoint = NULL
)
Commits statements in a transaction. Commits statements in a transaction. Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
void
|
#
rollback(
string
$savepoint = NULL
)
Rollback changes in a transaction. Rollback changes in a transaction. Parameters$savepoint string optional savepoint nameThrowsImplementation of |
public
mysqli
|
#
getResource(
)
Returns the connection resource. |
public
IDibiReflector
|
#
getReflector(
)
Returns the connection reflector. |
public
string
|
#
escape(
mixed
$value,
string
$type
)
Encodes data for use in a SQL statement. Encodes data for use in a SQL statement. Parameters$value mixed value$type string type (dibi::TEXT, dibi::BOOL, ...)Returnsstring encoded value
Throws
InvalidArgumentException
Implementation of |
public
string
|
#
escapeLike(
string
$value,
int
$pos
)
Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters$value string$pos intImplementation of |
public
string
|
#
unescape(
string
$value,
string
$type
)
Decodes data from result set. Decodes data from result set. Parameters$value string value$type string type (dibi::BINARY)Returnsstring decoded value
Throws
InvalidArgumentException
Implementation of |
public
void
|
#
applyLimit(
string
& $sql,
int
$limit,
int
$offset
)
Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters$sql string &$sql The SQL query that will be modified.$limit int $limit$offset int $offsetImplementation of |
public
int
|
#
getRowCount(
)
Returns the number of rows in a result set. |
public
array
|
#
fetch(
bool
$assoc
)
Fetches the row at current position and moves the internal cursor to the next position. Fetches the row at current position and moves the internal cursor to the next position. Parameters$assoc bool TRUE for associative array, FALSE for numericReturnsarray array on success, nonarray if no next record
Implementation of |
public
boolean
|
#
seek(
int
$row
)
Moves cursor position without fetching row. Moves cursor position without fetching row. Parameters$row int the 0-based cursor pos to seek toReturnsboolean TRUE on success, FALSE if unable to seek to specified record
ThrowsImplementation of |
public
void
|
#
free(
)
Frees the resources allocated for this result set. |
public
array
|
#
getResultColumns(
)
Returns metadata for all columns in a result set. Returns metadata for all columns in a result set. Implementation of |
public
mysqli_result
|
#
getResultResource(
)
Returns the result set resource. |