/media/sda-magnetic/david/david2/david2/Dokumente/informatik/linux/mysql-2022-09-13/test0002.php

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

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

$sql = "CREATE DATABASE t2v2";
$db->query ($sql);

$sql = "USE t2v2";
$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 (0, 0); INSERT INTO a (x1, x2) VALUES (0, 1); INSERT INTO a (x1, x) VALUES (1, 0); INSERT INTO a (x1, x2) VALUES (1, 1); INSERT INTO a (x1, x2) VALUES (3, 8); INSERT INTO a (x1, x2) VALUES (7, 4); INSERT INTO b (y1, y2) VALUES (0, 1); INSERT INTO b (y1, y2) VALUES (1, 0); INSERT INTO b (y1, y2) VALUES (3, 8)";
$db->query ($sql);

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


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


$sql = "SELECT * FROM a INNER JOIN b ON a.x1 = b.y1";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row ["x1"] . " " . $row ["x2"] . " " . $row ["y1"] . " " . $row ["y2"] . "<br>\n\n";
echo "<br><br>\n\n";

$db = null;
?>