1.) Request
2.) Response
GET /index.php HTTP/1.1
host: localhost
HTTP/1.1 200 OK
Server:
X-Powerd-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 [][]
setcookie ("Name", "Inhalt", time () + 3600);
session_id ()
session_start ()
session_destroy ()
<form method="GET" action="./form1.php">
<input type="password" name="password1"></input>
<input type="submit"></submit>
</form>
SET PASSWORD
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
USE DATABASE "xyz"
SHOW DATABASES
SHOW TABLES
INSERT INTO abc VALUES ("001", "001");
INSERT INTO abc (name1, name2) VALUES ("001", "001");
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
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 WHERE name1 BETWEEN 1 AND 5
SELECT * FROM abc ORDER BY name DESC
BIT, BOOLEAN, INT, INTEGER, SMALLINT, BIGINT, MEDIUMINT
TIME, TIMESTAMP, DATE, DATETIME
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
BYTE, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB
FLOAT, DOUBLE, DECIMAL
mysql_connect ()
mysql_error ()
mysql_query ()
mysql_close ()
mysql_select_db ()
mysql_real_escape_string ()
mysql_fetch_rows ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
