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


1.) Request
2.) Response

GET /index.php HTTP/1.1
host: localhost 

200 OK HTTP/1.1
Date:
Server:
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 []

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

session_id ()
$_SESSION []
session_destroy ()
session_start ()

<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"
USE xyz;
SET PASSWORD;
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
INSERT INTO abc VALUES ("001", "001");
INSERT INTO abc (name1, name2) VALUES ("001", "001");
SELECT * FROM abc;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc JOIN def;
SELECT * FROM abc INNER JOIN def WHERE abc.name1 = def.name2;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;

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

BYTE, BLOB, TINYBLOB, LONGBLOB

CHAR, VARCHAR, TEXt, TINYTEXT, MEDIUMTEXt, LONGTEXT

TIME, DATE, DATETIME, TIMESTAMP 

FLOAT, DOUBLE, DECIMAL 

INT, SMALLINT, TINYINT, INTEGER, BIGINT