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
$pdo->exec("
CREATE TABLE cities (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
name TEXT
);
");
$pdo->exec("INSERT INTO cities (name) VALUES ('那覇市'), ('浦添市'), ('宜野湾市');");
foreach ($pdo->query("SELECT * FROM cities") as $row) {
echo $row['id'] . ': ' . $row['name'] . "\n";
}
$db