F.35. SQLite
| Function | Returns | Description |
|---|---|---|
sqlite_popen(string filename [, int mode [, string &error_message]]) | resource | Opens a persistent handle to a SQLite database. Will create the database if it does not exist. |
sqlite_open(string filename [, int mode [, string &error_message]]) | resource | Opens a SQLite database. Will create the database if it does not exist. |
sqlite_factory(string filename [, int mode [, string &error_message]]) | object | Opens a SQLite database and creates an object for it. Will create the database if it does not exist. |
sqlite_busy_timeout(resource db, int ms) | void | Sets busy timeout duration. If ms <= 0, all busy handlers are disabled. |
sqlite_close(resource db) | void | Closes an open sqlite database. |
sqlite_unbuffered_query(string query, resource db [ , int result_type ]) | resource | Executes a query that does not prefetch and buffer all data. |
sqlite_query(string query, resource db [, int result_type ]) | resource | Executes a query against a given database and returns a result handle. |
sqlite_fetch_all(resource result [, int result_type [, bool decode_binary]]) | array | Fetches all rows from a result set as an array of arrays. |
sqlite_fetch_array(resource result [, int result_type [, bool decode_binary]]) | array | Fetches the next row from a result set as an array. |
sqlite_fetch_object(resource result [, string class_name [, NULL|array ctor_params [, bool decode_binary]]]) | object | Fetches the next row from a result set as an object. |
sqlite_array_query(resource db, string query [ , int result_type ... |
Get Web Standards Programmer's Reference: HTML, CSS, JavaScript®, Perl, Python®, and PHP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
