Das neue Auswendig lernen und die neuen Übungen - 0003

Antworten
Benutzeravatar
davidvajda.de
Site Admin
Beiträge: 1517
Registriert: Di Jul 18, 2023 8:36 pm
Wohnort: D-72072, Tübingen
Kontaktdaten:
Kontaktdaten von davidvajda.de

Re: Das neue Auswendig lernen und die neuen Übungen - 0003

Beitrag von davidvajda.de »

Bild

Code: Alles auswählen

<?php
session_start ();
?>

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

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

setcookie ("form20240406b", "Dies ist das erste Cookie", time () + 1200);

echo htmlentities ($_POST ["form20240406a"]) . "<br>";
echo htmlentities ($_COOKIE ["form20240406b"]) . "<br>";
echo htmlentities ($_COOKIE ["form20240406c"]) . "<br>";

session_destroy ();
?>

Code: Alles auswählen

POST http://localhost/mysql20240217/20240406/form20240406.php HTTP/1.1
host: localhost
Cookie: form20240406a=Hallo, ich bin ein anderes Cookie
Content-Length: 37
Content-Type: application/x-www-form-urlencoded

form20240406a=Hallo ich bin das Datum

Code: Alles auswählen

Trying ::1...
Connected to localhost.
Escape character is '^]'.
HTTP/1.1 200 OK
Date: Sat, 06 Apr 2024 07:19:56 GMT
Server: Apache/2.4.57 (Debian)
Set-Cookie: PHPSESSID=7kl5anhlcq8td6nc1vvbt3122v; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Set-Cookie: form20240406b=Dies%20ist%20das%20erste%20Cookie; expires=Sat, 06 Apr 2024 07:39:56 GMT; Max-Age=1200
Vary: Accept-Encoding
Content-Length: 195
Content-Type: text/html; charset=UTF-8

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

7kl5anhlcq8td6nc1vvbt3122v<br>
Hallo ich bin das Datum<br><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 mysql20240406" . session_id () . "; ";
$db->query ($sql);

$sql = "USE mysql20240406" . session_id () . "; ";
$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 (x2, x2) VALUES (5, 5); INSERT INTO b (y1, y2) VALUES (0, 1); INSERT INTO b (y1, y2) VALUE (1, 0); INSERT INTO b (y1, y2) VALUES (5, 5); ";
$db->query ($sql);

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

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

$sql = "SELECT x1, x2, y1, y2 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] . "; ";
$db->query ($sql);

$sql = "DROP DATABASE mysql20240406" . session_id () . "; ";
$db->query ($sql);

session_destroy ();
?>

Code: Alles auswählen

0, 0; 0, 1; 1, 0; 1, 1; <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 q20240406" . session_id () . "; ";
$db->query ($sql);

$sql = "USE q20240406" . session_id () . "; ";
$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; ";
$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; ";
$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 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 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 a INTERSECT SELECT x FROM b) x
                INTERSECT
            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";

$sql = "DROP DATABASE q20240406" . session_id () . "; ";
$db->query ($sql);

session_destroy ();
?>

Code: Alles auswählen

31, 23, 2, 29, 10, 9, 20, 5, 15, 6, 21, 27, 14, 0, 12, 1, 36, 43, 53, 11, 49, 39, 22, 37, 13, 17, 40, 25, 55, 59, 28, 32, <br>
31, 23, 2, 29, 10, 9, 20, 5, 15, 6, 21, 27, 14, 0, 12, 1, 72, 95, 26, 83, 24, 62, 68, 114, 117, 86, 110, 22, 118, 37, 96, 51, 46, 78, <br>
36, 43, 12, 53, 23, 11, 49, 21, 39, 22, 37, 13, 17, 9, 40, 20, 25, 0, 55, 59, 28, 32, 29, 72, 31, 95, 26, 83, 24, 27, 62, 68, 114, 117, 86, 110, 118, 14, 96, 51, 46, 78, <br>
23, 9, 20, 21, 0, 12, <br>
31, 29, 27, 14, <br>
22, 37, <br>
31, 29, 27, 14, 22, 37, <br>
14, 22, 27, 29, 31, 37, <br>
23, 9, 20, 21, 0, 12, 22, 37, <br>
0, 9, 12, 20, 21, 22, 23, 37, <br>
0, 9, 12, 14, 20, 21, 23, 27, 29, 31, <br>
<br>

Code: Alles auswählen

#!/bin/bash

if [[ "$1" == "David" && "$2" == "Vajda" ]]
then
    echo "Das bin ich"
elif [[ "$1" == "David Vajda" && -z "$2" ]]
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 ich nicht"
else
    echo "Hallo Welt"

    i=0
    while [ $i -lt 10 ]
    do
        echo "Hallo zum $(($i+1))."
        i=$(($i+1))
    done

    a=(Ich bin ein Array)
    a+=(Und seine Fortsetzung)

    i=0
    while [ $i -lt 7 ]
    do
        echo "${a[$i]}"
        i=$(($i++1))
    done

    for s in "${a[@]}"
    do
        echo "$s"
    done

    l=$(ls)
    for s in $l
    do
        echo "$s"
    done

fi

Code: Alles auswählen

#!/bin/bash

