/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/newC2023-10-23/c2023-10-23/php-sql-bash-exercise/2023-07-21-php-sql/test.php

<?php
include ("/home/david/db_settings.php");

$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);

$sql = "CREATE DATABASE q0004" . ($rnd = rand () % 1024);
$db->query ($sql);

$sql = "USE q0004". $rnd;
$db->query ($sql);

$sql = "CREATE TABLE a (x1 INTEGER, x2 INTEGER); CREATE TABLE b (y1 INTEGER, y2 INTEGER)";
$db->query ($sql);

$sql = "INSERT INTO a (x1, x2) VALUES (2, 2); INSERT INTO a (x1, x2) VALUES (2, 3); INSERT INTO a (x1, x2) VALUES (3, 2); INSERT INTO a (x1, x2) VALUES (3, 3); INSERT INTO a (x1, x2) VALUES (4, 7); INSERT INTO b (y1, y2) VALUES (2, 2); INSERT INTO b (y1, y2) VALUES (3, 3); INSERT INTO b (y1, y2) VALUES (4, 7)";
$db->query ($sql);

$sql = "SELECT * FROM a";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " " . $row [1] . "<br>\n";
echo "<br><br>\n\n";

$sql = "SELECT * FROM b";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " " . $row [1] . "<br>\n";
echo "<br><br>\n\n";

$sql = "SELECT * FROM a ";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " " . $row [1] . " " . $row [2] . " " . $row [3] . "<br><br>\n\n";
echo "<br><br>\n\n"; 



$db = null;
?>