sqlite php reference

An ever-growing collection of SQLite/PHP reference.

The SQLite3Result class

$result -> fetchArray ( int $mode = SQLITE3_BOTH ) : array|false

Fetches a result row as an associative or numerically indexed array or both.
$mode: Controls how the next row will be returned to the caller.

SQLITE3_ASSOC: returns an array indexed by column name.

SQLITE3_NUM: returns an array indexed by column number (zero based).

SQLITE3_BOTH: returns an array indexed by both column name and number (zero based).

Returns a result row as an associatively or numerically indexed array or both. Alternately will return false if there are no more rows.

SQLITE3_INTEGER -> int/String if outside range

SQLITE3_FLOAT -> float

SQLITE3_TEXT -> string

SQLITE3_BLOB -> string

SQLITE3_NULL -> null

$result -> finalize ( ) : bool

Closes the result set.
Returns true on success.

$result -> numColumns ( ) : int

Returns the number of columns in the result set.

$result -> reset ( ) : bool

Resets the result set back to the first row.
Returns true if the result set is successfully reset back to the first row, false on failure.

Last modified: July 12th, 2023