Can't get data from table with php and sqlite db

Question

I want to echo onto my screen all the data is my 'userdata' table. i have looked around and found this code but when i run it i get a HTTP ERROR 500. this is my code that im trying to use:

<?php
    $database = new SQLite3('home.db');

    $result = $database->query("SELECT * FROM userdata");
    echo $result;
?>

You can't echo the result. I'd suggest reading the documentation, which gives plenty of examples to show what you need to do. — aynber
– aynber, Commented Oct 8, 2018 at 16:38
If you're just trying to see the result set for debug/visualization purposes, wrap the result, like this: print_r($result); — hyper_text_coffee_pot
– hyper_text_coffee_pot, Commented Oct 8, 2018 at 16:48

Wessel van der Linden · Accepted Answer · 2018-10-08 16:52:24Z

1

the $database->query() method will return an SQLite3Result object which you can't just "echo". Instead, you should loop through all the results like so:

<?php
    $database = new SQLite3('home.db');

    $result = $database->query("SELECT * FROM userdata");

    while ($row = $result->fetchArray()) {
        print_r($row);
    }
?>

The $row variable inside the while loop will be an array. Use the appropriate index to get the value of a single column if necessary.

answered Oct 8, 2018 at 16:52

Wessel van der Linden

2,6322 gold badges26 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Can't get data from table with php and sqlite db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related