/media/sda-magnetic/david/Dokumente-15-2023-11-22/informatik/newC2023-10-23/c2023-10-23/php-sql-bash-exercise/2023-08-15/quantity.php

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

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

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

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

for ($i = 0;  $i < 32;  $i++) {
    $sql = "INSERT INTO a (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO b (x) VALUES (" . rand () % 64 . "); ";
    $sql .= "INSERT INTO c (x) VALUES (" . rand () % 128 . "); ";
    $db->query ($sql);
}

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

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


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

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

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

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b) x
                INTERSECT 
            SELECT x FROM c
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";
    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x
                UNION 
            SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c) x
                INTERSECT 
            SELECT x FROM b
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";
    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x
                UNION 
            SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM b) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";

    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x
                INTERSECT 
            SELECT x FROM a
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";
    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM a) x
                UNION 
            SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM a) x
    ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";

$db = null;
?>