PDO

Trait providing base PDO operations for relational database drivers.

trait PDO

Includes methods for executing queries, preparing statements, quoting values, managing attributes, and handling connection state.

Properties

public  $

lastQueryString

Stores the last SQL query string executed or prepared.

private string $lastQueryString

Methods

exec

Executes an SQL statement and returns the number of affected rows or false on failure.

public exec(string $sql): int

Parameters

Parameter	Type	Description
$sql	string	the SQL statement to execute

prepare

Prepares an SQL statement for execution.

public prepare(string $sql): Statement

Parameters

Parameter	Type	Description
$sql	string	the SQL statement to prepare

prepareQuery

Prepares a query using a QueryBuilder instance and sets the last query string.

public prepareQuery(QueryBuilder $queryBuilder): Statement

Parameters

Parameter	Type	Description
$queryBuilder	QueryBuilder	the query builder instance

lastQueryString

Returns the last SQL query string executed or prepared.

public lastQueryString(): string

query

public query(string $sql, array $parameters): Result

Parameters

Parameter	Type	Description
$sql	string
$parameters	array

quote

Quotes a string for use in an SQL statement, using the current PDO connection.

public quote(mixed $string, int $type = '\PDO::PARAM_STR'): string

Parameters

Parameter	Type	Description
$string	mixed	the string to quote
$type	int	the data type for parameter binding (default: \PDO::PARAM_STR)

setTimezone

Sets the timezone for the database connection. (Not implemented for PDO.).

public setTimezone(string $tz): bool

Parameters

Parameter	Type	Description
$tz	string	the timezone identifier

lastInsertId

Returns the ID of the last inserted row.

public lastInsertId(): string

getAttribute

Retrieves the value of a PDO attribute.

public getAttribute(int $attribute): mixed

Parameters

Parameter	Type	Description
$attribute	int	the attribute identifier

setAttribute

Sets the value of a PDO attribute.

public setAttribute(int $attribute, mixed $value): bool

Parameters

Parameter	Type	Description
$attribute	int	the attribute identifier
$value	mixed	the value to set for the attribute

errorInfo

public errorInfo(): void

errorCode

Returns the error code for the last PDO operation.

public errorCode(): string

connect

protected connect(string $dsn, ?string $username, ?string $password, ?array $driverOptions): bool

Parameters

Parameter	Type	Description
$dsn	string
$username	string
$password	string
$driverOptions	array

mkdsn

protected mkdsn(array $config): string

Parameters

Parameter	Type	Description
$config	array

---

Generated by Hazaar API Doc Generator on Tue, 21 Apr 2026 04:00:24 +0000