next up previous
Nächste Seite: Re: Die üblichen Übungen Aufwärts: Graphen, Schaltwerke und Zahlen Vorherige Seite: Re: MySQL, Bash

Die üblichen Übungen

Ich mache jetzt jeden Tag, die üblichen Übunngen 

VHDL
MySQL
Bash
HTTP-Requests


<?php
session_start ();
?>

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

<?php
echo "Session-ID: " . session_id () . "<br>n";
setcookie ("2024021802", "Hallo Welt", time () + 3600);
echo "Cookie-1: " . \$_COOKIE ["2024021802"] . "<br>n";
echo "Cookie-2: " . \$_COOKIE ["2024021803"] . "<br>n";
echo "Input-1: " . \$_POST ["2024021801"] . "<br>n";


session_destroy ();
?>


POST http://localhost/mysql20240217/20240218/form20240218.php HTTP/1.1
host: localhost
Cookie: 2024021803=Hallo Super
Content-Type: application/x-www-form-urlencoded
Content-Length: 22

2024021801=Super Sache


Trying ::1...
Connected to localhost.
Escape character is '\^]'.
HTTP/1.1 200 OK
Date: Sun, 18 Feb 2024 05:41:45 GMT
Server: Apache/2.4.57 (Debian)
Set-Cookie: PHPSESSID=92rt9li9bt4isc4f5p1lb552dk; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: 2024021802=Hallo%20Welt; expires=Sun, 18 Feb 2024 06:41:45 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 236
Content-Type: text/html; charset=UTF-8


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

Session-ID: 92rt9li9bt4isc4f5p1lb552dk<br>
Cookie-1: <br>
Cookie-2: Hallo Super<br>
Input-1: Super Sache<br>


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

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


\$sql = "CREATE DATABASE x2024021801" . (\$r = rand ()) . ";";
\$db->query (\$sql);


\$sql = "USE x2024021801" . \$r . ";";
\$db->query (\$sql);

\$sql = "CREATE TABLE a (x1 INTEGER, x2 INTEGER);";
\$db->query (\$sql);

\$sql = "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 (2, 7); INSERT INTO b (y1, y2) VALUES (0, 0); INSERT INTO b (y1, y2) VALUES (1, 1); INSERT INTO b (y1, y2) VALUES (2, 7); INSERT INTO b (y1, y2) VALUES (7, 2);";
\$db->query (\$sql);

\$sql = "SELECT * from a;";
\$stmt = \$db->query (\$sql);
while (\$row = \$stmt->fetch ())
    echo \$row [0] . ", " . \$row [1] . "<br>n";

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

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


\$sql = "DROP DATABASE x2024021801" . \$r . ";";
\$db->query (\$sql);
?>


0, 0<br>
0, 1<br>
1, 0<br>
1, 1<br>
2, 7<br>
0, 0<br>
1, 1<br>
2, 7<br>
7, 2<br>
0, 0<br>
0, 1<br>
1, 0<br>
1, 1<br>
2, 7<br>


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

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


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

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

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

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

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

