Predefined Constants
SQLite3::changes
SQLite3
PHP Manual
The SQLite3 class
Introduction
A class that interfaces SQLite 3 databases.
Class synopsis
SQLite3
{
/* Methods */
public
int
changes
(
void
)
public
bool
close
(
void
)
__construct
(
string
$filename
[,
int
$flags
[,
string
$encryption_key
]] )
public
bool
createAggregate
(
string
$name
,
mixed
$step_callback
,
mixed
$final_callback
[,
int
$argument_count
= -1
] )
public
bool
createFunction
(
string
$name
,
mixed
$callback
[,
int
$argument_count
= -1
] )
public
string
escapeString
(
string
$value
)
public
bool
exec
(
string
$query
)
public
int
lastErrorCode
(
void
)
public
string
lastErrorMsg
(
void
)
public
int
lastInsertRowID
(
void
)
public
bool
loadExtension
(
string
$shared_library
)
public
bool
open
(
string
$filename
[,
int
$flags
= SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE
[,
string
$encryption_key
]] )
public
SQLite3Stmt
prepare
(
string
$query
)
public
SQLite3Result
query
(
string
$query
)
public
mixed
querySingle
(
string
$query
[,
bool
$entire_row
= false
] )
public
array
version
(
void
)
}
Table of Contents
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::createFunction
— Registers a PHP function for use as an SQL scalar function
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::prepare
— Prepares an SQL statement for execution
SQLite3::query
— Executes an SQL query
SQLite3::querySingle
— Executes a query and returns a single result
SQLite3::version
— Returns the SQLite3 library version as a string constant and as a number
Predefined Constants
SQLite3::changes
SQLite3
PHP Manual