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 []
$_POST []
$_COOKIE []
$_FILE [] []
$_SESSION []
session_start ()
session_id ()
session_destroy ()
setcookie ("Name", "Inhalt", time () + 3600);
<form method="GET" action="./form1.php">
<input type="text" name="text1"></input>
<input type="submit"></input>
</form>
SHOW TABLES
SHOW DATABASES
USE "xyz"
SHOW FIELDS FROM "abc"
SET PASSWORD
CREATE DATABASE "xyz"
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
DROP DATABASE xyz
CREATE DATABASE xyz
INSERT INTO abc VALUES ("hallo", "welt");
INSERT INTO abc (name1, name2) VALUES ("Hallo", "Welt");
SELECT * FROM abc;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc JOIN def;
SELECT * FROM abc INNER JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc LEFT JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc WHERE name1 BETWEEN 1 AND 5
SELECT * FROM abc SORTED BY name1
BYTE, BLOB, TINYBLOB, LONGBLOB, MEDIUMBLOB
BIT, INT, INTEGER, SMALLINT, MEDIUMINT, BIGINT
CHAR, VARCHAR, TEXT, TINYTEXT, LONGTEXT, MEDIUMTEXT
DATE, TIME, DATETIME, TIMESTAMP
FLOAT, DOUBLE, DECIMAL
mysql_query ()
mysql_connect ()
mysql_error ()
mysql_close ()
mysql_real_escape_string ()
mysql_fetch_assoc ()
mysql_fetch_row ()
mysql_num_rows ()
mysql_num_fields ()
mysql_select_db ()
