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


1.) Request
2.) Response 

GET index.php HTTP/1.1.
host: localhost 

HTTP/1.1 200 OK
Date: 
Server: 
X-Powered-By:
Transfer-Encoding:
Content-Type:

Response-Codes:
200 OK 
301 Moved Permanently
400 Bad Request 
404 Not Found 

GET 
POST 
HEAD 
PUT 
DELETE 
TRACE 
OPTIONS 
CONNECT 

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

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

session_id ()
session_start ()
session_destroy ()

<FORM ACTION="./form1.php" METHOD="GET">
<INPUT TYPE="TEXT" NAME="text1"></INPUT>
<INPUT TYPE="SUBMIT"></INPUT>
</FORM>

md5 ("password");

INSERT INTO abc VALUES ("hallo", "welt")
INSERT INTO abc (name1, name2) VALUES ("hallo", "welt");
SELECT * FROM abc;
SELECT * FROM abc WHERE expression;
SELECt * FROM abc JOIN def;
SELECT * FROM abc INNER JOIN def WHERE abc.name1 = def.name1;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name1
SELECT * FROM abc LEFT JOIN def ON abc.name1 = def.name1
CREATE DATABASE "abc"
DROP DATABASE "abc"
CREATE TABLE "abc"
DROP TABLE "abc"
USE "abc"
SET PASSWORD
SHOW TABLES
SHOW DATABASES

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

BIT, BOOLEAN, INT, LONGINT, BIGINT, SMALLINT, TINYINT
CHAR, VARCHAR, TEXT, MEDIUMTEXT, TINYTEXT, LONGTEXT 
BYTE, BLOB, LONGBLOB, MEDIUMBLOB, TINYBLOB
FLOAT, DOUBLE, DECIMAL
TIME, DATE, DATEIME, TIMESTAMP