Stundenplan

Beitrag von **davidvajda** » Di Apr 11, 2023 6:49 pm

<?php
session_start ();
?>

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

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

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

echo htmlentities ($_POST ["p8"]) . "<br>\n";
echo htmlentities ($_COOKIE ["c8"]) . "<br>\n";
echo htmlentities ($_COOKIE ["c8a"]) . "<br>\n";

session_destroy ();
?>

Code: Alles auswählen

POST http://localhost/test/0008/form0008.php HTTP/1.1
host: localhost
Cookie: c8a=Hallo
Content-Length: 8
Content-Type: application/x-www-form-urlencoded

p8=Hallo

Code: Alles auswählen

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Tue, 11 Apr 2023 18:47:39 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=nvscehnn37vnqhlm5n0i98ma0e; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: c8=c8; expires=Tue, 11-Apr-2023 19:47:39 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 175
Content-Type: text/html; charset=UTF-8


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

nvscehnn37vnqhlm5n0i98ma0e<br>
Hallo<br>
<br>
Hallo<br>

Beitrag von **davidvajda** » Di Apr 11, 2023 6:58 pm

Code: Alles auswählen

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

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

$sql = "CREATE DATABASE q0008" . ($rnd = rand ());
$db->query ($sql);

$sql = "USE q0008" . $rnd;
$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 (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO b (x) VALUES (" . rand () % 64 . "); ";
    $sql .= "INSERT INTO c (x) 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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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] . " ";
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 [0] . " ";
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] . " ";
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 [0] . " ";
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] . " ";
echo "<br><br>\n\n";

$db = null;
?>

Code: Alles auswählen

31 24 8 9 13 1 12 22 18 15 19 28 21 27 23 25 5 29 3 16 4 33 7 48 45 59 53 54 39 51 56 37 34 14 61 <br><br>

31 24 8 9 13 1 12 22 18 15 19 28 21 27 23 25 5 29 3 16 4 102 106 30 17 67 127 91 69 90 114 49 110 101 58 35 48 10 80 125 54 45 84 <br><br>

28 1 33 16 7 48 45 59 4 53 54 39 51 22 56 29 37 34 14 61 27 102 106 30 17 67 127 91 69 90 114 21 49 110 101 58 35 10 80 125 84 <br><br>

1 22 28 27 29 16 4 <br><br>

21 <br><br>

48 45 54 <br><br>

21 45 48 54 <br><br>

21 45 48 54 <br><br>

1 4 16 22 27 28 29 45 48 54 <br><br>

1 4 16 22 27 28 29 45 48 54 <br><br>

1 4 16 21 22 27 28 29 <br><br>

1 4 16 21 22 27 28 29 <br><br>

Beitrag von **davidvajda** » Di Apr 18, 2023 6:03 pm

Code: Alles auswählen

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

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

$sql = "CREATE DATABASE test0009" . ($rnd = rand ());
$db->query ($sql);

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

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

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



$db = null;
?>

Code: Alles auswählen

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

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

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

Code: Alles auswählen

<?php 
session_start ();
?>

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

<?php 
setcookie ("c9", "c9", time () + 3600);

echo htmlentities ($_COOKIE ["c9"]) . "<br>\n";
echo htmlentities ($_COOKIE ["c9a"]) . "<br>\n";
echo htmlentities ($_POST ["p0009"]) . "<br>\n";

session_destroy ();
?>

Code: Alles auswählen

POST http://localhost/test/0009/form0009.php HTTP/1.1
host: localhost
cookie: c9a=Hallo 
content-length: 11
content-type: application/x-www-form-urlencoded

p0009=Hallo

Code: Alles auswählen

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Tue, 18 Apr 2023 17:53:16 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=lfk5q28vf9f5c1c4lpl336766l; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: c9=c9; expires=Tue, 18-Apr-2023 18:53:16 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 147
Content-Type: text/html; charset=UTF-8


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

<br>
Hallo<br>
Hallo<br>

