/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/auswendig-2022-05-11/auswendig0003d.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: 

GET 
POST 
HEAD 
PUT 
DELETE 
TRACE 
OPTIONS 
CONNECT 

200 OK 
301 Moved Permanently
400 Bad Request 
404 Not Found 

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

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

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

session_id ()
session_start ()
session_destroy ()

$_SESSION []

md5 ("password");

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

BYTE, BIT, TINYINT, SMALLINT, BIGINT, INT, INTEGER 

CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT

BYTE, BLOB, MEDIUMBLOB, LONGBLOB, TINYBLOB 

DATE, TIME, DATETIME, TIMESTAMP 

FLOAT, DOUBLE, DECIMAL 

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