for (\$i = 0;  \$i < 24;  \$i++) {
    \$sql = "INSERT INTO a VALUES (" . rand () % 24 . ");";
    \$sql .= "INSERT INTO b VALUES (" . rand () % 32 . ");";
    \$sql .= "INSERT INTO c VALUES (" . rand () % 64 . "); ";
    \$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>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>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>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>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>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>n";

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


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

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


\$sql = "DROP DATABASE q20240218;";
\$db->query (\$sql);
?>


15, 4, 19, 7, 5, 0, 18, 16, 3, 11, 12, 20, 13, 9, 14, 10, 6, 2, 31, 29, 30, 27, 22, 24, 8, 1, <br>
15, 4, 19, 7, 5, 0, 18, 16, 3, 11, 12, 20, 13, 9, 14, 10, 44, 1, 58, 49, 36, 35, 29, 24, 32, 63, 46, 61, 56, 8, 52, 23, 45, <br>
6, 15, 2, 31, 12, 16, 29, 30, 14, 9, 5, 27, 22, 24, 8, 0, 1, 44, 58, 49, 36, 35, 10, 32, 4, 63, 46, 61, 56, 7, 52, 23, 45, <br>
15, 5, 0, 16, 12, 9, 14, <br>
15, 4, 7, 5, 9, 14, 10, <br>
15, 29, 14, 9, 5, 24, 8, 1, <br>
15, 4, 7, 5, 9, 14, 10, 29, 24, 8, 1, <br>
15, 4, 7, 5, 9, 14, 10, 29, 24, 8, 1, <br>
15, 5, 0, 16, 12, 9, 14, 1, 29, 24, 8, <br>
15, 5, 0, 16, 12, 9, 14, 1, 29, 24, 8, <br>
15, 29, 14, 9, 5, 24, 8, 1, 44, 58, 49, 36, 35, 10, 32, 4, 63, 46, 61, 56, 7, 52, 23, 45, <br>
15, 12, 16, 14, 9, 5, 0, 10, 4, 7, <br>


23, 9, 19, 2, 13, 6, 12, 18, 3, 5, 15, 11, 17, 8, 22, 1, 27, 14, 0, 4, 20, 25, 29, 7, 28, <br>
23, 9, 19, 2, 13, 6, 12, 18, 3, 5, 15, 11, 17, 8, 29, 41, 27, 26, 28, 21, 49, 25, 59, 51, 22, 57, 14, 7, 56, <br>
17, 22, 1, 6, 9, 27, 14, 0, 4, 12, 3, 20, 8, 25, 29, 7, 19, 15, 18, 28, 41, 26, 21, 49, 59, 51, 13, 57, 56, <br>
9, 19, 6, 12, 18, 3, 15, 17, 8, <br>
13, 15, 17, <br>
17, 22, 27, 14, 25, 29, 7, 15, 28, <br>
13, 15, 17, 22, 27, 14, 25, 29, 7, 28, <br>
13, 15, 17, 22, 27, 14, 25, 29, 7, 28, <br>
9, 19, 6, 12, 18, 3, 15, 17, 8, 29, 27, 28, 25, 22, 14, 7, <br>
9, 19, 6, 12, 18, 3, 15, 17, 8, 29, 27, 28, 25, 22, 14, 7, <br>
17, 22, 27, 14, 25, 29, 7, 15, 28, 41, 26, 21, 49, 59, 51, 13, 57, 56, <br>
17, 6, 9, 12, 3, 8, 19, 15, 18, 13, <br>


11, 22, 4, 6, 9, 17, 2, 14, 21, 16, 13, 7, 23, 18, 10, 19, 5, 15, 3, 8, 25, 20, 29, 31, 12, 0, <br>
11, 22, 4, 6, 9, 17, 2, 14, 21, 16, 13, 7, 23, 18, 10, 19, 5, 15, 3, 55, 56, 59, 37, 33, 20, 50, 48, 57, 32, 53, 39, 0, <br>
8, 21, 2, 25, 4, 20, 18, 22, 29, 17, 31, 5, 15, 9, 10, 12, 0, 6, 55, 56, 59, 37, 33, 50, 48, 19, 57, 32, 53, 39, <br>
22, 4, 9, 17, 2, 21, 18, 10, 5, 15, <br>
4, 6, 9, 17, 10, 19, 5, <br>
4, 20, 17, 5, 9, 10, 0, <br>
4, 6, 9, 17, 10, 19, 5, 20, 0, <br>
4, 6, 9, 17, 10, 19, 5, 20, 0, <br>
22, 4, 9, 17, 2, 21, 18, 10, 5, 15, 20, 0, <br>
22, 4, 9, 17, 2, 21, 18, 10, 5, 15, 20, 0, <br>
4, 20, 17, 5, 9, 10, 0, 6, 55, 56, 59, 37, 33, 50, 48, 19, 57, 32, 53, 39, <br>
21, 2, 4, 18, 22, 17, 5, 15, 9, 10, 6, 19, <br>