Code: Alles auswählen

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

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

$sql = "CREATE DATABASE q0009" . ($rnd = rand ());
$db->query ($sql);

$sql = "USE q0009" . $rnd;
$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 (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO b (x) VALUES (" . rand () % 64 . "); ";
    $sql .= "INSERT INTO c (x) 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 [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 ORDER BY 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 ORDER BY 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 ORDER BY 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 ORDER BY 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 a
    ) x ORDER BY 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 ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";

$db = null;
?>

Code: Alles auswählen

19 25 23 29 22 8 0 27 5 7 1 16 26 15 3 14 53 56 20 49 4 60 32 10 9 39 45 62 <br>
19 25 23 29 22 8 0 27 5 7 1 16 26 15 3 18 116 100 10 73 56 112 61 46 12 121 60 107 14 113 57 50 38 71 <br>
14 53 8 3 56 20 49 4 60 32 10 9 39 19 45 23 62 18 116 100 16 73 112 25 61 46 12 121 5 107 26 113 57 50 38 71 <br>
19 23 8 3 <br>
25 5 16 26 <br>
14 56 60 10 <br>
5 10 14 16 25 26 56 60 <br>
5 10 14 16 25 26 56 60 <br>
3 8 10 14 19 23 56 60 <br>
3 8 10 14 19 23 56 60 <br>
3 5 8 16 19 23 25 26 <br>
3 5 8 16 19 23 25 26 <br>

Beitrag von **davidvajda** » Sa Apr 29, 2023 3:49 pm

Code: Alles auswählen

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

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

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

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

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

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


$db = null;
?>

Code: Alles auswählen

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

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

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

Beitrag von **davidvajda** » Sa Apr 29, 2023 3:54 pm

Code: Alles auswählen

<?php 
session_start ();
?>


<form method="POST" action="./form0010.php">
<input type="password" name="p0010"></input>
<input type="submit"></input>
</form>

<?php
echo htmlentities ($_POST ["p0010"]) . "<br>\n";
setcookie ("c0010", "Hallo", time () + 3600);
echo htmlentities ($_COOKIE ["c0010"]) . "<br>\n";
echo htmlentities ($_COOKIE ["c0010a"]) . "<br>\n";

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

session_destroy ();
?>

Code: Alles auswählen

POST http://localhost/test/0010/form0010.php HTTP/1.1
host: localhost
Cookie: c0010a=Hallo dies ist ein Text
Content-Length: 11
Content-Type: application/x-www-form-urlencoded

p0010=Hallo

Code: Alles auswählen

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sat, 29 Apr 2023 15:53:35 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=huolgqkt06cqr4ihpcpta27eq6; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: c0010=Hallo; expires=Sat, 29-Apr-2023 16:53:35 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 205
Content-Type: text/html; charset=UTF-8



<form method="POST" action="./form0010.php">
<input type="password" name="p0010"></input>
<input type="submit"></input>
</form>

Hallo<br>
<br>
Hallo dies ist ein Text<br>
huolgqkt06cqr4ihpcpta27eq6<br>

Beitrag von **davidvajda** » Sa Apr 29, 2023 4:01 pm

Code: Alles auswählen

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

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

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

$sql = "USE q0010";
$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 (x) VALUES (" . rand () % 128 . "); ";
    $sql .= "INSERT INTO b (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO c (x) 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 ORDER BY 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 ORDER BY 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 ORDER BY 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 ORDER BY 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 a
    ) x ORDER BY 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 ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br>\n";


$db = null;
?>

Code: Alles auswählen