/bin/bash bash20240408.sh "David" "Vajda"
/bin/bash bash20240408.sh "David Vajda"
/bin/bash bash20240408.sh "David"
/bin/bash bash20240408.sh "Vajda"
/bin/bash bash20240408.sh "David Mustermann"
/bin/bash bash20240408.sh "Max Mustermann"
/bin/bash bash20240408.sh

Code: Alles auswählen

Das bin ich
Das bin ich
Das koennte ich sein
Das koennte ich sein
Das bin ich nicht
Das bin ich nicht
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.
Ich
bin
ein
Array
Und
seine
Fortsetzung
Ich
bin
ein
Array
Und
seine
Fortsetzung
200066.png
200082.png
20240403_193924.jpg
20240403_201151.jpg
20240403_201154.jpg
434404849_25023964997218914_7634363595333631096_n.jpg
addressdecodertestbench.c
algoke1_20240403.aux
algoke1_20240403.log
algoke1_20240403.pdf
algoke1_20240403.tex
alldo.txt
alllinks.sh
asm15
asm16
asm20240403
asm20240403.asm
asm20240403.o
asm20240404
asm20240404.asm
asm20240404.aux
asm20240404.log
asm20240404.o
asm20240404.pdf
asm20240404.tex
aufgabe1.1.pdf
aufgabenalgomath20240403.txt
auswendig20240402a.txt
auswendig20240402b.txt
auswendig20240402c.txt
automat15
automat15.c
automat20240403-1.jpg
automat20240403.aux
automat20240403.csv
automat20240403.log
automat20240403.pdf
automat20240403.tex
automat20240403.txt
bash20240402all.sh
bash20240402.out
bash20240402.sh
bash20240403all.sh
bash20240403.out
bash20240403.sh
bash20240404all.sh
bash20240404.out
bash20240404.sh
bash20240408all.sh
bash20240408.out
bash20240408.sh
bas.txt
Bilder
bin20240204.txt
bin20240403.txt
binary2
binary2.c
deepsearch1.c
deepsearch2
deepsearch2.c
doc
Dokumente
dos-inst
Downloads
facebookpassword.txt
files.lst
float.c
fsmprogs
generatetestbench2
generatetestbench3
generatetestbench4
generatetestbench5
gnu-hello
ieee754aufgabe
ieee754aufgabe2.c
ieee754aufgabe.c
ieee754aufgabe.o
Induktion-pdf.pdf
inst
mail
Mars
mathematik.aux
mathematik.log
mathematik.pdf
mathematik.tex
matlab
mips32singlecycle2.vhdl
mips32singlecycle.vhdl
Musik
mycounter.jpg
mycounter.odg
mydaemontestd
myminix-01.jpg
myminix-02.jpg
myminix-03.jpg
myminix-04.jpg
myminix-05.jpg
myminix-06.jpg
myminix-07.jpg
myminix-08.jpg
myminix-09.jpg
myminix-10.jpg
myminix-11.jpg
myminix-12.jpg
myminix-13.jpg
myminix-14.jpg
myminix-15.jpg
myminix-16.jpg
myminix-17.jpg
myminix-18.jpg
myminix-19.jpg
myminix20240405-01.jpg
myminix20240405-02.jpg
myminix20240405-03.jpg
myminix20240405-04.jpg
myminix20240405-05.jpg
myminix20240405-06.jpg
myminix20240405-07.jpg
myminix20240405-08.jpg
myminix20240405-09.jpg
myminix20240405-10.jpg
myminix20240405-11.jpg
myminix20240405-12.jpg
myminix20240405-13.jpg
myminix20240405-14.jpg
myminix20240405-15.jpg
myminix20240405-16.jpg
myminix20240405-17.jpg
myminix20240405-18.jpg
myminix20240405-19.jpg
myminix20240405-20.jpg
myminix20240405-21.jpg
myminix20240405-22.jpg
myminix20240405-23.jpg
myminix20240405-24.jpg
myminix20240405-25.jpg
myminix20240405-26.jpg
myminix20240405-27.jpg
myminix20240405.aux
myminix20240405.log
myminix20240405.pdf
myminix20240405.tex
myminix-20.jpg
myminix-21.jpg
myminix-22.jpg
myminix-23.jpg
myminix-24.jpg
myminix-25.jpg
myminix-26.jpg
myminix-27.jpg
myminixalljpg20240405.out
myminixalljpg.out
myminixalljpg.sh
myminix.aux
myminix.log
myminix.pdf
myminix.tex
myminix.txt
mysqldata.php
node_modules
Öffentlich
out.txt
password
password20240326.txt
password46.txt
quine
quine20240402.txt
quine20240402.vhdl
quine20240403.txt
quine20240403.vhdl
quine20240404.txt
quine20240404.vhdl
replace.sh
Schreibtisch
Screenshot_20240402_161254.png
Screenshot_20240402_222524.png
Screenshot_20240403_095701.png
Screenshot_20240403_112929.png
Screenshot_20240406_091517.png
state3
svg
test.png.vcd
todo2.txt
todo.txt
Videos
VirtualBox
VMs
vorl03_ana.pdf
Vorlagen
wave.ghw
wave.wav
work-obj93.cf
Nach oben
Antworten

Zurück zu „informatik“