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
create table Test(id integer, title varchar(100));
insert into Test(id, title) values(1, "Hello");
select * from Test;
<?php
printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion());
$query = "SELECT VERSION() as version;";
// Run query using mysqli
$result = $mysqli->query($query);
$version = $result->fetch_object();
printf('DB version (mysqli): %s ' . PHP_EOL, $version->version);
$query = "select * from Test;";
$result = $mysqli->query($query);
$array = mysqli_fetch_array($result);
echo json_encode($array);