Code: Alles auswählen
<?php
session_start ();
?>
<form method="POST" action="./mysql20240229.php">
<input type="text" name="mysql2024022901"></input>
<input type="submit"></input>
</form>
<?php
echo session_id () . "<br>\n";
setcookie ("mysql2024022902", "Hallo, ich bin Cookie 1", time () + 3600);
echo htmlentities ($_POST ["mysql2024022901"]) . "<br>\n";
echo htmlentities ($_COOKIE ["mysql2024022902"]) . "<br>\n";
echo htmlentities ($_COOKIE ["mysql2024022903"]) . "<br>\n";
session_destroy ();
?>
Richtig heisst es so
Code: Alles auswählen
<?php
session_start ();
?>
<form method="POST" action="./form20240229.php">
<input type="text" name="form2024022901"></input>
<input type="submit"></input>
</form>
<?php
echo session_id () . "<br>\n";
setcookie ("form2024022902", "Hallo, ich bin Cookie 1", time () + 3600);
echo htmlentities ($_POST ["form2024022901"]) . "<br>\n";
echo htmlentities ($_COOKIE ["form2024022902"]) . "<br>\n";
echo htmlentities ($_COOKIE ["form2024022903"]) . "<br>\n";
session_destroy ();
?>
Code: Alles auswählen
POST http://localhost/mysql20240217/20240229/form20240229.php HTTP/1.1
host: localhost
Cookie: form2024022903=Hallo, dies ist Cookie 2
Content-Type: application/x-www-form-urlencoded
Content-Length: 30
form2024022901=Dies ist Data 1
Code: Alles auswählen
[code]
Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Thu, 29 Feb 2024 18:01:24 GMT
Server: Apache/2.4.57 (Debian)
Set-Cookie: PHPSESSID=d51gmeslpsu299hlmlb3g2uacu; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: form2024022902=Hallo%2C%20ich%20bin%20Cookie%201; expires=Thu, 29 Feb 2024 19:01:24 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 224
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form20240229.php">
<input type="text" name="form2024022901"></input>
<input type="submit"></input>
</form>
d51gmeslpsu299hlmlb3g2uacu<br>
Dies ist Data 1<br>
<br>
Hallo, dies ist Cookie 2<br>
Code: Alles auswählen
<?php
session_start ();
include ("/home/david/mysqldata.php");
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE mysql20240229" . session_id ();
$db->query ($sql);
$sql = "USE mysql20240229" . session_id ();
$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);";
$sql .= "INSERT INTO a (x1, x2) VALUES (0, 1);";
$sql .= "INSERT INTO a (x1, x2) VALUES (1, 0);";
$sql .= "INSERT INTO a (x1, x2) VALUES (1, 1);";
$sql .= "INSERT INTO a (x1, x2) VALUES (2, 7);";
$sql .= "INSERT INTO b (y1, y2) VALUES (0, 0);";
$sql .= "INSERT INTO b (y1, y2) VALUES (1, 1);";
$sql .= "INSERT INTO b (y1, y2) VALUES (2, 7);";
$db->query ($sql);
$sql = "SELECT x1, x2 FROM a;";
$stmt = $db->query ($sql);
while ($row = $stmt -> fetch ())
echo $row [0] . ", " . $row [1] . "<br>\n";
echo "<br>\n";
$sql = "SELECT y1, y2 FROM b;";
$stmt = $db->query ($sql);
while ($row = $stmt -> fetch ())
echo $row [0] . ", " . $row [1] . "<br>\n";
echo "<br>\n";
$sql = "SELECT x1, x2, y1, y2 FROM a LEFT 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";
$sql = "DROP DATABASE mysql20240229" . session_id ();
$db->query ($sql);
session_destroy ();
?>
Code: Alles auswählen
0, 0<br>
0, 1<br>
1, 0<br>
1, 1<br>
2, 7<br>
<br>
0, 0<br>
1, 1<br>
2, 7<br>
<br>
0, 0, 0, 0<br>
0, 1, 0, 0<br>
1, 0, 1, 1<br>
1, 1, 1, 1<br>
2, 7, 2, 7<br>
<br>
Code: Alles auswählen
<?php
session_start ();
include ("/home/david/mysqldata.php");
$db = new PDO ("mysql: host=localhost", $MYSQL_USER, $MYSQL_PASSWORD);
$sql = "CREATE DATABASE q20240229" . session_id ();
$db->query ($sql);
$sql = "USE q20240229" . session_id ();
$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 (x) VALUES (\"" . rand () % 32 . "\");";
$db->query ($sql);
$sql = "INSERT INTO b (x) VALUES (\"" . rand () % 28 . "\");";
$db->query ($sql);
$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;";
$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 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 b UNION SELECT x FROM c) x
INTERSECT
SELECT x FROM a
) 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 q20240229" . session_id ();
$db->query ($sql);
session_destroy ();
?>
Code: Alles auswählen
19, 20, 24, 29, 10, 22, 11, 9, 12, 30, 2, 7, 3, 8, 15, 18, 21, 17, 25, 0, 14, 6, 13, 4, 23, 16, 27, 26, <br>
19, 20, 24, 29, 10, 22, 11, 9, 12, 30, 2, 7, 3, 8, 15, 18, 21, 17, 25, 28, 32, 50, 49, 51, 36, 46, 33, 52, 37, 47, 44, 23, 42, <br>
24, 0, 14, 6, 13, 4, 9, 2, 15, 23, 17, 7, 16, 18, 20, 22, 27, 26, 28, 32, 50, 49, 51, 36, 21, 46, 19, 33, 52, 37, 47, 44, 42, <br>
20, 24, 22, 9, 2, 7, 15, 18, 17, <br>
19, 20, 24, 22, 7, 15, 21, <br>
24, 15, 23, 7, 20, 22, <br>
19, 20, 24, 22, 7, 15, 21, 23, <br>
19, 20, 24, 22, 7, 15, 21, 23, <br>
20, 24, 22, 9, 2, 7, 15, 18, 17, 23, <br>
20, 24, 22, 9, 2, 7, 15, 18, 17, 28, 32, 50, 49, 51, 36, 21, 46, 19, 33, 52, 37, 47, 44, 23, 42, <br>
24, 9, 2, 15, 17, 7, 18, 20, 22, 21, 19, <br>
24, 9, 2, 15, 17, 7, 18, 20, 22, 21, 19, <br>
Code: Alles auswählen
#!/bin/bash
echo "Hallo Welt"
if [[ "$1" == "David" && "$2" == "Vajda" ]]
then
echo "Das bin ich"
elif [[ "$1" == "David Vajda" ]]
then
echo "Das bin ich"
elif [[ "$1" == "David" && -z "$2" ]]
then
echo "Das koennte ich sein"
elif [[ "$1" == "Vajda" && -z "$2" ]]
then
echo "Das koennte ich sein"
elif [ -n "$1" ]
then
echo "Das bin nicht ich"
elif [ -z "$1" ]
then
i=0
while [ $i -lt 10 ]
do
echo "Hallo zum $(($i+1))."
i=$(($i+1))
done
a=(Dies ist ein Array)
a+=(Und dies ist an das Array angehaengt)
for s in "${a[@]}"
do
echo "$s"
done
i=0
while [ $i -lt 11 ]
do
echo "${a[$i]}"
i=$(($i+1))
done
l=$(ls)
for s in $l
do
echo "$s"
done
fi
Code: Alles auswählen
#!/bin/bash
/bin/bash hello.sh
/bin/bash hello.sh "David" "Vajda"
/bin/bash hello.sh "David Vajda"
/bin/bash hello.sh "David"
/bin/bash hello.sh "Vajda"
/bin/bash hello.sh "Max Mustermann"
Code: Alles auswählen
Hallo Welt
Hallo zum 1.
Hallo zum 2.
Hallo zum 3.
Hallo zum 4.
Hallo zum 5.
Hallo zum 6.
Hallo zum 7.
Hallo zum 8.
Hallo zum 9.
Hallo zum 10.
Dies
ist
ein
Array
Und
dies
ist
an
das
Array
angehaengt
Dies
ist
ein
Array
Und
dies
ist
an
das
Array
angehaengt
helloexec.sh
hello.out
hello.sh
Hallo Welt
Das bin ich
Hallo Welt
Das bin ich
Hallo Welt
Das koennte ich sein
Hallo Welt
Das koennte ich sein
Hallo Welt
Das bin nicht ich
Code: Alles auswählen
1.) Rechne die Zahl in binaer Darstellung in eine Dezimale Darstellung um
1101001100000011b 54019d
2.) Rechne die Zahl in dezimal darstellung in eine Binaerdarstellung um
29809 0111010001110001
3.) Addiere die drei Zahlen schriftlich
61770
+ 31999
+ 49088
-----------------
142857
4.) Subtrahiere die letzten drei Zahlen schriftlich von der ersten schriftlich
28813
- 12006
- 4529
- 6985
-----------------
5293
5.) Rechne die Zahl ins zweier komplement um, mit 8 Bit - und subtrahiere diese zahl von der ersten und rechne das Ergebnis nach dezimal
85 -91 = -6
01010101 10100101 = 11111010
6.) Multipliziere die zwei Zahlen schriftlich
14750*6769 = 99842750
7.) Dividiere die zwei Zahlen schriftlich
62739/43447 = 1
8.) Errechne x Logarithmisch mit dem Taschenrechner
24728^x = 1753828970