99 44 40 28 95 62 63 6 80 119 3 78 17 37 73 86 72 16 4 59 35 41 108 21 31 20 22 25 0 24 30 8 5 19 23 11 <br>
99 44 40 28 95 62 63 6 80 119 3 78 17 37 73 86 72 16 4 59 35 41 108 10 49 30 15 11 58 34 55 42 29 45 0 48 27 33 1 14 20 46 <br>
16 21 31 20 22 25 0 24 30 6 8 5 19 3 28 23 11 10 40 49 37 15 58 34 55 42 29 45 48 27 35 33 1 14 46 <br>
28 6 3 16 <br>
40 37 35 <br>
20 0 30 11 <br>
0 11 20 30 35 37 40 <br>
0 11 20 30 35 37 40 <br>
0 3 6 11 16 20 28 30 <br>
0 3 6 11 16 20 28 30 <br>
3 6 16 28 35 37 40 <br>
3 6 16 28 35 37 40 <br>

Beitrag von **davidvajda** » Sa Mai 13, 2023 3:37 pm

Code: Alles auswählen

<?php 
session_start ();
?>

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

<?php 
setcookie ("c0011", "Hallo", time () + 2400);

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

echo htmlentities ($_COOKIE ["c0011"]) . "<br>\n";
echo htmlentities ($_COOKIE ["c0011a"]) . "<br>\n";
echo htmlentities ($_POST ["p0011"]) . "<br>\n";

session_destroy ();
?>
POST http://localhost/test/0011/form0011.php HTTP/1.1
host: localhost
Cookie: c0011a=Hallo Welt
Content-Length: 17
Content-Type: application/x-www-form-urlencoded

p0011=Super Sache
0 0<br>
0 1<br>
1 0<br>
1 1<br>
2 7<br>
<br><br>

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

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

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sat, 13 May 2023 15:28:16 GMT
Server: Apache/2.4.38 (Debian)
Set-Cookie: PHPSESSID=rb8lc0dg76qk8btbrk25ooasdd; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: c0011=Hallo; expires=Sat, 13-May-2023 16:08:16 GMT; Max-Age=2400
Vary: Accept-Encoding
Content-Length: 189
Content-Type: text/html; charset=UTF-8


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

rb8lc0dg76qk8btbrk25ooasdd<br>
<br>
Hallo Welt<br>
Super Sache<br>
102 91 100 97 105 32 43 19 48 90 3 49 98 101 87 108 27 126 60 57 21 31 10 7 15 13 9 5 22 25 20 29 23 18 <br><br>

102 91 100 97 105 32 43 19 48 90 3 49 98 101 87 108 27 126 60 57 21 31 46 1 22 15 35 7 33 37 40 26 14 12 63 42 23 54 24 <br><br>

10 7 15 3 13 9 21 5 22 25 20 29 23 18 46 1 32 35 33 37 40 26 14 12 43 63 42 27 54 24 <br><br>

3 21 <br><br>

32 43 27 <br><br>

7 15 22 23 <br><br>

7 15 22 23 27 32 43 <br><br>

7 15 22 23 27 32 43 <br><br>

3 7 15 21 22 23 <br><br>

3 7 15 21 22 23 <br><br>

3 21 27 32 43 <br><br>

3 21 27 32 43 <br><br>

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

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

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

$sql = "USE q0011" . $rnd;
$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 .= "INSERT INTO b (x) VALUES (" . rand () % 32 . "); ";
    $sql .= "INSERT INTO c (x) 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><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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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 [0] . " ";
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] . " ";
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 [0] . " ";
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 b INTERSECT SELECT x FROM c) x
        ) x ORDER BY x";        
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
echo "<br><br>\n\n";

$sql = "SELECT x FROM (
            SELECT x FROM (SELECT x FROM c UNION SELECT x FROM b) x
                INTERSECT
            SELECT x FROM a
        ) x ORDER BY x";
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
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 a) x
        ) x ORDER BY x";        
$stmt = $db->query ($sql);
while ($row = $stmt->fetch ())
    echo $row [0] . " ";
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" . ($rnd = rand () % 1024);
$db->query ($sql);

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

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

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


$db = null;
?>

yun7x.de dvajda.de und luckyleaks.org

Stundenplan

Re: Stundenplan

Re: Stundenplan

Re: Stundenplan

Re: Stundenplan

Re: Stundenplan

Re: Stundenplan

Re: Stundenplan