(PHP 5 >= 5.3.0, PHP 7) Registers a PHP function for use as an SQL scalar function public bool SQLite3::createFunction ( string $name, mixed $callback [, int $argument_count = -1 ] ) Registers a PHP function or user-defined function for use as an SQL scalar function for use within SQL statements. Parameters: name Name of the SQL function to be created or redefined.

(PHP 5 >= 5.3.11, PHP 7) Registers a PHP function for use as an SQL collating function public bool SQLite3::createCollation ( string $name, callable $callback ) Registers a PHP function or user-defined function for use as a collating function within SQL statements. Parameters: name Name of the SQL collating function to be created or redefined cal

(PHP 5 >= 5.3.0, PHP 7) Registers a PHP function for use as an SQL aggregate function public bool SQLite3::createAggregate ( string $name, mixed $step_callback, mixed $final_callback [, int $argument_count = -1 ] ) Registers a PHP function or user-defined function for use as an SQL aggregate function for use within SQL statements. Parameters: name Name of the SQL aggr

(PHP 5 >= 5.3.0, PHP 7) Instantiates an SQLite3 object and opens an SQLite 3 database public SQLite3::__construct ( string $filename [, int $flags [, string $encryption_key ]] ) Instantiates an SQLite3 object and opens a connection to an SQLite 3 database. If the build includes encryption, then it will attempt to use the key. Parameters: filename Path to the SQLite d

(PHP 5 >= 5.3.0, PHP 7) Closes the database connection public bool SQLite3::close ( void ) Closes the database connection. Returns: Returns TRUE on success, FALSE on failure. Examples: SQLite3::close() example <?php $db = new SQLite3('mysqlitedb.db'); $db->close(); ?>

(PHP 5 >= 5.3.0, PHP 7) Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement public int SQLite3::changes ( void ) Returns the number of database rows that were changed (or inserted or deleted) by the most recent SQL statement. Returns: Returns an integer value corresponding to the number of database rows changed (or inserted or delete

(PHP 5 >= 5.3.3, PHP 7) Sets the busy connection handler public bool SQLite3::busyTimeout ( int $msecs ) Sets a busy handler that will sleep until the database is not locked or the timeout is reached. Parameters: msecs The milliseconds to sleep. Setting this value to a value less than or equal to zero, will turn off an already set timeout handler. R

(PHP 5 < 5.4.0) Returns whether more rows are available bool sqlite_valid ( resource $result ) Object oriented style (method): bool SQLiteResult::valid ( void ) bool SQLiteUnbuffered::valid ( void ) Finds whether more rows are available from the given result handle. Parameters: result The SQLite result resource. This parameter is not required when using the object-or

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Execute a query that does not prefetch and buffer all data resource sqlite_unbuffered_query ( resource $dbhandle, string $query [, int $result_type = SQLITE_BOTH [, string &$error_msg ]] ) resource sqlite_unbuffered_query ( string $query , resource $dbhandle [, int $result_type = SQLITE_BOTH [, string &$error_msg ]] ) Object oriented style (method): public SQLiteUnbuffere

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Encode binary data before returning it from an UDF string sqlite_udf_encode_binary ( string $data ) sqlite_udf_encode_binary() applies a binary encoding to the data so that it can be safely returned from queries (since the underlying libsqlite API is not binary safe). If there is a chance that your data might be binary unsafe (e.g.: it contains a NUL byte in the middle rather tha