php8.5
/
Download
Home/ Manual/ reference / sqlite3/ The SQLite3 class

The SQLite3 class

Guide Edit on GitHub ✎

A class that interfaces SQLite 3 databases.

Intro

A class that interfaces SQLite 3 databases.

Class synopsis

class SQLite3 { }

Predefined Constants

SQLite3::OK

Returned from an authorizer callback to allow the action.

SQLite3::DENY

Returned from an authorizer callback to reject the entire SQL statement with an error.

SQLite3::IGNORE

Returned from an authorizer callback to disallow the specific action while still allowing the SQL statement to be compiled. See SQLite3::setAuthorizer for the effect on each action.

SQLite3::CREATE_INDEX
SQLite3::CREATE_TABLE
SQLite3::CREATE_TEMP_INDEX
SQLite3::CREATE_TEMP_TABLE
SQLite3::CREATE_TEMP_TRIGGER
SQLite3::CREATE_TEMP_VIEW
SQLite3::CREATE_TRIGGER
SQLite3::CREATE_VIEW
SQLite3::DELETE
SQLite3::DROP_INDEX
SQLite3::DROP_TABLE
SQLite3::DROP_TEMP_INDEX
SQLite3::DROP_TEMP_TABLE
SQLite3::DROP_TEMP_TRIGGER
SQLite3::DROP_TEMP_VIEW
SQLite3::DROP_TRIGGER
SQLite3::DROP_VIEW
SQLite3::INSERT
SQLite3::PRAGMA
SQLite3::READ
SQLite3::SELECT
SQLite3::TRANSACTION
SQLite3::UPDATE
SQLite3::ATTACH
SQLite3::DETACH
SQLite3::ALTER_TABLE
SQLite3::REINDEX
SQLite3::ANALYZE
SQLite3::CREATE_VTABLE
SQLite3::DROP_VTABLE
SQLite3::FUNCTION
SQLite3::SAVEPOINT
SQLite3::COPY
SQLite3::RECURSIVE

Changelog

VersionDescription

Sqlite3

In this section

SQLite3::__construct

Instantiates an SQLite3 object and opens an SQLite 3 database

SQLite3::backup

Backup one database to another database

SQLite3::busyTimeout

Sets the busy connection handler

SQLite3::changes

Returns the number of database rows that were changed (or inserted or deleted) by the most...

SQLite3::close

Closes the database connection

SQLite3::createAggregate

Registers a PHP function for use as an SQL aggregate function

SQLite3::createCollation

Registers a PHP function for use as an SQL collating function

SQLite3::createFunction

Registers a PHP function for use as an SQL scalar function

SQLite3::enableExceptions

Enable throwing exceptions

SQLite3::enableExtendedResultCodes

Enables or disables the use of extended result codes

SQLite3::escapeString

Returns a string that has been properly escaped

SQLite3::exec

Executes a result-less query against a given database

SQLite3::lastErrorCode

Returns the numeric result code of the most recent failed SQLite request

SQLite3::lastErrorMsg

Returns English text describing the most recent failed SQLite request

SQLite3::lastExtendedErrorCode

Returns the numeric extended result code of the most recent failed SQLite request

SQLite3::lastInsertRowID

Returns the row ID of the most recent INSERT into the database

SQLite3::loadExtension

Attempts to load an SQLite extension library

SQLite3::open

Opens an SQLite database

SQLite3::openBlob

Opens a stream resource to read a BLOB

SQLite3::prepare

Prepares an SQL statement for execution

SQLite3::query

Executes an SQL query

SQLite3::querySingle

Executes a query and returns a single result

SQLite3::setAuthorizer

Configures a callback to be used as an authorizer to limit what a statement can do

SQLite3::version

Returns the SQLite3 library version as a string constant and as a number

Source: reference/sqlite3/sqlite3.xml · from the official PHP manual (php/doc-en)