The SQLite3 classIntroductionA class that interfaces SQLite 3 databases. Class synopsis
SQLite3
/* Constants */
public
const
int
SQLite3::OK;
public
const
int
SQLite3::DENY;
public
const
int
SQLite3::IGNORE;
public
const
int
SQLite3::CREATE_INDEX;
public
const
int
SQLite3::CREATE_TABLE;
public
const
int
SQLite3::CREATE_TEMP_INDEX;
public
const
int
SQLite3::CREATE_TEMP_TABLE;
public
const
int
SQLite3::CREATE_TEMP_TRIGGER;
public
const
int
SQLite3::CREATE_TEMP_VIEW;
public
const
int
SQLite3::CREATE_TRIGGER;
public
const
int
SQLite3::CREATE_VIEW;
public
const
int
SQLite3::DELETE;
public
const
int
SQLite3::DROP_INDEX;
public
const
int
SQLite3::DROP_TABLE;
public
const
int
SQLite3::DROP_TEMP_INDEX;
public
const
int
SQLite3::DROP_TEMP_TABLE;
public
const
int
SQLite3::DROP_TEMP_TRIGGER;
public
const
int
SQLite3::DROP_TEMP_VIEW;
public
const
int
SQLite3::DROP_TRIGGER;
public
const
int
SQLite3::DROP_VIEW;
public
const
int
SQLite3::INSERT;
public
const
int
SQLite3::PRAGMA;
public
const
int
SQLite3::READ;
public
const
int
SQLite3::SELECT;
public
const
int
SQLite3::TRANSACTION;
public
const
int
SQLite3::UPDATE;
public
const
int
SQLite3::ATTACH;
public
const
int
SQLite3::DETACH;
public
const
int
SQLite3::ALTER_TABLE;
public
const
int
SQLite3::REINDEX;
public
const
int
SQLite3::ANALYZE;
public
const
int
SQLite3::CREATE_VTABLE;
public
const
int
SQLite3::DROP_VTABLE;
public
const
int
SQLite3::FUNCTION;
public
const
int
SQLite3::SAVEPOINT;
public
const
int
SQLite3::COPY;
public
const
int
SQLite3::RECURSIVE;
/* Methods */
public __construct(string
$filename , int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, string $encryptionKey = "")public bool backup(SQLite3
$destination , string $sourceDatabase = "main", string $destinationDatabase = "main")public bool busyTimeout(int
$milliseconds )public int changes()
public bool close()
public bool createAggregate(
string $name ,callable $stepCallback ,callable $finalCallback ,int $argCount = -1) public bool createCollation(string
$name , callable $callback )public bool createFunction(
string $name ,callable $callback ,int $argCount = -1,int $flags = 0) public bool enableExceptions(bool
$enable = false )public static string escapeString(string
$string )public bool exec(string
$query )public int lastErrorCode()
public string lastErrorMsg()
public int lastInsertRowID()
public bool loadExtension(string
$name )public void open(string
$filename , int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE, string $encryptionKey = "")public resourcefalse openBlob(
string $table ,string $column ,int $rowid ,string $database = "main",int $flags = SQLITE3_OPEN_READONLY ) public SQLite3Stmtfalse prepare(string
$query )public SQLite3Resultfalse query(string
$query )public mixed querySingle(string
$query , bool $entireRow = false )public bool setAuthorizer(callablenull
$callback )public static array version()
Predefined Constants
|