无法从php和sqlite db获取表中的数据
问题描述：
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;
?>
答
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.