Next: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/catout3.txt Up: vhdl - ttl - Previous: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/auswendig0006.txt
<?php
session_start ();
?>
<form method="POST" action="./form0010.php">
<input type="text" name="txt10"></input>
<input type="submit"></input>
</form>
<?php
echo session_id () . "<br>\n";
setcookie ("COOKIE0010", "Hallo, dies ist Cookie 10", time () + 3600);
echo htmlentities ($_COOKIE ["COOKIE0010"]) . "<br>\n";
echo htmlentities ($_COOKIE ["COOKIE0010a"]) . "<br>\n";
echo htmlentities ($_POST ["txt10"]) . "<br>\n";
session_destroy ();
?>
POST http://127.0.0.1/sql-exrs/0010/form0010.php HTTP/1.1
host: localhost
Cookie: COOKIE0010a=Hallo dies ist das Zweite Cookie von 0010
Content-Length: 29
Content-Type: application/x-www-form-urlencoded
txt10=Hallo, dies ist Text 10
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 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sun, 31 Jul 2022 09:56:06 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=s3b4vs1247tifjfta6e5dhn8ek; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: COOKIE0010=Hallo%2C+dies+ist+Cookie+10; expires=Sun, 31-Jul-2022 10:56:06 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 236
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form0010.php">
<input type="text" name="txt10"></input>
<input type="submit"></input>
</form>
s3b4vs1247tifjfta6e5dhn8ek<br>
<br>
Hallo dies ist das Zweite Cookie von 0010<br>
Hallo, dies ist Text 10<br>
14<br>
20<br>
2<br>
23<br>
29<br>
25<br>
18<br>
1<br>
15<br>
3<br>
10<br>
16<br>
7<br>
11<br>
17<br>
24<br>
13<br>
9<br>
28<br>
30<br>
53<br>
8<br>
43<br>
44<br>
37<br>
61<br>
54<br>
38<br>
46<br>
31<br>
21<br>
0<br>
52<br>
51<br>
12<br>
6<br>
19<br>
47<br>
63<br>
50<br>
45<br>
<br><br>
14<br>
20<br>
2<br>
23<br>
29<br>
25<br>
18<br>
1<br>
15<br>
3<br>
10<br>
16<br>
7<br>
11<br>
17<br>
24<br>
13<br>
9<br>
28<br>
30<br>
99<br>
31<br>
44<br>
35<br>
60<br>
106<br>
12<br>
72<br>
81<br>
117<br>
58<br>
78<br>
119<br>
54<br>
37<br>
65<br>
55<br>
71<br>
92<br>
51<br>
59<br>
48<br>
<br><br>
53<br>
8<br>
17<br>
43<br>
25<br>
44<br>
37<br>
61<br>
54<br>
38<br>
30<br>
46<br>
31<br>
21<br>
0<br>
52<br>
28<br>
51<br>
12<br>
6<br>
14<br>
2<br>
19<br>
9<br>
47<br>
63<br>
29<br>
1<br>
50<br>
45<br>
7<br>
99<br>
35<br>
60<br>
106<br>
23<br>
72<br>
81<br>
117<br>
58<br>
10<br>
78<br>
119<br>
65<br>
55<br>
71<br>
92<br>
59<br>
48<br>
<br><br>
14<br>
2<br>
29<br>
25<br>
1<br>
17<br>
9<br>
28<br>
30<br>
<br><br>
23<br>
29<br>
25<br>
10<br>
7<br>
9<br>
28<br>
30<br>
<br><br>
25<br>
44<br>
37<br>
54<br>
30<br>
31<br>
28<br>
51<br>
12<br>
9<br>
29<br>
<br><br>
7<br>
9<br>
10<br>
12<br>
23<br>
25<br>
28<br>
29<br>
30<br>
31<br>
37<br>
44<br>
51<br>
54<br>
<br><br>
7<br>
9<br>
10<br>
12<br>
23<br>
25<br>
28<br>
29<br>
30<br>
31<br>
37<br>
44<br>
51<br>
54<br>
<br><br>
1<br>
2<br>
9<br>
12<br>
14<br>
17<br>
25<br>
28<br>
29<br>
30<br>
31<br>
37<br>
44<br>
51<br>
54<br>
<br><br>
1<br>
2<br>
9<br>
12<br>
14<br>
17<br>
25<br>
28<br>
29<br>
30<br>
31<br>
37<br>
44<br>
51<br>
54<br>
<br><br>
1<br>
2<br>
7<br>
9<br>
10<br>
14<br>
17<br>
23<br>
25<br>
28<br>
29<br>
30<br>
<br><br>
1<br>
2<br>
7<br>
9<br>
10<br>
14<br>
17<br>
23<br>
25<br>
28<br>
29<br>
30<br>
<br><br>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE quantity0010";
$db->query ($sql);
$sql = "USE quantity0010";
$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 < 36; $i++) {
$sql = "INSERT INTO a VALUES (" . rand () % 32 . "); INSERT INTO b VALUES (" . rand () % 64 . "); INSERT INTO c 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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
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 ["x"] . "<br>\n";
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 ["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";
$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";
$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 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 ["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 test0010";
$db->query ($sql);
$sql = "USE test0010";
$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 (8, 3); INSERT INTO b (y1, y2) VALUES (0, 1); INSERT INTO b (y1, y2) VALUES (1, 0); INSERT INTO b (y1, y2) VALUES (3, 8)";
$db->query ($sql);
$sql = "SELECT x1, x2 FROM a";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["x1"] . " " . $row ["x2"] . "<br>\n";
echo "<br><br>\n\n";
$sql = "SELECT y1, y2 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;
?>