SQL

interface SQL

Methods

createDatabase

Create a new database.

public createDatabase(string $name): bool

Returns: bool

Parameters

Parameter	Type	Description
$name	string

exec

Drop a database.

public exec(string $sql): false|int

Returns: false|int

Parameters

Parameter	Type	Description
$sql	string

query

Execute an SQL query.

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

Returns: false|Hazaar\DBI\Result

Parameters

Parameter	Type	Description
$sql	string
$parameters	array

quote

Quote a string for use in an SQL query.

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

Returns: false|string

Parameters

Parameter	Type	Description
$string	string
$type	int

setTimezone

Set the timezone for the database connection.

public setTimezone(string $tz): bool

Returns: bool

Parameters

Parameter	Type	Description
$tz	string

errorInfo

Get the last error info.

public errorInfo(): array|false

Returns: array|false

errorCode

Get the last error code.

public errorCode(): string

Returns: string

getQueryBuilder

Get a new QueryBuilder object.

public getQueryBuilder(): QueryBuilder

Returns: Hazaar\DBI\Interface\QueryBuilder

repair

Execute any database repair operations.

public repair(): bool

Returns: bool

lastQueryString

Get the last query string.

public lastQueryString(): string

Returns: string

---

Generated by Hazaar API Doc Generator on Fri, 04 Sep 2026 23:32:16 +0000