How can I select all rows using SQLite3::open? The following code only outputs one row.
I got my starting code here. //www.php.net/manual/en/sqlite3.open.php
- php
- sqlite
asked Apr 12, 2016 at 3:09
Papa De BeauPapa De Beau
3,57618 gold badges78 silver badges134 bronze badges
5
Also, the query isn't run from
open
method. It's run from thequery
method. Maybe you need to read all of the documentation to get a better understanding before trying to implement code you don't understand.Apr 12, 2016 at 3:14
I get an error when I try this code: Fatal error: Call to undefined function sqlite_open[]
Apr 12, 2016 at 3:16
I found the answer. I posted it. Thanks for your help.
Apr 12, 2016 at 3:18
Soooo, reading the documentation further helped?
Apr 12, 2016 at 6:25
1 Answer
answered Apr 12, 2016 at 3:19
Papa De BeauPapa De Beau
3,57618 gold badges78 silver badges134 bronze badges
[PHP 5 >= 5.3.0, PHP 7, PHP 8]
SQLite3Result::fetchArray — Fetches a result row as an associative or numerically indexed array or both
Description
public SQLite3Result::fetchArray[int $mode
= SQLITE3_BOTH
]:
array|false
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 setSQLITE3_NUM
: returns an array indexed by column number as returned in the corresponding result set, starting at column 0SQLITE3_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 int 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.
paule-panke at example dot com ¶
5 years ago
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.
Jason ¶
7 years ago
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: