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

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


<?php 
session_start ();
?>

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

<?php 
setcookie ("Cookie13", "Cookie13", time () + 1200);

echo htmlentities ($_COOKIE ["Cookie13"]) . "<br>\n";
echo htmlentities ($_COOKIE ["Cookie13a"]) . "<br>\n";
echo htmlentities ($_POST ["t13"]) . "<br>\n";

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

session_destroy ();
?>
POST http://127.0.0.1/sql-exrs/0013/form0013.php HTTP/1.1
host: localhost
Cookie: Cookie13a=13
Content-Type: application/x-www-form-urlencoded
Content-Length: 6

t13=13
0 0<br>
0 1<br>
1 0<br>
1 1<br>
3 8<br>
9 4<br>
<br><br>

0 1<br>
1 0<br>
9 4<br>
<br><br>

0 0 0 1<br>
0 1 0 1<br>
1 0 1 0<br>
1 1 1 0<br>
9 4 9 4<br>
<br><br>

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sat, 13 Aug 2022 10:44:24 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=k0ai46oddm17re61c16r752frt; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: Cookie13=Cookie13; expires=Sat, 13-Aug-2022 11:04:24 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 174
Content-Type: text/html; charset=UTF-8


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

<br>
13<br>
13<br>
k0ai46oddm17re61c16r752frt<br>
15<br>
17<br>
22<br>
23<br>
16<br>
2<br>
<br><br>

22<br>
28<br>
4<br>
<br><br>

24<br>
22<br>
8<br>
<br><br>

1<br>
15<br>
17<br>
22<br>
30<br>
27<br>
23<br>
28<br>
0<br>
4<br>
7<br>
16<br>
26<br>
20<br>
2<br>
18<br>
34<br>
49<br>
39<br>
45<br>
46<br>
43<br>
24<br>
61<br>
54<br>
56<br>
14<br>
8<br>
41<br>
55<br>
<br><br>

1<br>
15<br>
17<br>
22<br>
30<br>
27<br>
23<br>
28<br>
0<br>
4<br>
7<br>
16<br>
26<br>
20<br>
2<br>
18<br>
33<br>
78<br>
124<br>
38<br>
89<br>
106<br>
51<br>
96<br>
116<br>
72<br>
82<br>
87<br>
103<br>
35<br>
127<br>
85<br>
24<br>
13<br>
8<br>
67<br>
<br><br>

17<br>
34<br>
49<br>
39<br>
45<br>
15<br>
46<br>
43<br>
24<br>
23<br>
61<br>
2<br>
22<br>
16<br>
54<br>
56<br>
14<br>
8<br>
41<br>
55<br>
33<br>
78<br>
4<br>
124<br>
38<br>
89<br>
106<br>
51<br>
96<br>
116<br>
72<br>
82<br>
87<br>
103<br>
28<br>
35<br>
127<br>
85<br>
13<br>
67<br>
<br><br>

4<br>
8<br>
22<br>
24<br>
28<br>
<br><br>

4<br>
8<br>
22<br>
24<br>
28<br>
<br><br>

2<br>
8<br>
15<br>
16<br>
17<br>
22<br>
23<br>
24<br>
<br><br>

2<br>
8<br>
15<br>
16<br>
17<br>
22<br>
23<br>
24<br>
<br><br>

2<br>
4<br>
15<br>
16<br>
17<br>
22<br>
23<br>
28<br>
<br><br>

2<br>
4<br>
8<br>
14<br>
15<br>
16<br>
17<br>
22<br>
23<br>
24<br>
28<br>
34<br>
39<br>
41<br>
43<br>
45<br>
46<br>
49<br>
54<br>
55<br>
56<br>
61<br>
<br><br>

<?php 
include ("/home/david/db_settings.php");
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);


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

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

$sql = "USE q13";
$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 < 24;  $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);
}

// a AND b

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

// a AND c

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

// b AND c

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

// a OR b

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

// a OR c

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

// b OR c

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

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

$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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
echo "<br><br>\n\n";

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

$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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
echo "<br><br>\n\n";

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


$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 ["x"] . "<br>\n";
echo "<br><br>\n\n";
    
$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM b INTERSECT SELECT x FROM b) 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 ["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 = "DROP DATABASE test0013";
$db->query ($sql);

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

$sql = "USE test0013";
$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, x2) 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 (9, 4); INSERT INTO b (y1, y2) VALUES (0, 1); INSERT INTO b (y1, y2) VALUES (1, 0); INSERT INTO b (y1, y2) VALUES (9, 4)";
$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;
?>
<?php 
session_start ();
?>

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

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

setcookie ("Cookie0001", "Cookie0001", time () + 1200);

echo htmlentities ($_COOKIE ["Cookie0001"]) . "<br>\n";
echo htmlentities ($_COOKIE ["Cookie0001a"]) . "<br>\n";
echo htmlentities ($_POST ["t1"]) . "<br>\n";

session_destroy ();
?>
<?php 
session_start ();
?>

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

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

echo htmlentities ($_POST ["t7"]) . "<br>\n";
setcookie ("Cookie7", "Cookie7", time () + 1200);
echo htmlentities ($_COOKIE ["Cookie7"]) . "<br>\n";
echo htmlentities ($_COOKIE ["Cookie7a"]) . "<br>\n";

session_destroy ();
?>
<?php 
session_start ();
?>

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

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

setcookie ("Cookie08", "Cookie08", time () + 1200);

echo htmlentities ($_COOKIE ["Cookie08"]) . "<br>\n";
echo htmlentities ($_COOKIE ["Cookie08a"]) . "<br>\n";
echo htmlentities ($_POST ["txt08"]) . "<br>\n";

session_destroy ();
?>
<?php 
session_start ();
?>

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

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

setcookie ("Cookie0009", "Cookie0009", time () + 3600);

echo htmlentities ($_COOKIE ["Cookie0009"]) . "<br>\n";
echo htmlentities ($_COOKIE ["Cookie0009a"]) . "<br>\n";
echo htmlentities ($_POST ["t09"]) . "<br>\n";

session_destroy ();
?>