Detailed explanation of PHP SQlite function library_PHP tutorial

PHP SQlite database is familiar to PHP programmers with considerable experience, but it is not easy to fully master the application of related functions of PHP SQlite database. Below we have summarized some related functions of PHP SQlite database for everyone.

sqlite_array_query of PHP SQlite database - send a SQL query and return an array.

sqlite_busy_timeout ——
Set the timeout (busy timeout duration), or frequent users lose permissions (disable busy handlers).

sqlite_changes ——
Returns the number of rows changed by the most recent SQL statement.

sqlite_close ——
Close an open SQLite database.

sqlite_column ——
Get a column from the current row of a result set.

sqlite_create_aggregate ——
Register an aggregating UDF for use in SQL statements.

sqlite_create_function ——
Registers a "regular" User Defined Function for use in SQL statements.

sqlite_current ——
Get the current row from a result set as an array.

sqlite_error_string ——
Returns the textual description of an error code.

sqlite_escape_string ——
Escapes a string for use as a query parameter.

sqlite_fetch_array——
Get the next row from a result set as an array.

sqlite_fetch_single ——
​Fetches the first column of a result set as a string.

sqlite_fetch_string ——
Alias ​​of sqlite_fetch_single().

sqlite_field_name ——
Get the field name of the specified field in the result.

sqlite_has_more ——
Returns whether or not more rows are available.

sqlite_last_error ——
Returns the latest error code of the database (the error code of the last error for a database).

sqlite_last_insert_rowid ——
Returns the row number of the most recently inserted row (the most recently inserted row).

sqlite_libencoding ——
Returns the encoding of the SQLite library.

sqlite_libversion of PHP SQlite database ——
Returns the version of the SQLite library.

sqlite_next ——
Returns the line number of the next line.

sqlite_num_fields ——
Get the number of fields in the result set.

sqlite_num_rows ——
Get the number of rows in the result set.

sqlite_open ——
​Open a SQLite database. If the file does not exist, try to create it.

sqlite_popen ——
Open a SQLite database using a permanent connection. If the file does not exist, try to create it.

sqlite_query ——
Send a SQL query and return a result handle.

sqlite_rewind ——
Seek to the first row number.

sqlite_seek ——
Seek to a particular row number of a buffered result set.

sqlite_udf_decode_binary ——
Decode binary data passed as parameters to an UDF.

sqlite_udf_encode_binary——
​Encode binary data before returning it from an UDF.

PHP SQlite database sqlite_unbuffered_query ——
Sends a SQL query without retrieving and caching the result rows.

http://www.bkjia.com/PHPjc/486426.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/486426.htmlTechArticlePHP SQlite database is familiar to PHP programmers with considerable experience, but if you want to fully master it The application of related functions of PHP SQlite database is not easy. Below...