Predefined Constants
The constants below are defined by this extension, and
will only be available when the extension has either
been compiled into PHP or dynamically loaded at runtime.
The functions sqlite_fetch_array and
sqlite_current use a constant for
the different types of result arrays. The following constants are
defined:
SQLite result type constants
-
SQLITE_ASSOC
(int)
-
Columns are returned into the array having the field name as the array
index.
-
SQLITE_BOTH
(int)
-
Columns are returned into the array having both a numerical index
and the field name as the array index.
-
SQLITE_NUM
(int)
-
Columns are returned into the array having a numerical index to the
fields. This index starts with 0, the first field in the result.
A number of functions may return status codes. The following constants are
defined:
SQLite status code constants
-
SQLITE_OK
(int)
-
Successful result.
-
SQLITE_ERROR
(int)
-
SQL error or missing database.
-
SQLITE_INTERNAL
(int)
-
An internal logic error in SQLite.
-
SQLITE_PERM
(int)
-
Access permission denied.
-
SQLITE_ABORT
(int)
-
Callback routine requested an abort.
-
SQLITE_BUSY
(int)
-
The database file is locked.
-
SQLITE_LOCKED
(int)
-
A table in the database is locked.
-
SQLITE_NOMEM
(int)
-
Memory allocation failed.
-
SQLITE_READONLY
(int)
-
Attempt to write a readonly database.
-
SQLITE_INTERRUPT
(int)
-
Operation terminated internally.
-
SQLITE_IOERR
(int)
-
Disk I/O error occurred.
-
SQLITE_NOTADB
(int)
-
File opened that is not a database file.
-
SQLITE_CORRUPT
(int)
-
The database disk image is malformed.
-
SQLITE_FORMAT
(int)
-
Auxiliary database format error.
-
SQLITE_NOTFOUND
(int)
-
(Internal) Table or record not found.
-
SQLITE_FULL
(int)
-
Insertion failed because database is full.
-
SQLITE_CANTOPEN
(int)
-
Unable to open the database file.
-
SQLITE_PROTOCOL
(int)
-
Database lock protocol error.
-
SQLITE_EMPTY
(int)
-
(Internal) Database table is empty.
-
SQLITE_SCHEMA
(int)
-
The database schema changed.
-
SQLITE_TOOBIG
(int)
-
Too much data for one row of a table.
-
SQLITE_CONSTRAINT
(int)
-
Abort due to constraint violation.
-
SQLITE_MISMATCH
(int)
-
Data type mismatch.
-
SQLITE_MISUSE
(int)
-
Library used incorrectly.
-
SQLITE_NOLFS
(int)
-
Uses of OS features not supported on host.
-
SQLITE_AUTH
(int)
-
Authorized failed.
-
SQLITE_ROW
(int)
-
Internal process has another row ready.
-
SQLITE_DONE
(int)
-
Internal process has finished executing.