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


1.) Request
2.) Response

GET /index.php HTTP/1.1
host: localhost 

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

200 OK 
301 Moved Permanently
400 Bad Request
404 Not Found 

GET 
POST 
HEAD 
PUT 
DELETE 
TRACE 
OPTIONS
CONNECT 

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

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

session_id ()
session_start ()
sesseion_destroy ()

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

md5 ("password");

CREATE DATABASE "xyz"
DROP DATABASE "xyz"
DELETE FROM "abc"
SET PASSWORD
USE "xyz"
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
DROP TABLE abc;
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc INNER JOIN def WHERE abc.name1 = def.name3;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc LEFT JOIN def ON abc.name1 = def.name3;

UNION

SELECT x FROM abc UNION SELECT x FROM def;

SELECT x FROM (SELECT x FROM abc UNION SELECT x FROM def)x;

INTERSECT

SELECT x FROM abc INTERSECT SELECT x FROM def;

SELECT x FROM (SELECT x FROM abc INTERSECT SELECT x FROM def)x;

SELECT * FROM abc WHERE id BETWEEN 1 AND 5
SELECT * FROM abc WHERE id, name DESC 

INSERT INTO abc VALUES ("001", "002");
INSERT INTO abc (name1, name2) VALUES ("001", "002");

BOOL, BIT, BLOB, TINYBLOB, LONGBLOB, MEDIUMBLOB

INT, INTEGER, BIGINT, MEDIUMINT, TINYINT 

CHAR, VARCHAR, TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT

FLOAT, DOUBlE, DECIMAL 

TIME, DATE, DATETIME, TIMESTAMP 

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

POST /index.php HTTP/1.1
host: localhost 
Content-Length: 7
Content-Type: Application/x-www-form-urlencoded

q=Hallo 

openssl s_client -connect www.facebook.com:443