Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$db = new SQLite3(':memory:');
$sql = "DROP TABLE IF EXISTS tbl1;";
var_dump($db->exec($sql));
$sql = "CREATE TABLE tbl1(
id INTEGER PRIMARY KEY,
c1 TEXT,
c2 TEXT
);";
var_dump($db->exec($sql));
$sql = "INSERT INTO tbl1(c1, c2) VALUES
('aaaa', 'bbbbb'),
('xxx', 'yyy');";
var_dump($db->exec($sql));
$sql = "SELECT * FROM tbl1 ;";
$result = $db->query($sql);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$array[] = $row;
}
print json_encode($array);