1.) Request
2.) Response
GET index.php HTTP/1.1.
host: localhost
Response-Code
200 OK
301 Moved Permanently
400 Bad Request
404 Not Found
GET
POST
HEAD
PUT
DELETE
TRACE
OPTIONS
CONNECT
<FORM ACTION="./form1.php" METHOD="GET">
<INPUT TYPE="password" NAME="password1"></INPUT>
<INPUT TYPE="submit"></INPUT>
</FORM>
setcookie ("Name", "Inhalt", time () + 2400);
$_GET []
$_POST []
$_COOKIE []
$_SESSION []
session_id ()
session_start ()
session_destroy ()
md5 ("password");
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
SHOW DATABASES
USE "xyz"
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32))
INSERT INTO abc VALUES ("001", "002");
INSERT INTO abc (name1, name2) VALUES ("001", "002");
DELETE FROM "abc";
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 LEFT JOIN def ON abc.name1 = def.name2;
SELECT * FROM abc RIGHT JOIN def ON def.name1 = abc.name2;
CHAR
VARCHAR
TINYTEXT
MEDIUMTEXT
LONGTEXT
BYTE
BLOB, LONGBLOB, MEDIUM, TINYBLOB
BOOLEAN
BOOL
INT
VARINT
MEDIUMINT
TINYINT
LONGINT
TIME
DATE
DATETIME
TIMESTAMP
mysql_connect ()
mysql_query ()
mysql_error ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_real_escape_string ()
mysql_num_rows ()
mysql_num_fields ()
mysql_close ()
mysql_select_database ()
