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 [] []
<form action="./form1.php" method="GET">
<input type="password" name="password1"></input>
<input type="submit"></submit>
</form>
setcookie ("Name", "Inhalt", time () + 3600);
session_id ();
session_destroy ();
session_start ();
SET PASSWORD
USE "xyz"
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32))
INSERT INTO abc (name1, name2) VALUES ("001", "001");
INSERT INTO abc VALUES ("001", "001");
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc INNER JOIN def ON abc.name1 = def.name3;
SELECT * FROM abc WHERE expression;
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 ORDER BY name1
BYTE, BLOB, TINYBLOB, LONGBLOB, MEDIUMBLOB
BIT, INT, INTEGER, BIGINT, TINYINT, SMALLINT
TIME, DATETIME, DATE, TIMESTAMP
CHAR, VARCHAR, TEXT, TINYTEXT, LONGTEXT, MEDIUMTEXT
FLOAT, DOUBLE, DECIMAL
mysql_close ()
mysql_error ()
mysql_query ()
mysql_connect ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
mysql_real_escape_string ()
