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 []
$_SERVER []
$_FILE [][]
<FORM METHOD="GET" ACTION="./form1.php">
<INPUT TYPE="password" NAME="password1"></INPUT>
<INPUT TYPE="submit"></INPUT>
</FORM>
session_start ();
session_id ();
session_destroy ();
setcookie ("Name", "Inhalt", time () + 3600);
SET PASSWORD
CREATE DATABASE "xyz"
USE "xyz"
DROP DATABASE "xyz"
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
DROP TABLE abc;
INSERT INTO abc VALUES ("001", "002");
INSERT INTO abc (name2, name1) VALUES ("001", "002");
SELECT * FROM abc;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE name1 BETWEEN 1 AND 5;
SELECT * FROM abc ORDER BY name1 DESC;
SELECT * FROM abc INNER JOIN def WHERE 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, BYTE, INTEGER, INT, SMALLINT, MEDIUMINT, BIGINT
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
BINARY, BLOB, MEDIUMBLOB, LONGBLOB, TINYBLOB
DATA, DATETIME, TIME, TIMESTAMP
mysql_connect ()
mysql_close ()
mysql_error ()
mysql_query ()
mysql_fetch_assoc ()
mysql_fetch_row ()
mysql_real_escape_string ()
mysql_num_rows ()
mysql_num_fields ()
mysql_select_db ()
