Trait PDODriverTrait
PDO driver trait
Property Summary
-
$_connection protected
PDO|nullInstance of PDO.
Method Summary
-
_connect() protected
Establishes a connection to the database server
-
beginTransaction() public
Starts a transaction
-
commitTransaction() public
Commits a transaction
-
connection() public
Returns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed
-
disconnect() public
Disconnects from database server
-
isConnected() public
Checks whether or not the driver is connected.
-
lastInsertId() public
Returns last id generated for a table or sequence in database
-
prepare() public
Prepares a sql statement to be executed
-
quote() public
Returns a value in a safe representation to be used in a query string
-
rollbackTransaction() public
Rollback a transaction
-
supportsQuoting() public
Checks if the driver supports quoting, as PDO_ODBC does not support it.
Method Detail
_connect() ¶ protected
_connect(string $dsn, array $config): boolEstablishes a connection to the database server
Parameters
-
string$dsn A Driver-specific PDO-DSN
-
array$config configuration to be used for creating connection
Returns
boolconnection() ¶ public
connection(nullPDO $connection = null): PDOReturns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed
Parameters
-
nullPDO$connection optional The PDO connection instance.
Returns
PDOisConnected() ¶ public
isConnected(): boolChecks whether or not the driver is connected.
Returns
boollastInsertId() ¶ public
lastInsertId(string|null $table = null, string|null $column = null): string|intReturns last id generated for a table or sequence in database
Parameters
-
string|null$table optional table name or sequence to get last insert value from
-
string|null$column optional the name of the column representing the primary key
Returns
string|intprepare() ¶ public
prepare(stringCake\Database\Query $query): Cake\Database\StatementInterfacePrepares a sql statement to be executed
Parameters
-
stringCake\Database\Query$query The query to turn into a prepared statement.
Returns
Cake\Database\StatementInterfacequote() ¶ public
quote(mixed $value, string $type): stringReturns a value in a safe representation to be used in a query string
Parameters
-
mixed$value The value to quote.
-
string$type Type to be used for determining kind of quoting to perform
Returns
stringsupportsQuoting() ¶ public
supportsQuoting(): boolChecks if the driver supports quoting, as PDO_ODBC does not support it.
Returns
bool