/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/20220411aufgabe/auswendig0010d.txt


1.) Request
2.) Response

GET index.php HTTP/1.1.
host: localhost 

HTTP index.php 200 OK
Date: 
Server: 
X-Powerer-By: 
...

GET
POST 
HEAD
PUT 
DELETE 
TRACE 
OPTIONS
CONNECT 

200 OK
301 Moved Permanently
400 Bad Request 
404 Not Found 

$_GET []
$_POST []
$_COOKIE []
$_SESSION []

setcookie ("name", "inhalt", time () + 3600);

md5 ("passwort");

<FORM ACTION="./form1.php" METHOD="GET">
<INPUT TYPE="password" NAME="password1"></INPUT>
<INPUT TYPE="submit"></INPUT>
</FORM>

session_start ()
session_destroy ()
session_id ()

CREATE DATABASE "abc"
DROP DATABASE "abc"
CREATE TABLE "abc" (name1 VARCHAR (32), name2 VARCHAR (32))
DROP TABLE "abc"
USE "abc"
SHOW DATABASES
SET PASSWORD 
SELECT * FROM "abc"
SELECT * FROM "abc" JOIN "def"
SELECT * FROM "abc" WHERE abc.name1 = "xyz"
SELECT * FROM "abc" INNER JOIN "def" WHERE abc.name1 = def.name2
SELECT * FROM "abc" RIGHT JOIN "def" ON abc.name1 = def.name2
INSERT INTO "abc" VALUES ("001", "002");
INSERT INTO "abc" (name1, name2) VALUES ("001", "002");

BYTE, BOOLEAN, INT, SMALLINT, MEDIUMINT, BIGINT

FLOAT, DOUBLE, DECIMAL 

CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT

BIT

TIME, DATE, DATETIME, TIMESTAMP 

BLOB, LONGBLOB, TINYBLOB, MEDIUMBLOB 

mysql_query ()
mysql_connect ()
mysql_close ()
mysql_errer ()
mysql_select_db ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
mysql_real_escape_string ()

=DURCHSCHNITT 
=MAX 
=MIN 
=ANZAHL
=SUMMENPRODUKT