PHP MANUAL

book.sqlite.html | book.sqlite3.html | class.sqlite3.html | class.sqlite3result.html | class.sqlite3stmt.html | function.pdo-sqlitecreateaggregate.html | function.pdo-sqlitecreatefunction.html | function.sqlite-array-query.html | function.sqlite-busy-timeout.html | function.sqlite-changes.html | function.sqlite-close.html | function.sqlite-column.html | function.sqlite-create-aggregate.html | function.sqlite-create-function.html | function.sqlite-current.html | function.sqlite-error-string.html | function.sqlite-escape-string.html | function.sqlite-exec.html | function.sqlite-factory.html | function.sqlite-fetch-all.html | function.sqlite-fetch-array.html | function.sqlite-fetch-column-types.html | function.sqlite-fetch-object.html | function.sqlite-fetch-single.html | function.sqlite-fetch-string.html | function.sqlite-field-name.html | function.sqlite-has-more.html | function.sqlite-has-prev.html | function.sqlite-key.html | function.sqlite-last-error.html | function.sqlite-last-insert-rowid.html | function.sqlite-libencoding.html | function.sqlite-libversion.html | function.sqlite-next.html | function.sqlite-num-fields.html | function.sqlite-num-rows.html | function.sqlite-open.html | function.sqlite-popen.html | function.sqlite-prev.html | function.sqlite-query.html | function.sqlite-rewind.html | function.sqlite-seek.html | function.sqlite-single-query.html | function.sqlite-udf-decode-binary.html | function.sqlite-udf-encode-binary.html | function.sqlite-unbuffered-query.html | function.sqlite-valid.html | intro.sqlite.html | intro.sqlite3.html | ref.pdo-sqlite.connection.html | ref.pdo-sqlite.html | ref.sqlite.html | sqlite.configuration.html | sqlite.constants.html | sqlite.installation.html | sqlite.requirements.html | sqlite.resources.html | sqlite.setup.html | sqlite3.changes.html | sqlite3.close.html | sqlite3.configuration.html | sqlite3.constants.html | sqlite3.construct.html | sqlite3.createaggregate.html | sqlite3.createfunction.html | sqlite3.escapestring.html | sqlite3.exec.html | sqlite3.installation.html | sqlite3.lasterrorcode.html | sqlite3.lasterrormsg.html |

SQLite

• Introduction
• Installing/Configuring
  • Requirements
  • Installation
  • Runtime Configuration
  • Resource Types
• Predefined Constants
• SQLite Functions
  • sqlite_array_query — Execute a query against a given database and returns an array
  • sqlite_busy_timeout — Set busy timeout duration, or disable busy handlers
  • sqlite_changes — Returns the number of rows that were changed by the most recent SQL statement
  • sqlite_close — Closes an open SQLite database
  • sqlite_column — Fetches 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 — Fetches 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_exec — Executes a result-less query against a given database
  • sqlite_factory — Opens a SQLite database and returns a SQLiteDatabase object
  • sqlite_fetch_all — Fetches all rows from a result set as an array of arrays
  • sqlite_fetch_array — Fetches the next row from a result set as an array
  • sqlite_fetch_column_types — Return an array of column types from a particular table
  • sqlite_fetch_object — Fetches the next row from a result set as an object
  • 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 — Returns the name of a particular field
  • sqlite_has_more — Finds whether or not more rows are available
  • sqlite_has_prev — Returns whether or not a previous row is available
  • sqlite_key — Returns the current row index
  • sqlite_last_error — Returns the error code of the last error for a database
  • sqlite_last_insert_rowid — Returns the rowid of the most recently inserted row
  • sqlite_libencoding — Returns the encoding of the linked SQLite library
  • sqlite_libversion — Returns the version of the linked SQLite library
  • sqlite_next — Seek to the next row number
  • sqlite_num_fields — Returns the number of fields in a result set
  • sqlite_num_rows — Returns the number of rows in a buffered result set
  • sqlite_open — Opens a SQLite database and create the database if it does not exist
  • sqlite_popen — Opens a persistent handle to an SQLite database and create the database if it does not exist
  • sqlite_prev — Seek to the previous row number of a result set
  • sqlite_query — Executes a query against a given database and returns 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_single_query — Executes a query and returns either an array for one single column or the value of the first row
  • 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 — Execute a query that does not prefetch and buffer all data
  • sqlite_valid — Returns whether more rows are available