1.) Request
2.) Response
GET index.php HTTP/1.1.
host: localhost
HTTP index.php 200 OK
Date:
Server:
X-Powerer-By:
...
GET
POST
HEAD
PUT
DELETE
TRACE
OPTIONS
CONNECT
200 OK
301 Moved Permanently
400 Bad Request
404 Not Found
$_GET []
$_POST []
$_COOKIE []
$_SESSION []
setcookie ("name", "inhalt", time () + 3600);
md5 ("passwort");
<FORM ACTION="./form1.php" METHOD="GET">
<INPUT TYPE="password" NAME="password1"></INPUT>
<INPUT TYPE="submit"></INPUT>
</FORM>
session_start ()
session_destroy ()
session_id ()
CREATE DATABASE "abc"
DROP DATABASE "abc"
CREATE TABLE "abc" (name1 VARCHAR (32), name2 VARCHAR (32))
DROP TABLE "abc"
USE "abc"
SHOW DATABASES
SET PASSWORD
SELECT * FROM "abc"
SELECT * FROM "abc" JOIN "def"
SELECT * FROM "abc" WHERE abc.name1 = "xyz"
SELECT * FROM "abc" INNER JOIN "def" WHERE abc.name1 = def.name2
SELECT * FROM "abc" RIGHT JOIN "def" ON abc.name1 = def.name2
INSERT INTO "abc" VALUES ("001", "002");
INSERT INTO "abc" (name1, name2) VALUES ("001", "002");
BYTE, BOOLEAN, INT, SMALLINT, MEDIUMINT, BIGINT
FLOAT, DOUBLE, DECIMAL
CHAR, VARCHAR, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
BIT
TIME, DATE, DATETIME, TIMESTAMP
BLOB, LONGBLOB, TINYBLOB, MEDIUMBLOB
mysql_query ()
mysql_connect ()
mysql_close ()
mysql_errer ()
mysql_select_db ()
mysql_fetch_row ()
mysql_fetch_assoc ()
mysql_num_rows ()
mysql_num_fields ()
mysql_real_escape_string ()
=DURCHSCHNITT
=MAX
=MIN
=ANZAHL
=SUMMENPRODUKT