populate php array with while loop?

Question

Is there a way to output an sqlite table to a php array?

I am currently trying to use a while loop but it does not display correctly.

$db = sqlite_open ("products.db", 0666, $error);
$result=sqlite_query($db,"SELECT * from Books");
$products = array();
while($row=sqlite_fetch_array($result,SQLITE_ASSOC))
{
    $products = $row;
}

I want this to store into a 2D php array as if it were:

$products = array(
    1 => array(
        'name' => '',
        'price' => ,
        'category' => '',
        'description' => ''
    ),
    2 => array(
        'name' => '',
        'price' => ,
        'category' => '',
        'description' => ''
    ),
    3 => array(
        'name' => '',
        'price' => ,
        'category' => '',
        'description' => ''
    )
);

use an array assignment, every iteration, its overwritten, you could also use your ID as the key in assignment $products[$row['id']] etc. — Kevin
– Kevin, Commented Mar 17, 2015 at 0:24

John Conde · Accepted Answer · 2015-03-17 00:22:38Z

4

You're close. You just need to add each row to your array instead of overwriting the array variable which you are currently doing..

while($row=sqlite_fetch_array($result,SQLITE_ASSOC))
{
    $products[] = $row;
}

answered Mar 17, 2015 at 0:22

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

1 Comment

SilentUK Over a year ago

Thank you this has fixed the issue!

Collectives™ on Stack Overflow

populate php array with while loop?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related