Downloads
Documentation
Get Involved
Help
Getting Started
Introduction
A simple tutorial
Language Reference
Basic syntax
Types
Variables
Constants
Expressions
Operators
Control Structures
Functions
Classes and Objects
Namespaces
Enumerations
Errors
Exceptions
Fibers
Generators
Attributes
References Explained
Predefined Variables
Predefined Exceptions
Predefined Interfaces and Classes
Predefined Attributes
Context options and parameters
Supported Protocols and Wrappers
Security
Introduction
General considerations
Installed as CGI binary
Installed as an Apache module
Session Security
Filesystem Security
Database Security
Error Reporting
User Submitted Data
Hiding PHP
Keeping Current
Features
HTTP authentication with PHP
Cookies
Sessions
Handling file uploads
Using remote files
Connection handling
Persistent Database Connections
Command line usage
Garbage Collection
DTrace Dynamic Tracing
Function Reference
Affecting PHP's Behaviour
Audio Formats Manipulation
Authentication Services
Command Line Specific Extensions
Compression and Archive Extensions
Cryptography Extensions
Database Extensions
Date and Time Related Extensions
File System Related Extensions
Human Language and Character Encoding Support
Image Processing and Generation
Mail Related Extensions
Mathematical Extensions
Non-Text MIME Output
Process Control Extensions
Other Basic Extensions
Other Services
Search Engine Extensions
Server Specific Extensions
Session Extensions
Text Processing
Variable and Type Related Extensions
Web Services
Windows Only Extensions
XML Manipulation
GUI Extensions
Keyboard Shortcuts
?
This help
j
Next menu item
k
Previous menu item
g p
Previous man page
g n
Next man page
G
Scroll to bottom
g g
Scroll to top
g h
Goto homepage
g s
Goto search
(current page)
/
Focus search box
Introduction »
« PgSql\Lob
PHP Manual
Function Reference
Database Extensions
Vendor Specific Database Extensions
Change language:
English
German
Spanish
French
Italian
Japanese
Brazilian Portuguese
Russian
Turkish
Ukrainian
Chinese (Simplified)
Other
SQLite3
Introduction
Installing/Configuring
Requirements
Installation
Runtime Configuration
Predefined Constants
SQLite3
— The SQLite3 class
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 recent SQL statement
SQLite3::close
— Closes the database connection
SQLite3::__construct
— Instantiates an SQLite3 object and opens an SQLite 3 database
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::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::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
SQLite3Exception
— The SQLite3Exception class
SQLite3Stmt
— The SQLite3Stmt class
SQLite3Stmt::bindParam
— Binds a parameter to a statement variable
SQLite3Stmt::bindValue
— Binds the value of a parameter to a statement variable
SQLite3Stmt::clear
— Clears all current bound parameters
SQLite3Stmt::close
— Closes the prepared statement
SQLite3Stmt::__construct
— Constructs an SQLite3Stmt object
SQLite3Stmt::execute
— Executes a prepared statement and returns a result set object
SQLite3Stmt::getSQL
— Get the SQL of the statement
SQLite3Stmt::paramCount
— Returns the number of parameters within the prepared statement
SQLite3Stmt::readOnly
— Returns whether a statement is definitely read only
SQLite3Stmt::reset
— Resets the prepared statement
SQLite3Result
— The SQLite3Result class
SQLite3Result::columnName
— Returns the name of the nth column
SQLite3Result::columnType
— Returns the type of the nth column
SQLite3Result::__construct
— Constructs an SQLite3Result
SQLite3Result::fetchArray
— Fetches a result row as an associative or numerically indexed array or both
SQLite3Result::finalize
— Closes the result set
SQLite3Result::numColumns
— Returns the number of columns in the result set
SQLite3Result::reset
— Resets the result set back to the first row
Improve This Page
Learn How To Improve This Page
•
Submit a Pull Request
•
Report a Bug
+
add a note
User Contributed Notes
There are no user contributed notes for this page.