Methods | ||
---|---|---|
public
|
__construct(string $filename, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, string $encryptionKey = "")
|
# |
public
|
open(string $filename, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, string $encryptionKey = ""): void
|
# |
public
|
close(): bool
|
# |
public
static
|
version(): array
|
# |
public
|
lastInsertRowID(): int
|
# |
public
|
lastErrorCode(): int
|
# |
public
|
lastExtendedErrorCode(): int
|
# |
public
|
lastErrorMsg(): string
|
# |
public
|
changes(): int
|
# |
public
|
busyTimeout(int $milliseconds): bool
|
# |
public
|
loadExtension(string $name): bool
|
# |
public
|
backup(SQLite3 $destination, string $sourceDatabase = "main", string $destinationDatabase = "main"): bool
|
# |
public
static
|
escapeString(string $string): string
|
# |
public
|
prepare(string $query): SQLite3Stmt|false
|
# |
public
|
exec(string $query): bool
|
# |
public
|
query(string $query): SQLite3Result|false
|
# |
public
|
querySingle(string $query, bool $entireRow = false): mixed
|
# |
public
|
createFunction(string $name, callable $callback, int $argCount = -1, int $flags = 0): bool
|
# |
public
|
createAggregate(string $name, callable $stepCallback, callable $finalCallback, int $argCount = -1): bool
|
# |
public
|
createCollation(string $name, callable $callback): bool
|
# |
public
|
openBlob(
string $table,
string $column,
int $rowid,
string $database = "main",
int $flags = SQLITE3_OPEN_READONLY,
): resource|false
|
# |
public
|
enableExceptions(bool $enable = false): bool
|
# |
public
|
enableExtendedResultCodes(bool $enable = true): bool
|
# |
public
|
setAuthorizer(?callable $callback): bool
|
# |
Constants | ||
---|---|---|
public
|
OK = UNKNOWN
|
# |
public
|
DENY = UNKNOWN
|
# |
public
|
IGNORE = UNKNOWN
|
# |
public
|
CREATE_INDEX = UNKNOWN
|
# |
public
|
CREATE_TABLE = UNKNOWN
|
# |
public
|
CREATE_TEMP_INDEX = UNKNOWN
|
# |
public
|
CREATE_TEMP_TABLE = UNKNOWN
|
# |
public
|
CREATE_TEMP_TRIGGER = UNKNOWN
|
# |
public
|
CREATE_TEMP_VIEW = UNKNOWN
|
# |
public
|
CREATE_TRIGGER = UNKNOWN
|
# |
public
|
CREATE_VIEW = UNKNOWN
|
# |
public
|
DELETE = UNKNOWN
|
# |
public
|
DROP_INDEX = UNKNOWN
|
# |
public
|
DROP_TABLE = UNKNOWN
|
# |
public
|
DROP_TEMP_INDEX = UNKNOWN
|
# |
public
|
DROP_TEMP_TABLE = UNKNOWN
|
# |
public
|
DROP_TEMP_TRIGGER = UNKNOWN
|
# |
public
|
DROP_TEMP_VIEW = UNKNOWN
|
# |
public
|
DROP_TRIGGER = UNKNOWN
|
# |
public
|
DROP_VIEW = UNKNOWN
|
# |
public
|
INSERT = UNKNOWN
|
# |
public
|
PRAGMA = UNKNOWN
|
# |
public
|
READ = UNKNOWN
|
# |
public
|
SELECT = UNKNOWN
|
# |
public
|
TRANSACTION = UNKNOWN
|
# |
public
|
UPDATE = UNKNOWN
|
# |
public
|
ATTACH = UNKNOWN
|
# |
public
|
DETACH = UNKNOWN
|
# |
public
|
ALTER_TABLE = UNKNOWN
|
# |
public
|
REINDEX = UNKNOWN
|
# |
public
|
ANALYZE = UNKNOWN
|
# |
public
|
CREATE_VTABLE = UNKNOWN
|
# |
public
|
DROP_VTABLE = UNKNOWN
|
# |
public
|
FUNCTION = UNKNOWN
|
# |
public
|
SAVEPOINT = UNKNOWN
|
# |
public
|
COPY = UNKNOWN
|
# |
public
|
RECURSIVE = UNKNOWN
|
# |