CCCPaste

PHP sqlite3 json results

query("SELECT * FROM $table");
$data = array();
while ($row = $results->fetchArray(SQLITE3_ASSOC)) {
  array_push($data,$row);
}
print json_encode($data);
?>