Class DibiPdoDriver
The dibi driver for PDO.
Driver options:
- dsn ⇒ driver specific DSN
- username (or user)
- password (or pass)
- options (array) ⇒ driver specific options {@see PDO::__construct}
- resource (PDO) ⇒ existing connection
- lazy, profiler, result, substitutes, … ⇒ see DibiConnection options
- DibiObject
-
DibiPdoDriver 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
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
PDO
|
#
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
Implementation 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. ThrowsImplementation of |
public
PDOStatement
|
#
getResultResource(
)
Returns the result set resource. |