/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/auswendig-2022-05-11/auswendig0006d.txt


1.) Request
2.) Response

GET /index.php HTTP/1.1
host: localhost 

200 OK HTTP/1.1
Server: 
x-power-by:
transfer-encoding:
content-type:

200 OK
301 Moved Permanently
400 Bad Request
404 Not Found 

GET
POST
HEAD
PUT 
DELETE
TRACE 
OPTIONS 
CONNECT 

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

setcookie ("Name", "Inhalt", time () + 3600);

session_id ()
session_start ()
session_destroy ()

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

md5 ("password");

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

BIT, INT, SMALLINT, INTEGER, BIGINT, TININT
TIME, DATATIME, DATE, TIMESTAMP
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TINYCHAR, TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT
BIT, BYTE, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB

mysql_query ()
mysql_error ()
mysql_connect ()
mysql_close ()
mysql_fetch_assoc ()
mysql_fetch_row ()
mysql_num_rows ()
mysql_num_fields ()
mysql_real_escape_string ()