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 mysqli_options - flags (int) => driver
specific constants (MYSQLI_CLIENT_*) 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 DibiConnection options
Methods summary
public
|
|
public
|
#
connect( array & $config )
Connects to a database.
Parameters
Throws
Implementation of
|
public
|
#
disconnect( )
Disconnects from a database.
Disconnects from a database.
Throws
Implementation of
|
public
IDibiResultDriver|null
|
#
query( string $sql )
Executes the SQL query.
Parameters
- $sql
string
SQL statement. Returns
Throws
Implementation of
|
public
array
|
#
getInfo( )
Retrieves information about the most recently executed query.
Retrieves information about the most recently executed query.
Returns
array
|
public
integer|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.
Returns
integer|false
number of rows or FALSE on error
Implementation of
|
public
integer|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.
Returns
integer|false
int on success or FALSE on failure
Implementation of
|
public
|
#
begin( string $savepoint = NULL )
Begins a transaction (if supported).
Begins a transaction (if supported).
Parameters
- $savepoint
string
optional savepoint name Throws
Implementation of
|
public
|
#
commit( string $savepoint = NULL )
Commits statements in a transaction.
Commits statements in a transaction.
Parameters
- $savepoint
string
optional savepoint name Throws
Implementation of
|
public
|
#
rollback( string $savepoint = NULL )
Rollback changes in a transaction.
Rollback changes in a transaction.
Parameters
- $savepoint
string
optional savepoint name Throws
Implementation of
|
public
mysqli
|
#
getResource( )
Returns the connection resource.
Returns the connection resource.
Returns
mysqli
Implementation of
|
public
IDibiReflector
|
#
getReflector( )
Returns the connection reflector.
Returns the connection reflector.
Returns
Implementation of
|
public
IDibiResultDriver
|
#
createResultDriver( mysqli_result $resource )
Result set driver factory.
Result set driver factory.
Parameters
Returns
|
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, ...) Returns
string
encoded value
Throws
Implementation of
|
public
string
|
#
escapeLike( string $value, integer $pos )
Encodes string for use in a LIKE statement.
Encodes string for use in a LIKE statement.
Parameters
- $value
string- $pos
integer Returns
string
Implementation 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) Returns
string
decoded value
Throws
Implementation of
|
public
|
#
applyLimit( string & $sql, integer $limit, integer $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
integer- $offset
integer Implementation of
|
public
|
#
__destruct( )
Automatically frees the resources allocated for this result set.
Automatically frees the resources allocated for this result set.
|
public
integer
|
#
getRowCount( )
Returns the number of rows in a result set.
Returns the number of rows in a result set.
Returns
integer
Implementation of
|
public
array
|
#
fetch( boolean $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
boolean
TRUE for associative array, FALSE for numeric Returns
array
array on success, nonarray if no next record
|
public
boolean
|
#
seek( integer $row )
Moves cursor position without fetching row.
Moves cursor position without fetching row.
Parameters
- $row
integer
the 0-based cursor pos to seek to Returns
boolean
TRUE on success, FALSE if unable to seek to specified record
Throws
Implementation of
|
public
|
#
free( )
Frees the resources allocated for this result set.
Frees the resources allocated for this result set.
Implementation of
|
public
array
|
#
getResultColumns( )
Returns metadata for all columns in a result set.
Returns metadata for all columns in a result set.
Returns
array
Implementation of
|
public
mysqli_result
|
#
getResultResource( )
Returns the result set resource.
Returns the result set resource.
Returns
mysqli_result
Implementation of
|
DibiMySqliDriver
implements
IDibiDriver,
IDibiResultDriver