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_id ()
session_start ()
session_destroy ()
SET PASSWORD
USE "xyz"
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
SHOW TABLES
SHOW DATABASES
SHOW FIELDS FROM
CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
DROP TABLE abc
INSERT INTO abc (name1, name2) VALUES ("Hallo", "Welt");
INSERT INTO abc VALUES ("Hallo", "Welt");
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc WHERE name1 BETWEEN 1 AND 5
SELECT * FROM abc ORDER BY name1 DESC
SEELCT * 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, SMALLINT, TINYINT, BIGINT, INTEGER, MEDIUMINT
BYTE, BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TINYTEXT, MEDIUMTEXT, LONGTEXT
DATE, TIME, DATETIME, TIMESTAMP
mysql_connect ()
mysql_close ()
mysql_error ()
mysql_query ()
mysql_select_db ()
mysql_real_escape_string ()
mysql_fetch_assoc ()
mysql_fetch_row ()
mysql_num_rows ()
mysql_num_fields ()
