1.) Request
2.) Response
GET index.php HTTP/1.1.
host: localhost
GET
POST
HEAD
PUT
DELETE
TRACE
OPTIONS
CONNECT
200 OK
301 Moved Permanently
400 Bad Request
404 Not found
$_GET []
$_POST []
$_COOKIE []
$_SESSION []
session_id ()
session_start ()
session_destroy ()
md5 ("password";
setcookie ("Name", "inhalt", time () + 3600);
<FORM METHOD="GET" ACTION="./form1.php">
<INPUT TYPE="PASSWORD" NAME="password1"></INPUT>
<INPUT TYPE="SUBMIT"></INPUT>
</FORM>
SELECT * FROM abc;
SELECT * FROM abc JOIN def;
SELECT * FROM abc WHERE expression;
SELECT * FROM abc INNER JOIN def WHERE abc.abcxyz = def.defxyz;
SELECT * FROM abc RIGHT JOIN def ON abc.abcxyz = def.defxyz;
SELECT * FROM abc LEFT JON def ON abc.abcxyz = def.defxyz;
INSERT INTO abc VALUES ("Hallo", "Welt");
INSERT INTO abc (abcxyz01, abcxyz02) VALUES ("Hallo", "Welt");
DROP TABLE abc;
CREATE TABLE abc (abc01 VARCHAR (32), abc02 VARCHAR (32));
ALTER TABLE abc ADD abc03 VARHCHAR (32);
CREATE DATABASE abc;
DROP DATABASE abc;
USE abc;
SHOW DATABASES;
CHAR
VARCHAR
TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
FLOAT, DOUBLE, DECIMAL
BIT, BYTE
INT, TINYINT, BIGINT,
BLOB, LONGBLOB, MEDIUMBLOB, TINYBLOB
TIME, TIMESTAMP, DATE, DATETIME
mysql_query ()
mysql_connect ()
mysql_error ()
mysql_select_db ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
mysql_close ()
