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


1.) Request
2.) Response 

GET index.php HTTP/1.1.
host: localhost 

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 []

<FORM action="./form.php" method="GET">
<INPUT TYPE="password" name="password1"></INPUT> 
<INPUT TYPE="submit"></INPUT>
</FORM>

md5 ("password");

mysql -u root -p

CREATE DATABASE "abc"
DROP DATABASE "abc" 
USE abc
CREATE TABLE "def" ("def01" VARCHAR (32), def02 VARCHAR (32))
INSERT INTO def VALUES ("001", "002");
SELECT * FROM def;
SELECT * FROM def WHERE expression;
SELECT * FROM def JOIN abc;
SELECT * FROM def INNER JOIN abc WHERE def.def01 = abc.abc01;
SELECT * FROM def RIGHT JOIN abc ON def.def01 = abc.abc01;
SELECT * FROM def LEFT JOIN abc ON def.def01 = abc.abc01;
DROP TABLE "def"
DELTE FROM def;

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