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