PHP SQlite Library Detailed _php tutorial

The PHP SQLite database is not unfamiliar to a PHP programmer with considerable experience, but it is not easy to fully master the application of the relevant functions of the PHP SQLite database. Here we summarize some of the PHP SQLite database related functions.

The sqlite_array_query--of the PHP SQLite database sends an SQL query and returns an array.

sqlite_busy_timeout--
Set the timeout time (busy timeout duration), or the frequent user loses permissions (disable busy handlers).

sqlite_changes--
Returns the number of rows changed by the latest SQL query (changed by the most recent SQL statement).

sqlite_close--
Close an open SQLite database.

sqlite_column--
Gets a column in the current row (A-column from the present 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--
Gets the current row in the returned array (the present row from a result set as an array).

sqlite_error_string--
Returns the original description of the error code (the textual description of an error codes).

sqlite_escape_string--
Frees a string for querying (Escapes a string for use as a query parameter).

sqlite_fetch_array--
Gets the next line and sets it to an array (the next row from a result set as an array).

sqlite_fetch_single--
Gets the first column and sets it to a string (fetches the initial column of a result set as a string).

sqlite_fetch_string--
The alias of the Sqlite_fetch_single ().

sqlite_field_name--
Gets the field name of the specified field in the result.

sqlite_has_more--
Returns whether there is more rows available (whether or not more rows is available).

sqlite_last_error--
Returns the most recent error code for the database (the error, code of the last error, a database).

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

sqlite_libencoding--
Returns the encoding of the SQLite Library (encoding).

sqlite_libversion--of the PHP SQLite database
Returns the version of the SQLite library.

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

sqlite_num_fields--
Gets the number of fields in the result set.

sqlite_num_rows--
Gets 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 in a permanent connection. If the file does not exist, try to create it.

sqlite_query--
Sends an SQL query and returns a result handle (a handle).

sqlite_rewind--
Rewind the first row (Seek to the initial row number).

sqlite_seek--
Finds a specific line number in the cached result (Seek to a particular row numbers 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 a UDF.

sqlite_unbuffered_query--of the PHP SQLite database
Sends a SQL query that does not fetch and cache the resulting rows.

http://www.bkjia.com/PHPjc/486426.html www.bkjia.com true http://www.bkjia.com/PHPjc/486426.html techarticle The PHP SQLite database is not unfamiliar to a PHP programmer with considerable experience, but it is not easy to fully master the application of the relevant functions of the PHP SQLite database. Below ...

