1.) Request
2.) Response
GET index.php HTTP/1.1.
host: localhost
GET
POST
HEAD
PUT
DELETE
TRACE
OPTIONS
CONNECT
200 OK
301 Moved Permantly
400 Bad Request
404 Not Found
$_GET []
$_POST []
$_COOKIE []
$_SESSION []
setcookie ("Name", "Inhalt", time () + 3600);
<FORM ACTION="./form.php" METHOD="GET">
<INPUT TYPE="PASSWORD" NAME="passwort1"></INPUT>
<INPUT TYPE="SUBMIT"></INPUT>
</FORM>
session_id ()
session_start ()
session_destroy ()
CREATE DATABASE "xyz"
DROP DATABASE "xyz"
SHOW DATABASES
CREATE TABLE "abc" (name1 VACHAR (32), name2 VARCHAR (32))
USE "xyz"
INSERT INTO abc VALUES ("hallo", "welt");
INSERT INTO abc (name1, name2) VALUES ("Hallo", "Welt");
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc INNER JOIN def WHERE abc.name1 = def.name1
SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name1
SELECT * FROM abc LEFT JOIN def ON def.name1 = abc.name1
BIT
BOOLEAN
TINYINT
INT
BIGINT
CHAR
VARCHAR
CHAR
VARCHAR
TEXT
TINYTEXT
LONGTEXT
MEDIUMTEXT
FLOAT, DOUBLE, DECIMAL
BYTE
BLOB, LONGBLOB, TINYBLOB, MEDIUMBLOB
TIME, DATE, DATETIME, TIMESTAMP
mysql_connect ()
mysql_close ()
mysql_error ()
mysql_query ()
mysql_select_db ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
