| Methods |
public
|
prepare(string $sql): Statement
Prepares a statement for execution and returns a Statement object.
Prepares a statement for execution and returns a Statement object.
Implements
|
#
|
public
|
query(string $sql): Result
Executes an SQL statement, returning a result set as a Statement object.
Executes an SQL statement, returning a result set as a Statement object.
Implements
|
#
|
public
|
quote($value, $type = ParameterType::STRING): string
Quotes a string for use in a query.
Quotes a string for use in a query.
The usage of this method is discouraged. Use prepared statements
or {@see AbstractPlatform::quoteStringLiteral()} instead.
Implements
|
#
|
public
|
exec(string $sql): int
Executes an SQL statement and return the number of affected rows.
Executes an SQL statement and return the number of affected rows.
Implements
|
#
|
public
|
lastInsertId($name = null): int
Returns the ID of the last inserted row or sequence value.
Returns the ID of the last inserted row or sequence value.
Implements
|
#
|
public
|
beginTransaction(): bool
Initiates a transaction.
Returns
TRUE on success or FALSE on failure.
Implements
|
#
|
public
|
commit(): bool
Commits a transaction.
Returns
TRUE on success or FALSE on failure.
Implements
|
#
|
public
|
rollBack(): bool
Rolls back the current transaction, as initiated by beginTransaction().
Rolls back the current transaction, as initiated by beginTransaction().
Returns
TRUE on success or FALSE on failure.
Implements
|
#
|
public
|
getNativeConnection(): SQLite3
|
#
|
public
|
getServerVersion(): string
Returns information about the version of the database server connected to.
Returns information about the version of the database server connected to.
Implements
|
#
|