Trait PDODriverTrait
PDO driver trait
Property Summary
-
$_connection protected
PDO|null
Instance 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): bool
Establishes a connection to the database server
Parameters
-
string
$dsn A Driver-specific PDO-DSN
-
array
$config configuration to be used for creating connection
Returns
bool
connection() ¶ public
connection(null|PDO $connection = null): PDO
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
Parameters
-
null|PDO
$connection optional The PDO connection instance.
Returns
PDO
isConnected() ¶ public
isConnected(): bool
Checks whether or not the driver is connected.
Returns
bool
lastInsertId() ¶ public
lastInsertId(string|null $table = null, string|null $column = null): string|int
Returns 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|int
prepare() ¶ public
prepare(string|Cake\Database\Query $query): Cake\Database\StatementInterface
Prepares a sql statement to be executed
Parameters
-
string|Cake\Database\Query
$query The query to turn into a prepared statement.
Returns
Cake\Database\StatementInterface
quote() ¶ public
quote(mixed $value, string $type): string
Returns 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
string
supportsQuoting() ¶ public
supportsQuoting(): bool
Checks if the driver supports quoting, as PDO_ODBC does not support it.
Returns
bool