SQL

Less than 1 minute

Methods

Create a new database.

public createDatabase(string $name): bool

Parameter	Type	Description
`$name`	`string`

Drop a database.

public exec(string $sql): int

Parameter	Type	Description
`$sql`	`string`

Execute an SQL query.

public query(string $sql): Result

Parameter	Type	Description
`$sql`	`string`

Quote a string for use in an SQL query.

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

Parameter	Type	Description
`$string`	`mixed`
`$type`	`int`

Set the timezone for the database connection.

public setTimezone(string $tz): bool

Parameter	Type	Description
`$tz`	`string`

Get the last error info.

public errorInfo(false $): void

Parameter	Type	Description
`$`	`false`

Get the last error code.

public errorCode(): string

Get a new QueryBuilder object.

public getQueryBuilder(): QueryBuilder

Execute any database repair operations.

public repair(): bool

Get the last query string.

public lastQueryString(): string