/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/032/quantitysql.php

<?php 
include ('/home/david/mysqldata.php');

$handle = mysql_connect ("127.0.0.1", $MYSQL_NAME, $MYSQL_PASSWORD);

mysql_query ("CREATE DATABASE quantity004", $handle);
mysql_select_db ("quantity004", $handle);

mysql_query ("CREATE TABLE a (x VARCHAR (4))", $handle);
mysql_query ("CREATE TABLE b (x VARCHAR (4))", $handle);
mysql_query ("CREATE TABLE c (x VARCHAR (4))", $handle);

for ($i = 0;  $i < 20;  $i++) {
    mysql_query ("INSERT INTO a VALUES (\"" . rand () % 64 . "\")", $handle);
    mysql_query ("INSERT INTO b VALUES (\"" . rand () % 64 . "\")", $handle);
    mysql_query ("INSERT INTO c VALUES (\"" . rand () % 64 . "\")", $handle);
}

/* 
a AND b
a AND c
b AND c
a OR b
a OR c
b OR c
(a OR b) AND c = A AND c OR b AND c
(a OR c) AND b = A AND b OR c AND b
(b OR c) AND a = b AND a OR c AND a
*/

/* 
a AND b
a AND c
b AND c

SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b)x ORDER BY x
SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c)x ORDER BY x
SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c)x ORDER BY x
*/


$result = mysql_query("SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";
$result = mysql_query("SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";
$result = mysql_query("SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";


/*
a OR b
a OR c
b OR c

SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)x ORDER BY x
SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)x ORDER BY x
SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c)x ORDER BY x
*/

$result = mysql_query("SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";
$result = mysql_query("SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";
$result = mysql_query("SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c)x ORDER BY x", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";

/*(a OR b) AND c = A AND c OR b AND c

SELECT x FROM (
    SELECT x FROM (SELECT x FROM a UNION SELECT x FROM b)
    INTERSECT 
    SELECT x FROM c
)x ORDER BY x;

SELEC x FROM (
    SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c)
    UNION 
    SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c)
)x ORDER BY x;
*/

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";


/*(a OR c) AND b = A AND b OR c AND b
SELECT x FROM (
    SELECT x FROM (SELECT x FROM a UNION SELECT x FROM c)
    INTERSECT
    SELECT x FROM b
)x ORDER BY x;

SELECT x FROM (
    SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b)
    UNION 
    SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM b)
)x ORDER BY x;
*/

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";


/*(b OR c) AND a = b AND a OR c AND a
SELECT x FROM (
    SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c)
    INTERSECT
    SELECT x FROM a
)x ORDER BY x;

SELECT x FROM (
    SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM a)
    UNION 
    SELECT x FROM (SELECT x FROM c INTERSECT SELECT x FROM a)
)x ORDER BY x;
*/

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";

$result = mysql_query("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", $handle);
while ($row = mysql_fetch_assoc ($result))
    echo $row ["x"] . "<br>\n";
    
mysql_close ($handle);


?>