Next: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/o0001.txt Up: vhdl - ttl - Previous: /media/sda-magnetic/david/Dokumente-14/learn/auswendig/catout5.txt
<!DOCTYPE html>
<html>
<head>
<title> </title>
</head>
<body>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<base href="http://127.0.0.1/sql-exrs/html/">
<link rel="stylesheet" href="styles.css" type="text/css">
<meta name="description" content="This is exercise">
<style>
body {
background-color: lightblue;
}
</style>
<title>Hallo</title>
</head>
<body>
<article>
<h1>This will be document 1</h1>
<section>
<header>
<h2> This is part of document 1</h2>
</header>
Hallo, bla, bla
<ul>
<li> Jetzt 1 </li>
<li> Jetzt 2 </li>
<li> Jetzt 3 </li>
<li> Aussserdem: ol, nav, section, menu </li>
</ul>
<footer>
This is footed
</footer>
</section>
<section>
<header>
<h2> This is part of document 1</h2>
</header>
Hallo, auch bla, bla
<footer>
<address>
Herr Uebungsmann, Platz der Uebung 1
</address>
</footer>
</section>
<arcticle>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title> </title>
</head>
<body>
</body>
</html>
section {
color: white;
background-color: yellow;
width: 80%;
padding-left: 5%;
margin-left: 5%;
border-left-color: black;
border-left-width: 30px;
border-style: solid;
}
address {
color: green;
background-color: white;
width: 80%;
padding-left: 10%;
margin-left: 10%;
border-left-color: green;
}
<!DOCTYPE html>
<html>
<head>
<title>Hallo </title>
<base href="http://127.0.0.1/sql-exrs/html/">
<link rel="stylesheet" href="0004.css" type="text/css">
<meta name="description" content="Dies ist ein Test">
<style>
body {
background-color: deepskyblue;
}
</style>
</head>
<body>
<main>
<section>
<head>
</head>
<h1> Hallo </h1>
<footer>
</footer>
</section>
<section>
<head>
</head>
<h1>Hallo 2</h1>
<ol>
<li>Hallo</li>
<li>Hallo/<li>
<li>Hallo</li>
</ol>
<ul>
<li>Hallo</li>
<li>Hallo</li>
</ul>
<nav>
<ol>
<li><a href="https://www.ituenix.de">https://www.ituenix.de</a></li>
<li><a href="https://www.ituenix.de">https://www.ituenix.de</a></li>
</ol>
</nav>
<menu>
<li>Hallo</li>
<li>Hallo</li>
</menu>
<article>
Hallo dies ist ein Text
</article>
<footer>
</footer>
</section>
<footer>
<address>David Vajda, Schi... 5</address>
</footer>
</main>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title> </title>
</head>
<body>
</body>
</html>
article {
width: 90%;
margin: 5%;
background-color: white;
}
header {
width: 80%;
margin: 10%;
border-left-color: blue;
border-left-width: 20px;
border-style: solid;
background-color: White;
}
section {
width: 80%;
margin: 5%;
padding: 5%;
border-left-color: red;
border-left-width: 40px;
border-left-style: solid;
background-color: yellow;
}
POST /sql-exrs/form0001.php HTTP/1.1
host: localhost
Cookie: Cookie0001a=Cookie0001a
Content-Length: 5
Content-Type: application/x-www-form-urlencoded
t1=t1
POST /sql-exrs/form0007.php HTTP/1.1
host: localhost
Cookie: Cookie7a=Cookie7a
Content-Length: 5
Content-Type: application/x-www-form-urlencoded
t7=t7
POST /sql-exrs/form0008.php HTTP/1.1
host: localhost
Cookie: Cookie08a=Cookie08
Content-Length: 11
Content-Type: application/x-www-form-urlencoded
txt08=Hallo
POST http://127.0.0.1/sql-exrs/form0009.php HTTP/1.1
host: localhost
Cookie: Cookie0009a=DIES IST COOKIE 0009a
Content-Length: 9
Content-Type: application/x-www-form-urlencoded
t09=Hallo
david@www3:/var/www/html/sql-exrs$ php test0001.php
0 0<br>
0 1<br>
1 0<br>
1 1<br>
<br>
0 0<br>
0 1<br>
<br>
0 0 0 0<br>
0 0 0 1<br>
0 1 0 0<br>
0 1 0 1<br>
<br>
david@www3:/var/www/html/sql-exrs$ php test0001.php
david@www3:/var/www/html/sql-exrs$ telnet localhost 80
Trying ::1...
Connected to localhost.
Escape character is '^]'.
POST /sql-exrs/form0001.php HTTP/1.1
host: localhost
Cookie: Cookie0001a=Cookie0001a
Content-Length: 5
Content-Type: application/x-www-form-urlencoded
t1=t1
HTTP/1.1 200 OK
Date: Thu, 14 Jul 2022 09:25:53 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=sduuhm5uo17rk82hl3pn2ci5if; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: Cookie0001=Cookie0001; expires=Thu, 14-Jul-2022 09:45:54 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 182
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form0001.php">
<input type="text" name="t1"></input>
<input type="submit"></input>
</form>
sduuhm5uo17rk82hl3pn2ci5if<br>
<br>
Cookie0001a<br>
t1<br>
Connection closed by foreign host.
david@www3:/var/www/html/sql-exrs$
11<br>
53<br>
27<br>
39<br>
86<br>
103<br>
114<br>
99<br>
110<br>
4<br>
90<br>
116<br>
66<br>
120<br>
96<br>
7<br>
22<br>
20<br>
21<br>
3<br>
70<br>
42<br>
14<br>
15<br>
18<br>
32<br>
24<br>
13<br>
37<br>
8<br>
31<br>
29<br>
25<br>
60<br>
44<br>
49<br>
61<br>
1<br>
5<br>
33<br>
55<br>
<br>
11<br>
53<br>
27<br>
39<br>
86<br>
103<br>
114<br>
99<br>
110<br>
4<br>
90<br>
116<br>
66<br>
120<br>
96<br>
7<br>
22<br>
20<br>
21<br>
3<br>
70<br>
10<br>
16<br>
5<br>
9<br>
23<br>
18<br>
25<br>
31<br>
8<br>
19<br>
14<br>
30<br>
<br>
42<br>
14<br>
15<br>
18<br>
32<br>
24<br>
13<br>
37<br>
7<br>
3<br>
39<br>
8<br>
31<br>
29<br>
25<br>
60<br>
44<br>
49<br>
61<br>
1<br>
27<br>
5<br>
33<br>
55<br>
10<br>
20<br>
21<br>
11<br>
16<br>
9<br>
23<br>
19<br>
4<br>
30<br>
<br>
27<br>
39<br>
7<br>
3<br>
<br>
11<br>
27<br>
4<br>
20<br>
21<br>
<br>
14<br>
18<br>
8<br>
31<br>
25<br>
27<br>
5<br>
<br>
4<br>
5<br>
8<br>
11<br>
14<br>
18<br>
20<br>
21<br>
25<br>
27<br>
31<br>
<br>
4<br>
5<br>
8<br>
11<br>
14<br>
18<br>
20<br>
21<br>
25<br>
27<br>
31<br>
<br>
3<br>
5<br>
7<br>
8<br>
14<br>
18<br>
25<br>
27<br>
31<br>
39<br>
<br>
3<br>
5<br>
7<br>
8<br>
14<br>
18<br>
25<br>
27<br>
31<br>
39<br>
<br>
0 0<br>
0 1<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<br>
0 1<br>
1 1<br>
3 8<br>
<br><br>
0 0<br>
0 1<br>
1 1<br>
3 8<br>
<br><br>
david@www3:/var/www/html/sql-exrs$ telnet 127.0.0.1 80
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
POST /sql-exrs/form0007.php HTTP/1.1
host: localhost
Cookie: Cookie7a=Cookie7a
Content-Length: 5
Content-Type: application/x-www-form-urlencoded
t7=t7
HTTP/1.1 200 OK
Date: Tue, 19 Jul 2022 10:26:47 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=9ic8qp7mg1l1qd2ekk5a26nm53; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: Cookie7=Cookie7; expires=Tue, 19-Jul-2022 10:46:49 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 179
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form0007.php">
<input type="text" name="t7"></input>
<input type="submit"></input>
</form>
9ic8qp7mg1l1qd2ekk5a26nm53<br>
t7<br>
<br>
Cookie7a<br>
Connection closed by foreign host.
david@www3:/var/www/html/sql-exrs$
15<br>
25<br>
4<br>
1<br>
8<br>
0<br>
14<br>
23<br>
10<br>
30<br>
20<br>
24<br>
28<br>
31<br>
60<br>
59<br>
51<br>
11<br>
2<br>
38<br>
41<br>
17<br>
18<br>
<br><br>
15<br>
25<br>
4<br>
1<br>
8<br>
0<br>
14<br>
23<br>
10<br>
30<br>
20<br>
24<br>
28<br>
31<br>
105<br>
17<br>
124<br>
47<br>
50<br>
86<br>
13<br>
119<br>
100<br>
2<br>
40<br>
69<br>
27<br>
52<br>
<br><br>
28<br>
60<br>
59<br>
51<br>
11<br>
10<br>
25<br>
2<br>
38<br>
8<br>
41<br>
31<br>
17<br>
18<br>
15<br>
105<br>
124<br>
47<br>
50<br>
86<br>
13<br>
119<br>
100<br>
40<br>
69<br>
27<br>
52<br>
<br><br>
15<br>
25<br>
8<br>
10<br>
28<br>
31<br>
<br><br>
15<br>
8<br>
<br><br>
2<br>
8<br>
17<br>
15<br>
<br><br>
2<br>
8<br>
15<br>
17<br>
<br><br>
2<br>
8<br>
15<br>
17<br>
<br><br>
2<br>
8<br>
10<br>
15<br>
17<br>
25<br>
28<br>
31<br>
<br><br>
2<br>
8<br>
10<br>
15<br>
17<br>
25<br>
28<br>
31<br>
<br><br>
8<br>
10<br>
15<br>
25<br>
28<br>
31<br>
<br><br>
8<br>
10<br>
15<br>
25<br>
28<br>
31<br>
<br><br>
0 0<br>
0 1<br>
1 0<br>
3 8<br>
8 3<br>
<br>
0 1<br>
3 8<br>
8 3<br>
<br>
0 0 0 1<br>
0 1 0 1<br>
3 8 3 8<br>
8 3 8 3<br>
<br>
david@www3:/var/www/html/sql-exrs$ telnet localhost 80
Trying ::1...
Connected to localhost.
Escape character is '^]'.
POST /sql-exrs/form0008.php HTTP/1.1
host: localhost
Cookie: Cookie08a=Cookie08
Content-Length: 11
Content-Type: application/x-www-form-urlencoded
txt08=Hallo
HTTP/1.1 200 OK
Date: Wed, 27 Jul 2022 07:54:25 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=cet7s23u42d6p0brffcoca63pu; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: Cookie08=Cookie08; expires=Wed, 27-Jul-2022 08:14:25 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 185
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form0008.php">
<input type="text" name="txt08"></input>
<input type="submit"></input>
</form>
cet7s23u42d6p0brffcoca63pu<br>
<br>
Cookie08<br>
Hallo<br>
Connection closed by foreign host.
david@www3:/var/www/html/sql-exrs$
0 0<br>
0 1<br>
1 0<br>
3 8<br>
8 3<br>
<br>
0 1<br>
1 0<br>
3 8<br>
<br>
0 0 0 1<br>
0 1 0 1<br>
1 0 1 0<br>
3 8 3 8<br>
<br>
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sat, 30 Jul 2022 16:30:51 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=t9tfetv6r166vqntco3uc2l27v; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: Cookie0009=Cookie0009; expires=Sat, 30-Jul-2022 17:30:51 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 196
Content-Type: text/html; charset=UTF-8
<form action="./form0009.php" method="POST">
<input type="text" name="t09"></input>
<input type="submit"></input>
</form>
t9tfetv6r166vqntco3uc2l27v<br>
<br>
DIES IST COOKIE 0009a<br>
Hallo<br>
26<br>
19<br>
31<br>
2<br>
3<br>
5<br>
23<br>
9<br>
0<br>
11<br>
17<br>
29<br>
7<br>
13<br>
20<br>
10<br>
15<br>
14<br>
6<br>
45<br>
57<br>
32<br>
35<br>
55<br>
47<br>
38<br>
27<br>
37<br>
42<br>
41<br>
50<br>
59<br>
4<br>
<br><br>
26<br>
19<br>
17<br>
7<br>
10<br>
6<br>
<br><br>
26<br>
19<br>
31<br>
2<br>
3<br>
5<br>
23<br>
9<br>
0<br>
11<br>
17<br>
29<br>
7<br>
13<br>
20<br>
10<br>
15<br>
14<br>
6<br>
74<br>
52<br>
41<br>
1<br>
101<br>
27<br>
124<br>
118<br>
24<br>
58<br>
84<br>
99<br>
60<br>
44<br>
96<br>
76<br>
120<br>
18<br>
91<br>
98<br>
117<br>
<br><br>
31<br>
7<br>
<br><br>
45<br>
57<br>
17<br>
26<br>
32<br>
6<br>
35<br>
55<br>
47<br>
38<br>
19<br>
27<br>
37<br>
10<br>
42<br>
41<br>
50<br>
59<br>
4<br>
7<br>
31<br>
74<br>
52<br>
1<br>
101<br>
124<br>
118<br>
24<br>
58<br>
84<br>
99<br>
60<br>
44<br>
96<br>
76<br>
120<br>
18<br>
91<br>
98<br>
117<br>
<br><br>
27<br>
41<br>
7<br>
<br><br>
7<br>
27<br>
31<br>
41<br>
<br><br>
7<br>
27<br>
31<br>
41<br>
<br><br>
6<br>
7<br>
10<br>
17<br>
19<br>
26<br>
27<br>
41<br>
<br><br>
6<br>
7<br>
10<br>
17<br>
19<br>
26<br>
27<br>
41<br>
<br><br>
6<br>
7<br>
10<br>
17<br>
19<br>
26<br>
31<br>
<br><br>
7<br>
27<br>
31<br>
41<br>
<br><br>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE quantity0001";
$db->query ($sql);
$sql = "USE quantity0001";
$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 () % 128 . ");";
$sql = $sql . "INSERT INTO b VALUES (" . rand () % 64 .");";
$sql = $sql . "INSERT INTO c VALUES (" . rand () % 32 . ")";
$db->query ($sql);
}
/*
a OR b
a OR c
b OR c
*/
$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>\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>\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>\n";
/*
a AND b
a AND c
b AND c
*/
$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>\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>\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>\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>\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>\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>\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>\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";
$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";
$db = null;
?>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE quantity0007";
$db->query ($sql);
$sql = "USE quantity0007";
$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 . ");
INSERT INTO b VALUES (" . rand () % 64 . ");
INSERT INTO c VALUES (" . rand () % 128 . ");";
$db->query ($sql);
}
// 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 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) 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 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 quantity0008";
$db->query ($sql);
$sql = "USE quantity0008";
$db->query ($sql);
$sql = "CREATE TABE a (x INTEGER); CREATE TABLE b (x INTEGER); CREATE TABLE c (x INTEGER)";
$db->query ($sql);
for ($i = 0; $i < 32; $i++) {
$sql = "INSERT INTO a VALUES (" . rand () % 32 . "); INSERT INTO b VALUES (" . rand () % 64 . "); INSERT INTO c VALUES (" . rand () % 128 . ")";
$db->query ($sql);
}
// 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 [0] . "<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 [0] . "<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 [0] . "<br>\n";
echo "<br><br>\n\n";
// 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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 [0] . "<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 q9a";
$db->query ($sql);
$sql = "USE q9a";
$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 . "); 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 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 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 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 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 c) x
UNION
SELECT x FROM (SELECT x FROM a 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";
$db = null;
?>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql:host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE test0001";
$db->query ($sql);
$sql = "USE test0001";
$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)";
$db->query ($sql);
$sql = "INSERT INTO b (y1, y2) VALUES (0, 0); INSERT INTO b (y1, y2) VALUES (0, 1)";
$db->query ($sql);
$sql = "SELECT * FROM a";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["x1"] . " " . $row ["x2"] . "<br>\n";
echo "<br>\n";
$sql = "SELECT * FROM b";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["y1"] . " " . $row ["y2"] . "<br>\n";
echo "<br>\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>\n";
$db = null;
?>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "DROP DATABASE test0007";
$db->query ($sql);
$sql = "CREATE DATABASE test0007";
$db->query ($sql);
$sql = "USE test0007";
$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, 1);
INSERT INTO a (x1, x2) VALUES (3, 8);
INSERT INTO a (x1, x2) VALUES (8, 3)";
$db->query ($sql);
$sql = "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 * 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 x1, x2 FROM a INNER JOIN b ON a.x1 = b.y1";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["x1"] . " " . $row ["x2"] . "<br>\n";
echo "<br><br>\n\n";
$sql = "SELECT x1, x2 FROM a RIGHT JOIN b ON a.x1 = b.y1";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["x1"] . " " . $row ["x2"] . "<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 test0008";
$db->query ($sql);
$sql = "CREATE DATABASE test0008";
$db->query ($sql);
$sql = "USE test0008";
$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 (x1, x2) VALUES (0, 1); INSERT INTO a (x1, x2) VALUES (1, 0); INSERT INTO a (x1, x2) VALUES (3, 8); INSERT INTO a VALUES (8, 3); INSERT INTO b (y1, y2) VALUES (0, 1); INSERT INTO b (y1, y2) VALUES (3, 8); INSERT INTO b (y1, y2) VALUES (8, 3)";
$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>\n";
$sql = "SELECT * FROM b";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " " . $row [1] . "<br>\n";
echo "<br>\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>\n";
$db = null;
?>
<?php
include ('/home/david/db_settings.php');
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE test0009";
$db->query ($sql);
$sql = "USE test0009";
$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 (x1, x2) VALUES (0, 1); INSERT INTO a (x1, x2) VALUES (1, 0); 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 x1, x2 FROM a";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row ["x1"] . " " . $row ["x2"] . "<br>\n";
echo "<br>\n";
$sql = "SELECT * FROM b";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " " . $row [1] . "<br>\n";
echo "<br>\n";
$sql = "SELECT * FROM a INNER JOIN b ON a.x1 = b.y1";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
echo $row [0] . " " . $row [1] . " " . $row [2] . " " . $row [3] . "<br>\n";
echo "<br>\n";
$db = null;
?>