mysql20250313.php

<?php
session_start ();

include ("/home/david/MySQLTEST.php");

$db = new PDO ("mysql: host=localhost", $db_user, $db_password);

$mysql = "CREATE DATABASE mysql20250313" . session_id () . "; ";
$db->query ($mysql);
try {
    $mysql = "USE mysql20250313" . session_id () . "; ";
    $db->query ($mysql);

    $mysql = "CREATE TABLE X (x1 INTEGER, x2 INTEGER); CREATE TABLE Y (y1 INTEGER, y2 INTEGER); ";
    $db->query ($mysql);

    $mysql  =    "INSERT INTO X (x1, x2) VALUES (0, 0); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (0, 1); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (1, 0); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (1, 1); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (1, 2); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (2, 1); " ;
    $mysql .=    "INSERT INTO Y (y1, y2) VALUES (0, 0); " ;
    $mysql .=    "INSERT INTO Y (y1, y2) VALUES (1, 0); " ;
    $mysql .=    "INSERT INTO Y (y1, y2) VALUES (2, 1); " ;
    $mysql .=    "INSERT INTO X (x1, x2) VALUES (2, 3); " ;

    $db->query ($mysql);

    $mysql = "SELECT x1, x2 FROM X; ";
    $stmt = $db->query ($mysql);
    while ($row = $stmt->fetch ())
        echo $row [0] . ", " . $row [1] . "<br>\n";
    echo "<br>\n";

    $mysql = "SELECT y1, y2 FROM Y; ";
    $stmt = $db->query ($mysql);
    while ($row = $stmt->fetch ())
        echo $row [0] . ", " . $row [1] . "<br>\n";
    echo "<br>\n";

    $mysql = "SELECT x1, x2, y1, y2 FROM X INNER JOIN Y WHERE X.x1 = Y.y1; ";
    $stmt = $db->query ($mysql);
    while ($row = $stmt->fetch ())
        echo $row [0] . ", " . $row [1] . "<br>\n";
    echo "<br>\n";

    $mysql = "DROP DATABASE mysql20250313" . session_id () . "; ";
    $db->query ($mysql);
}
catch (Exception $e) {
    $mysql = "DROP DATABASE mysql20250313" . session_id () . "; ";
    $db->query ($mysql);
}

session_destroy ();
?>