PHP SQlite function library details

PHP SQlite database is no stranger to PHP programmers with considerable experience, but it is not easy to fully master the application of functions related to PHP SQlite database. Below we will summarize some functions related to the PHP SQlite database.

 

 

 

 

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

Sqlite_busy_timeout --
Set the time-out (busy timeout duration), or frequently lose 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 --
Get 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 --
Get the current row from a result set as an array in the returned array ).

Sqlite_error_string --
Return the original description of the error code (the textual description of an error code ).

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

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

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

Sqlite_fetch_string --
Sqlite_fetch_single () alias.

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

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

Sqlite_last_error --
The error code of the last error for a database is returned ).

Sqlite_last_insert_rowid --
Returns the row number (the most recently inserted row) of the last 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 row number of the next row.

Sqlite_num_fields --
Number of fields in the result set.

Sqlite_num_rows --
Number of rows in the result set.

Sqlite_open --
Open an SQLite database. If the file does not exist, try to create it.

Sqlite_popen --
Open an SQLite database by means of permanent connection. If the file does not exist, try to create it.

Sqlite_query --
Send an SQL query and return a result handle ).

Sqlite_rewind --
Returns the first row number (Seek to the first row number ).

Sqlite_seek --
Search for a specific row number (Seek to a particle row number of a buffered result set) in the cache result ).

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 PHP SQlite database --
A row that sends an SQL query and does not obtain or cache the result.