1.) Request
2.) Response
GET /index.php HTTP/1.1
host: localhost
HTTP/1.1 200 OK
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 []
setcookie ("Name", "Inhalt", time () + 2400);
session_start ()
session_id ()
session_destroy ()
$_SESSION
<form method="GET" action="./form1.php">
<input type="password" name="password1></input>
<input type="submit"></input>
</form>
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
USE "xyz"
DROP TABLE "abc"
SET PASSWORD
SHOW DATABASES
SHOW TABLES
SHOW FIELDS FROM
CREATE TABLE abc VALUES (name1 VARCHAR (32), name2 VARCHAR (32))
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 LEFT JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;
BIT, BOOLEAN, INT, INTEGER, BIGINT, SMALLINT, MEDIUMINT, TINYINT
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TEXT, TINYTEXT, LONGTEXT, MEDIUMTEXT
DATE TIME DATETIME TIMESTAMP
BYTE, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB
mysql_connect ()
mysql_query ()
mysql_error ()
mysql_close ()
mysql_select_db ()
mysql_fetch_assoc ()
mysql_fetch_row ()
mysql_real_escape_string ()
mysql_num_rows ()
mysql_num_fields ()
