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:
200 OK
301 Moved Permanently
400 Bad Request
404 Not Found
GET
POST
HEAD
PUT
DELETE
TRACE
OPTIONS
CONNECT
$_GET []
$_COOKIE []
$_POST []
$_FILE [] []
$_SESSION []
$_SERVER []
setcookie ("Name", "Inhalt", time () + 3600);
session_start ()
session_id ()
session_destroy ()
USE "xyz"
CREATE DATABASE xyz
DROP DATABASE xyz
SET PASSWORD
SHOW DATABASES
SHOW TABLES
SHOW FIELDS FROM abc
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
INSERT INTO abc (name1, name2) VALUES ("hallo", "welt);
INSERT INTO abc VALUES ("Hallo", "Welt");
SELECT * FROM abc;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc WHERE name1 BETWEEN 1 AND 5
SELECT * FROM abc SORTED BY name1
SELECT * FROM abc JOIN def;
SELECT * FROM abc INNER JOIN def ON def.name1 = abc.name3;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc LEFT JOIn def ON abc.name1 = def.name3;
SELECT x FROM (SELECT x FROM abc UNION SELECT x FROM def)x
SELECT x FROM (SELECT x FROM abc INTERSECT SELECT x FROM def)x
BIT, BOOL, INT, INTEGER, SMALLINT, BIGINT, MEDIUMINT, TINYINT
DECIMAL, FLOAT, DOUBLE
CHAR, VARCHAR, TEXT, TINYTEXT, LONGTEXT, MEDIUMTEXT
TIME, DATE, DATETIME, TIMESTAMP
BYTE, BLOB, TINYBLOB, LONGBLOB, MEDIUMBLOB
mysql_connect ()
mysql_close ()
mysql_query ()
mysql_error ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
mysql_select_db ()
mysql_real_escape_string ()
