Shulou(Shulou.com)06/03 Report--

Today, I will talk to you about the functions related to PHP SQlite database, which may not be well understood by many people. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

PHP SQlite database is no stranger to experienced PHP programmers, but it is not easy to fully master the application of related functions of PHP SQlite database. Below we summarize some related functions of PHP SQlite database for you.

Sqlite_array_query of the PHP SQlite database-sends a SQL query and returns an array.

Sqlite_busy_timeout-sets the timeout (busy timeout duration), or frequent user loss of privileges (disable busy handlers).

Sqlite_changes-returns the number of rows changed by the * SQL query (changed by the most recent SQL statement).

Sqlite_close-closes an open SQLite database.

Sqlite_column-gets a column (a column from the current row of a result set) in the current row.

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

Sqlite_error_string-returns the raw description (the textual description of an error code) of the error code.

Sqlite_escape_string-releases a string (Escapes a string for use as a query parameter) for the query.

Sqlite_fetch_array-- takes the next row and sets it to an array (the next row from a result set as an array).

Sqlite_fetch_single-- take the * * column and set it to a string (Fetches the first column of a result set as a string).

Sqlite_fetch_string-an alias for sqlite_fetch_single ().

Sqlite_field_name-- gets the field name of the specified field in the result.

Sqlite_has_more-returns whether more rows are available (whether or not more rows are available).

Sqlite_last_error-returns the error code (the error code of the last error for a database) of the database.

Sqlite_last_insert_rowid-returns the line number (the most recently inserted row) of the row inserted by * *.

Sqlite_libencoding-returns the encoding (encoding) of the SQLite library (SQLite library).

Sqlite_libversion of the PHP SQlite database-returns the version of the SQLite library (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 with a * * connection. If the file does not exist, try to create it.

Sqlite_query-sends a SQL query and returns a result a result handle.

Sqlite_rewind-- rewind the * * line (Seek to the first row number).

Sqlite_seek-look for a specific line number (Seek to a particular row number of a buffered result set) in the cached results.

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.

Sqlite_unbuffered_query of the PHP SQlite database-sends a SQL query without fetching and caching rows of results.

After reading the above, do you have any further understanding of the functions related to PHP SQlite database? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.