SQLite

• SQLiteDatabase->arrayQuery (dbhandle, query, result_type, decode_binary, query, dbhandle, result_type, decode_binary, query, result_type, decode_binary, dbhandle, query, result_type, decode_binary, query, dbhandle, result_type, decode_binary, query, result_type, decode_binary, dbhandle, query, result_type, decode_binary, query, dbhandle, result_type, decode_binary, query, result_type, decode_binary) - Execute a query against a given database and returns an array
• SQLiteDatabase->busyTimeout (dbhandle, milliseconds, milliseconds, dbhandle, milliseconds, milliseconds) - Set busy timeout duration, or disable busy handlers
• SQLiteDatabase->changes (dbhandle, milliseconds, milliseconds, dbhandle, milliseconds, milliseconds) - Returns the number of rows that were changed by the most recent SQL statement
• SQLiteDatabase->createAggregate (dbhandle, milliseconds, milliseconds, dbhandle, milliseconds, milliseconds) - Register an aggregating UDF for use in SQL statements
• SQLiteDatabase->createFunction (dbhandle, function_name, callback, num_args, function_name, callback, num_args, dbhandle, function_name, callback, num_args, function_name, callback, num_args) - Registers a "regular" User Defined Function for use in SQL statements
• SQLiteDatabase->exec (dbhandle, query, error_msg, query, dbhandle, query, error_msg, dbhandle, query, error_msg, query, dbhandle, query, error_msg, dbhandle, query, error_msg, query, dbhandle, query, error_msg) - Executes a result-less query against a given database
• SQLiteDatabase->fetchColumnTypes (table_name, dbhandle, result_type, table_name, result_type, table_name, dbhandle, result_type, table_name, result_type) - Return an array of column types from a particular table
• SQLiteDatabase->lastError (table_name, dbhandle, result_type, table_name, result_type, table_name, dbhandle, result_type, table_name, result_type) - Returns the error code of the last error for a database
• SQLiteDatabase->lastInsertRowid (table_name, dbhandle, result_type, table_name, result_type, table_name, dbhandle, result_type, table_name, result_type) - Returns the rowid of the most recently inserted row
• SQLiteDatabase->query (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Executes a query against a given database and returns a result handle
• SQLiteDatabase->singleQuery (db, query, first_row_only, decode_binary, query, first_row_only, decode_binary, db, query, first_row_only, decode_binary, query, first_row_only, decode_binary) - Executes a query and returns either an array for one single column or the value of the first row
• SQLiteDatabase->unbufferedQuery (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Execute a query that does not prefetch and buffer all data
• SQLiteResult->hasPrev (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Returns whether or not a previous row is available
• SQLiteResult->key (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Returns the current row index
• SQLiteResult->numRows (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Returns the number of rows in a buffered result set
• SQLiteResult->prev (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Seek to the previous row number of a result set
• SQLiteResult->rewind (dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg, dbhandle, query, result_type, error_msg, query, dbhandle, result_type, error_msg, query, result_type, error_msg) - Seek to the first row number
• SQLiteResult->seek (result, rownum, rownum, result, rownum, rownum) - Seek to a particular row number of a buffered result set
• SQLiteUnbuffered->column (result, index_or_name, decode_binary, index_or_name, decode_binary, index_or_name, decode_binary, result, index_or_name, decode_binary, index_or_name, decode_binary, index_or_name, decode_binary, result, index_or_name, decode_binary, index_or_name, decode_binary, index_or_name, decode_binary) - Fetches a column from the current row of a result set
• SQLiteUnbuffered->current (result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary) - Fetches the current row from a result set as an array
• SQLiteUnbuffered->fetch (result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary) - Fetches the next row from a result set as an array
• SQLiteUnbuffered->fetchAll (result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary, result, result_type, decode_binary, result_type, decode_binary, result_type, decode_binary) - Fetches all rows from a result set as an array of arrays
• SQLiteUnbuffered->fetchObject (result, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary, result, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary, result, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary, class_name, ctor_params, decode_binary) - Fetches the next row from a result set as an object
• SQLiteUnbuffered->fetchSingle (result, decode_binary, decode_binary, decode_binary, result, decode_binary, decode_binary, decode_binary, result, decode_binary, decode_binary, decode_binary) - Fetches the first column of a result set as a string
• SQLiteUnbuffered->fieldName (result, field_index, field_index, field_index, result, field_index, field_index, field_index, result, field_index, field_index, field_index) - Returns the name of a particular field
• SQLiteUnbuffered->next (result, field_index, field_index, field_index, result, field_index, field_index, field_index, result, field_index, field_index, field_index) - Seek to the next row number
• SQLiteUnbuffered->numFields (result, field_index, field_index, field_index, result, field_index, field_index, field_index, result, field_index, field_index, field_index) - Returns the number of fields in a result set
• SQLiteUnbuffered->valid (result, field_index, field_index, field_index, result, field_index, field_index, field_index, result, field_index, field_index, field_index) - Returns whether more rows are available
• sqlite_close (dbhandle) - Closes an open SQLite database
• sqlite_error_string (error_code) - Returns the textual description of an error code
• sqlite_escape_string (item) - Escapes a string for use as a query parameter
• sqlite_factory (filename, mode, error_message) - Opens a SQLite database and returns a SQLiteDatabase object
• sqlite_fetch_string (filename, mode, error_message) - Alias of sqlite_fetch_single()
• sqlite_has_more (result) - Finds whether or not more rows are available
• sqlite_libencoding (result) - Returns the encoding of the linked SQLite library
• sqlite_libversion (result) - Returns the version of the linked SQLite library
• sqlite_open (filename, mode, error_message, filename, mode, error_message) - Opens a SQLite database and create the database if it does not exist
• sqlite_popen (filename, mode, error_message) - Opens a persistent handle to an SQLite database and create the database if it does not exist
• sqlite_udf_decode_binary (data) - Decode binary data passed as parameters to an UDF
• sqlite_udf_encode_binary (data) - Encode binary data before returning it from an UDF