PHP SQLite Functions

EditRocket provides the following information on SQLite functions in the PHP source code builder.

array sqlite_array_query ( resource $dbhandle , string $query [, int $result_type [, bool $decode_binary ]] ) -

void sqlite_busy_timeout ( resource $dbhandle , int $milliseconds ) - Object oriented style (method): SQLiteDatabase

int sqlite_changes ( resource $dbhandle ) - Object oriented style (method): SQLiteDatabase

void sqlite_close ( resource $dbhandle ) - Closes the given database handle. If the database was persistent, it will be closed and removed from the persistent list.

mixed sqlite_column ( resource $result , mixed $index_or_name [, bool $decode_binary ] ) -

void sqlite_create_aggregate ( resource $dbhandle , string $function_name , callback $step_func , callback $finalize_func [, int $num_args ] ) - Object oriented style (method): SQLiteDatabase

void sqlite_create_function ( resource $dbhandle , string $function_name , callback $callback [, int $num_args ] ) - Object oriented style (method): SQLiteDatabase

array sqlite_current ( resource $result [, int $result_type [, bool $decode_binary ]] ) - Object oriented style (method): SQLiteResult

string sqlite_error_string ( int $error_code ) -

string sqlite_escape_string ( string $item ) - sqlite_escape_string() will correctly quote the string specified by item for use in an SQLite SQL statement. This includes doubling up single-quote characters (') and checking for binary-unsafe characters in the query string.

bool sqlite_exec ( resource $dbhandle , string $query [, string &$error_msg ] ) -

SQLiteDatabase sqlite_factory ( string $filename [, int $mode [, string &$error_message ]] ) -

array sqlite_fetch_all ( resource $result [, int $result_type [, bool $decode_binary ]] ) - Object oriented style (method): SQLiteResult

array sqlite_fetch_array ( resource $result [, int $result_type [, bool $decode_binary ]] ) - Object oriented style (method): SQLiteResult

array sqlite_fetch_column_types ( string $table_name , resource $dbhandle [, int $result_type ] ) - Object oriented style (method): SQLiteDatabase

object sqlite_fetch_object ( resource $result [, string $class_name [, array $ctor_params [, bool $decode_binary ]]] ) - Object oriented style (method): SQLiteResult

string sqlite_fetch_single ( resource $result [, bool $decode_binary ] ) - Object oriented style (method): SQLiteResult

-

string sqlite_field_name ( resource $result , int $field_index ) - Object oriented style (method): SQLiteResult

bool sqlite_has_more ( resource $result ) - Finds whether more rows are available from the given result set.

bool sqlite_has_prev ( resource $result ) - Object oriented style (method): SQLiteResult

int sqlite_key ( resource $result ) - Object oriented style (method): SQLiteResult

int sqlite_last_error ( resource $dbhandle ) - Object oriented style (method): SQLiteDatabase

int sqlite_last_insert_rowid ( resource $dbhandle ) - Object oriented style (method): SQLiteDatabase

string sqlite_libencoding ( void ) - The SQLite library may be compiled in either ISO-8859-1 or UTF-8 compatible modes. This function allows you to determine which encoding scheme is used by your version of the library.

string sqlite_libversion ( void ) - Returns the version of the linked SQLite library.

bool sqlite_next ( resource $result ) - Object oriented style (method): SQLiteResult

int sqlite_num_fields ( resource $result ) - Object oriented style (method): SQLiteResult

int sqlite_num_rows ( resource $result ) - Object oriented style (method): SQLiteResult

resource sqlite_open ( string $filename [, int $mode [, string &$error_message ]] ) - Object oriented style (constructor): SQLiteDatabase

resource sqlite_popen ( string $filename [, int $mode [, string &$error_message ]] ) - sqlite_popen() will first check to see if a persistent handle has already been opened for the given filename. If it finds one, it returns that handle to your script, otherwise it opens a fresh handle to the database.

bool sqlite_prev ( resource $result ) - Object oriented style (method): SQLiteResult

resource sqlite_query ( resource $dbhandle , string $query [, int $result_type [, string &$error_msg ]] ) -

bool sqlite_rewind ( resource $result ) - Object oriented style (method): SQLiteResult

bool sqlite_seek ( resource $result , int $rownum ) - Object oriented style (method): SQLiteResult

array sqlite_single_query ( resource $db , string $query [, bool $first_row_only [, bool $decode_binary ]] ) - Object oriented style (method): SQLiteDatabase

string sqlite_udf_decode_binary ( string $data ) -

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).

resource sqlite_unbuffered_query ( resource $dbhandle , string $query [, int $result_type [, string &$error_msg ]] ) -

bool sqlite_valid ( resource $result ) - Object oriented style (method): SQLiteResult