(PHP 5 >= 5.3.0, PHP 7) Executes a query and returns a single result public mixed SQLite3::querySingle ( string $query [, bool $entire_row = false ] ) Executes a query and returns a single result. Parameters: query The SQL query to execute. entire_row By default, querySingle() returns the value of the first column returned by the qu

(PHP 5 >= 5.3.0, PHP 7) Executes an SQL query public SQLite3Result SQLite3::query ( string $query ) Executes an SQL query, returning an SQLite3Result object if the query returns results. Parameters: query The SQL query to execute. Returns: Returns an SQLite3Result object if the query returns results. Otherwise, returns TRUE if the query succee

(PHP 5 >= 5.3.0, PHP 7) Prepares an SQL statement for execution public SQLite3Stmt SQLite3::prepare ( string $query ) Prepares an SQL statement for execution and returns an SQLite3Stmt object. Parameters: query The SQL query to prepare. Returns: Returns an SQLite3Stmt object on success or FALSE on failure.

(PHP 5 >= 5.3.0, PHP 7) Opens an SQLite database public void SQLite3::open ( string $filename [, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE [, string $encryption_key ]] ) Opens an SQLite 3 Database. If the build includes encryption, then it will attempt to use the key. Parameters: filename Path to the SQLite database, or :memory: to use in-memory datab

(PHP 5 >= 5.3.0, PHP 7) Attempts to load an SQLite extension library public bool SQLite3::loadExtension ( string $shared_library ) Attempts to load an SQLite extension library. Parameters: shared_library The name of the library to load. The library must be located in the directory specified in the configure option sqlite3.extension_dir. Returns:

(PHP 5 >= 5.3.0, PHP 7) Returns the row ID of the most recent INSERT into the database public int SQLite3::lastInsertRowID ( void ) Returns the row ID of the most recent INSERT into the database. Returns: Returns the row ID of the most recent INSERT into the database

(PHP 5 >= 5.3.0, PHP 7) Returns English text describing the most recent failed SQLite request public string SQLite3::lastErrorMsg ( void ) Returns English text describing the most recent failed SQLite request. Returns: Returns an English string describing the most recent failed SQLite request.

(PHP 5 >= 5.3.0, PHP 7) Returns the numeric result code of the most recent failed SQLite request public int SQLite3::lastErrorCode ( void ) Returns the numeric result code of the most recent failed SQLite request. Returns: Returns an integer value representing the numeric result code of the most recent failed SQLite request.

(PHP 5 >= 5.3.0, PHP 7) Executes a result-less query against a given database public bool SQLite3::exec ( string $query ) Executes a result-less query against a given database. Parameters: query The SQL query to execute (typically an INSERT, UPDATE, or DELETE query). Returns: Returns TRUE if the query succeeded, FALSE on failure.

(PHP 5 >= 5.3.0, PHP 7) Returns a string that has been properly escaped public static string SQLite3::escapeString ( string $value ) Returns a string that has been properly escaped for safe inclusion in an SQL statement. Parameters: value The string to be escaped. Returns: Returns a properly escaped string that may be used safely in an SQL sta