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 = "CREATE TABLE таблица1(
id INTEGER PRIMARY KEY,
col1 INT,
col2 TEXT
);";
$db->exec($sql);
$sql = "INSERT INTO таблица1(col1, col2) VALUES
('aaaa', 'bbbbb'),
('xxx', 'yyy');";
$db->exec($sql);
$sql = "SELECT * FROM таблица1;";
$result = $db->query($sql);
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
$array[] = $row;
}
print json_encode($array);