next up previous
Next: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/catout4.txt Up: vhdl - ttl - Previous: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/catout2.txt

/media/sda-magnetic/david/Dokumente-14/learn/auswendig/catout3.txt 


<?php 
session_start ();
?>

<form method="POST" action="./form0011.php">
<input type="text" name="t11"></input>
<input type="submit"></input>
</form>

<?php 
echo session_id () . "<br>\n";

setcookie ("COOKIE0011", "Dies ist Cookie0011", time () + 1200);

echo htmlentities ($_COOKIE ["COOKIE0011"]) . "<br>\n";
echo htmlentities ($_COOKIE ["COOKIE0011a"]) . "<br>\n";
echo htmlentities ($_POST ["t11"]) . "<br>\n";

session_destroy ();
?>
POST http://127.0.0.1/sql-exrs/0011/form0011.php HTTP/1.1
host: localhost
Cookie: COOKIE0011a=Hallo dies ist Cookie 11a
Content-Length: 9
Content-Type: application/x-www-form-urlencoded 

t11=Hallo
0 0<br>
0 1<br>
1 0<br>
1 1<br>
3 8<br>
8 3<br>
<br><br>

0 1<br>
1 0<br>
3 8<br>
<br><br>

0 0 0 1<br>
0 1 0 1<br>
1 0 1 0<br>
1 1 1 0<br>
3 8 3 8<br>
<br><br>

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Mon, 01 Aug 2022 12:49:27 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=hf9v0c5m4fn6ruvuobpgj5b61s; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: COOKIE0011=Dies+ist+Cookie0011; expires=Mon, 01-Aug-2022 13:09:27 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 200
Content-Type: text/html; charset=UTF-8


<form method="POST" action="./form0011.php">
<input type="text" name="t11"></input>
<input type="submit"></input>
</form>

hf9v0c5m4fn6ruvuobpgj5b61s<br>
<br>
Hallo dies ist Cookie 11a<br>
Hallo<br>
11<br>
19<br>
10<br>
17<br>
6<br>
13<br>
1<br>
16<br>
30<br>
2<br>
14<br>
15<br>
12<br>
0<br>
7<br>
29<br>
3<br>
9<br>
41<br>
49<br>
61<br>
34<br>
50<br>
52<br>
26<br>
28<br>
59<br>
58<br>
46<br>
<br><br>

11<br>
19<br>
10<br>
17<br>
6<br>
13<br>
1<br>
16<br>
30<br>
2<br>
14<br>
15<br>
12<br>
0<br>
7<br>
29<br>
111<br>
18<br>
98<br>
90<br>
93<br>
55<br>
99<br>
38<br>
115<br>
96<br>
44<br>
52<br>
22<br>
92<br>
100<br>
23<br>
102<br>
<br><br>

3<br>
9<br>
10<br>
41<br>
49<br>
61<br>
34<br>
50<br>
52<br>
7<br>
26<br>
28<br>
59<br>
58<br>
46<br>
14<br>
111<br>
18<br>
98<br>
90<br>
93<br>
55<br>
99<br>
38<br>
115<br>
96<br>
44<br>
22<br>
92<br>
100<br>
23<br>
102<br>
<br><br>

10<br>
14<br>
7<br>
<br><br>

<br><br>

52<br>
<br><br>

<br>
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<br>
52<br>
<br><br>

<br>
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<br>
52<br>
<br><br>

<br>
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<br>
7<br>
10<br>
14<br>
52<br>
<br><br>

<br>
SELECT x FROM (SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x UNION SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM c) x) x ORDER BY x<br>
7<br>
10<br>
14<br>
52<br>
<br><br>

<br>
SELECT x FROM (
                SELECT x FROM (SELECT x FROM b UNION SELECT x FROM c) x INTERSECT 
                SELECT x FROM b
        ) x ORDER BY x<br>
3<br>
7<br>
9<br>
10<br>
14<br>
26<br>
28<br>
34<br>
41<br>
46<br>
49<br>
50<br>
52<br>
58<br>
59<br>
61<br>
<br><br>

<br>
SELECT x FROM (SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM b) x UNION SELECT x FROM (SELECT x FROM a INTERSECT SELECT x FROM c) x) x ORDER BY x<br>
7<br>
10<br>
14<br>
<br><br>

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

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

$sql = "DROP DATABASE q0011";
$db->query ($sql);

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

$sql = "USE q0011";
$db->query ($sql);

$sql = "CREATE TABLE a (x INTEGER); CREATE TABLE b (x INTEGER); CREATE TABLE c (x INTEGER)";
$db->query ($sql);

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

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

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

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

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



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


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


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

        
$sql8 = "SELECT x FROM (".
            $sql5
            . " UNION " . 
            $sql6
        .") x ORDER BY x";
echo "<br>\n". $sql8 . "<br>\n";
$stmt = $db->query ($sql8);
while ($row = $stmt->fetch ())
    echo $row ["x"] . "<br>\n";
echo "<br><br>\n\n";


$sql9 = "SELECT x FROM (
                " . $sql2 . 
            " INTERSECT 
                SELECT x FROM b
        ) x ORDER BY x";
echo "<br>\n". $sql9."<br>\n";
$stmt = $db->query ($sql9);
while ($row = $stmt->fetch ())
    echo $row ["x"] . "<br>\n";
echo "<br><br>\n\n";
        
$sql10 = "SELECT x FROM (".
            $sql4
            . " UNION " . 
            $sql6
        .") x ORDER BY x";
echo "<br>\n". $sql10 . "<br>\n";
$stmt = $db->query ($sql10);
while ($row = $stmt->fetch ())
    echo $row ["x"] . "<br>\n";
echo "<br><br>\n\n";


$sql11 = "SELECT x FROM (
                " . $sql3 . 
            " INTERSECT 
                SELECT x FROM b
        ) x ORDER BY x";
echo "<br>\n". $sql11."<br>\n";
$stmt = $db->query ($sql11);
while ($row = $stmt->fetch ())
    echo $row ["x"] . "<br>\n";
echo "<br><br>\n\n";
        
$sql12 = "SELECT x FROM (".
            $sql4
            . " UNION " . 
            $sql5
        .") x ORDER BY x";
echo "<br>\n". $sql12 . "<br>\n";
$stmt = $db->query ($sql12);
while ($row = $stmt->fetch ())
    echo $row ["x"] . "<br>\n";
echo "<br><br>\n\n";


$db = null;
?>
<?php 
include ('/home/david/db_settings.php');

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

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

$sql = "USE test0011";
$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 VALUES (0, 0); INSERT INTO a VALUES (0, 1); INSERT INTO a VALUES (1, 0); INSERT INTO a VALUES (1, 1); INSERT INTO a VALUES (3, 8); INSERT INTO a VALUES (8, 3); INSERT INTO b VALUES (0, 1); INSERT INTO b VALUES (1, 0); INSERT INTO b 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";
echo "<br><br>\n\n";

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



$db = null;
?>