php query on sqlite3 db only returns first row

Question

I created an Sqlite3 database with PHP:

$db = new SQLite3('mysqlitedb.db');
$db->exec('CREATE TABLE foo (bar STRING)');
$db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");
$db->exec("INSERT INTO foo (bar) VALUES ('This is another test')");

but when I try to get all the rows:

$result = $db->query('SELECT * FROM foo');
var_dump($result->fetchArray());

it only returns the first row in the db:

array(2) { [0]=> string(14) "This is a test" ["bar"]=> string(14) "This is a test" }

I'm not sure why it isn't returning all the rows.

QuantumRob · Accepted Answer · 2011-11-16 21:35:50Z

9

You need to iterate over the rows. You'll only get the current row.

while($row=$result->fetchArray()){
   // Do Something with $row
   print_r($row);
}

The PHP Manual has a good example on the page

answered Nov 16, 2011 at 21:35

QuantumRob

2,9243 gold badges24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mah Over a year ago

To follow on to why you must do this... imagine you had a database with several million rows and each row was many KB large... consider how much memory you would need to load the entire table at once.

QuantumRob Over a year ago

@mah that would be funny to see a server load all that into memory!

davidraedev Over a year ago

@MechSoftware thanks that worked, first time diving into sqlite3.

QuantumRob Over a year ago

Thank you. Please "Accept" the answer (check mark outline) if it works for you. Best of luck!

George Cummins · Accepted Answer · 2011-11-16 21:38:03Z

2

fetchArray() fetches only the first row of results. If you want to fetch additional rows, make additional calls to fetchArray (perhaps in a loop).

answered Nov 16, 2011 at 21:38

George Cummins

29k8 gold badges74 silver badges91 bronze badges

Comments

NuclearPeon · Accepted Answer · 2013-03-14 00:12:51Z

0

Requesting an answer where all results are returned in one array. It seems wasteful to be able to get all results in one object, have them split by array entry, then having to put them back into one array.

answered Mar 14, 2013 at 0:12

NuclearPeon

6,1175 gold badges51 silver badges57 bronze badges

Collectives™ on Stack Overflow

php query on sqlite3 db only returns first row

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related