(PHP 5 < 5.4.0) Return an array of column types from a particular table array sqlite_fetch_column_types ( string $table_name, resource $dbhandle [, int $result_type = SQLITE_ASSOC ] ) Object oriented style (method): public array SQLiteDatabase::fetchColumnTypes ( string $table_name [, int $result_type = SQLITE_ASSOC ] ) sqlite_fetch_column_types() returns an array of column data types from the specified table_name tab

(PHP 5 < 5.4.0) Fetches the next row from a result set as an object object sqlite_fetch_object ( resource $result [, string $class_name [, array $ctor_params [, bool $decode_binary = true ]]] ) Object oriented style (method): object SQLiteResult::fetchObject ([ string $class_name [, array $ctor_params [, bool $decode_binary = true ]]] ) object SQLiteUnbuffered::fetchObject ([ string $class_name [, array $ctor_params [,

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.1) Fetches the first column of a result set as a string string sqlite_fetch_single ( resource $result [, bool $decode_binary = true ] ) Object oriented style (method): string SQLiteResult::fetchSingle ([ bool $decode_binary = true ] ) string SQLiteUnbuffered::fetchSingle ([ bool $decode_binary = true ] ) sqlite_fetch_single() is identical to sqlite_fetch_array() except that it retu

(PHP 5 < 5.4.0) Opens an SQLite database and returns an SQLiteDatabase object SQLiteDatabase sqlite_factory ( string $filename [, int $mode = 0666 [, string &$error_message ]] ) sqlite_factory() behaves similarly to sqlite_open() in that it opens an SQLite database or attempts to create it if it does not exist. However, a SQLiteDatabase object is returned rather than a resource. Please see the sqlite_open() referenc

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Fetches all rows from a result set as an array of arrays array sqlite_fetch_all ( resource $result [, int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) Object oriented style (method): array SQLiteResult::fetchAll ([ int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) array SQLiteUnbuffered::fetchAll ([ int $result_type = SQLITE_BOTH [, bool $decode_

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Fetches the next row from a result set as an array array sqlite_fetch_array ( resource $result [, int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) Object oriented style (method): array SQLiteResult::fetch ([ int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) array SQLiteUnbuffered::fetch ([ int $result_type = SQLITE_BOTH [, bool $decode_binary = t

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Returns the textual description of an error code string sqlite_error_string ( int $error_code ) Returns a human readable description of the error_code returned from sqlite_last_error(). Parameters: error_code The error code being used, which might be passed in from sqlite_last_error(). Returns: Returns

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.3) Executes a result-less query against a given database bool sqlite_exec ( resource $dbhandle, string $query [, string &$error_msg ] ) bool sqlite_exec ( string $query , resource $dbhandle ) Object oriented style (method): public bool SQLiteDatabase::queryExec ( string $query [, string &$error_msg ] ) Executes an SQL statement given by the query against a given database han

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Escapes a string for use as a query parameter 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. Although the encoding makes it safe to insert the data, it will r

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0) Fetches the current row from a result set as an array array sqlite_current ( resource $result [, int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) Object oriented style (method): array SQLiteResult::current ([ int $result_type = SQLITE_BOTH [, bool $decode_binary = true ]] ) array SQLiteUnbuffered::current ([ int $result_type = SQLITE_BOTH [, bool $decode_binary