SQLite3Result::fetchArray

SQLite3Result::fetchArray —
Fetches a result row as an associative or numerically indexed array or both

Description

publicarraySQLite3Result::fetchArray
([ int$mode = SQLITE3_BOTH
] )

Fetches a result row as an associative or numerically indexed array or both.
By default, fetches as both.

Parameters

mode

Controls how the next row will be returned to the caller. This value
must be one of either SQLITE3_ASSOC,
SQLITE3_NUM, or SQLITE3_BOTH.

SQLITE3_ASSOC: returns an array indexed by column
name as returned in the corresponding result set

SQLITE3_NUM: returns an array indexed by column
number as returned in the corresponding result set, starting at
column 0

SQLITE3_BOTH: returns an array indexed by both
column name and number as returned in the corresponding result set,
starting at column 0

Return Values

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

The types of the values of the returned array are mapped from SQLite3 types
as follows: integers are mapped to integer if they fit into the
range PHP_INT_MIN..PHP_INT_MAX, and
to string otherwise. Floats are mapped to float,
NULL values are mapped to null, and strings
and blobs are mapped to string.

User Contributed Notes 4 notes

Check with SQLite3Result::numColumns() for an empty result before calling SQLite3Result::fetchArray().

In contrast to the documentation SQLite3::query() always returns a SQLite3Result instance, not only for queries returning rows (SELECT, EXPLAIN). Each time SQLite3Result::fetchArray() is called on a result from a result-less query internally the query is executed again, which will most probably break your application.For a framwork or API it's not possible to know in before whether or not a query will return rows (SQLite3 supports multi-statement queries). Therefore the argument "Don't execute query('CREATE ...')" is not valid.

Would just like to point out for clarification that each call to fetchArray() returns the next result from SQLite3Result in an array, until there are no more results, whereupon the next fetchArray() call will return false.

HOWEVER an additional call of fetchArray() at this point will reset back to the beginning of the result set and once again return the first result. This does not seem to explicitly documented, and caused me my own fair share of headaches for a while until I figured it out.

For example:

<?php $returned_set = $database->query("select query or whatever");

//Lets say the query returned 3 results //Normally the following while loop would run 3 times then, as $result wouldn't be false until the fourth call to fetchArray()while($result = $returned_set->fetchArray()) {//HOWEVER HAVING AN ADDITIONAL CALL IN THE LOOP WILL CAUSE THE LOOP TO RUN AGAIN$returned_set->fetchArray(); }?>

Basically, in the above code fetchArray will return:1st call | 1st result from $returned_set (fetchArray() call from while condition)2nd call | 2nd result (fetchArray() call from while block)3rd call | 3rd result (fetchArray() call from while condition)4th call |FALSE (fetchArray() call from while block)5th call | 1st result (fetchArray() call from while condition)....

This will cause (at least in this case) the while loop to run infinitely.