. , , .
:
-;
, ;
;
, .
:
;
() web-;
;
: SQL, HTML PHP.
:
;
web- .
-. - , .
MySQL
MySQL - . MySQL - "" . MySQL - SQL- web-.
, . .
SQL
INTEGER INTEGER INT. . 4 .
FLOAT (4 ). 1.18 10 38 3.4 10 .
CHAR CHAR . CHAR , , CHAR(50) , . 255 . , , , . .
VARCHAR VARCHAR . , VARCHAR , , VARCHAR(30) , , .
, . , .
|
|
TEXT BLOB TEXT , . BLOB . , BLOB , TEXT .
DATE (--)
TIME (::)
.
, , . :
CREATE DATABASE test;
"test".
, , . :
USE test;
"test" , . . :
CREATE TABLE _ ( );
, CREATE TABLE ( ), , . , .
. , PRIARY ( ) ( ), .
NULL NOT NULL. , NULL ( (NOT NULL)). DEFAULT, .
AUTO_INCREMENT , . 1. , AUTO_INCREMENT . AUTO_INCREMENT .
. 1 shop : , , , . 2 users : , , , .
1 shop
2 users
INSERT INTO _ (1, 2,...) VALUES('1','2',...);
. , . , , VALUES , . , , . 3 :
|
|
3
, . MySQL : . , :
SELECT * FROM _;
mysql> SELECT * FROM developers;
+-------------+-----------------------+----------------+
| name | email | job |
+-------------+-----------------------+----------------+
| Joe Smith | [email protected] | toolchain |
| John Doe | [email protected] | portage |
| Chris White | [email protected] | documentation |
| Sam Smith | [email protected] | amd64 |
| Jane Doe | NULL | Outsourced job |
+-------------+-----------------------+----------------+
SELECT * FROM _ WHERE =;
mysql> SELECT * FROM developers WHERE name = 'Chris White';
+-------------+-----------------------+---------------+
| name | email | job |
+-------------+-----------------------+---------------+
| Chris White | [email protected] | documentation |
+-------------+-----------------------+---------------+
SELECT 1,2,3 FROM _ [ WHERE =];
mysql> SELECT email,job FROM developers WHERE name = 'Chris White';
+-----------------------+---------------+
| email | job |
+-----------------------+---------------+
| [email protected] | documentation |
+-----------------------+---------------+
MySQL - .
HTML
HyperText Markup Language (HTML) , WEB. HTML- WEB-. HTML, WEB- HTML . HTML , , .
HTML . , , -, , HTML. . HTML PHP .
- 1 index.html. . 25% 75% . topframe.php, main.php.
1 index.html
, . , 2 -.
2 -
HTML
HTML- PHP . Web- <?php, , , , . PHP, , , ?>. 4 topframe.php , .
|
|
, HTML . - , HTML . , HTML PHP .php.
, . .
, MySQL. 4.0 :
mysql_connect ([string server [, string username [, string password [, bool new_link]]]]).
MySQL , FALSE .
mysql_connect() MySQL-. : server = 'localhost:3306', username = - , password = .
.
bool mysql_select_db (string database_name [, resource link_identifier])
TRUE , FALSE .
mysql_select_db() , .
3 dbconnect.php.
3 dbconnect.php
, ( - ), - . . . . , . , , . - - . - SQL-, . ( ) - . , . , , , . , , - .
PHP- ? . 128 . PHP- , - , . , , (), - .
, PHP ( ) . PHP , .
:
bool session_start (void).
session_start() ( session id, GET- ).
- 2 - - 4 topframe.php.
|
|
4 topframe.php
:
bool session_destroy (void)
session_destroy() , .
int header (string string [, bool replace])
header() HTTP-.
, 5 logout.php - main.php.
5 logout.php
- 2 - 6 main.php.
6 main.php
: , . :
action = login.php
, login.php, login pass .
7 login.php