1.) Request
2.) Response
GET /index.php HTTP/1.1
host: localhost
200 OK HTTP/1.1
Server:
X-Powerd-By:
Transfer-Encoding:
Content-Type:
200 OK
301 Moved Permanently
400 Bad Request
404 Not Found
GET
POST
HEAD
DELETE
TRACE
OPTIONS
CONNECT
$_GET []
$_POST []
$_COOKIE []
setcookie ("Name", "Inhalt", time () + 3600);
session_id ()
session_start ()
session_destroy ()
<form action="./form1.php" method="GET">
<input type="password" name="password1"></input>
<input type="submit"></input>
</form>
md5 ("password")
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
USE "xyz"
SET PASSWORD
SHOW DATABASES
SHOW TABLES
SHOW COLUMNS FROM
SHOW FIELDS FROM
SELECT * FROM abc;
SELECT * FROM abc WHERE expression
SELECT * FROM abc JOIN def;
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;
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 kunden WHERE id BETWEEN 1 and 5
SELECT * FROM kunden ORDER BY NAME id, name DESC
BYTE, BLOB, TINY BLOB, LONG BLOB, MEDIUMBLOB
INT, INTEGER, TINYINT, BIGINT, SMALLINT, MEDIUMINT
DATE, TIME, TIMESTAMP, DATETIME
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT
mysql_connect ()
mysql_close ()
mysql_error ()
mysql_query ()
mysql_fetch_assoc ()
mysql_nun_rows ()
mysql_num_fields ()
mysql_select_db ()
mysql_fetch_row
mysql_real_escape_string ()
