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.