/media/sda-magnetic/david/Dok-15-2023-11-27/fernuni-hagen/cs-i-ii/old-cs-2-02/20220411aufgabe/auswendig0011d.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 Permantly
400 Bad Request 
404 Not Found 

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

setcookie ("name", "text", time () + 3600);

session_id ()
session_start ()
session_destroy ()

md5 ("password")

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

SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc INNER JOIN def WHERE abc.abc01 = def.def01;
SELECT * FROM abc RIGHT JOIN def ON abc.abc01 = def.def01;
INSERT INTO abc VALUES ("Hallo", "Welt");
INSERT INTO abc (name1, name2) VALUES ("Hallo", "Welt");
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
DROP TABLE abc;
CREATE DATABASE abc;
DROP DATABASE abc;
SHOW TABLES;
SHOW DATABASES;
USE abc;
SET PASSWORD;

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