, . , , , (). , MySQL. [9]
(, Sybase, Oracle . .), MySQL . , MySQL, - MySQL. MySQL . [10]
, :
;
3.1 -
SQL .
CREATE TABLE IF NOT EXISTS `nastroiki` (
`id` int(2) NOT NULL AUTO_INCREMENT,
`page` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`meta_d` varchar(255) NOT NULL,
`meta_k` varchar(255) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8;
;
3.2 -
SQL .
CREATE TABLE IF NOT EXISTS `uslugi` (/* */
`id` int(4) NOT NULL AUTO_INCREMENT, /* */
`title` varchar(255) NOT NULL, /* */
`description` text NOT NULL, /* */
`text` text NOT NULL, /* */
`author` varchar(255) NOT NULL, /* */
PRIMARY KEY (`id`) /* */
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8;
;
3.3 -
SQL .
CREATE TABLE IF NOT EXISTS `vacantion` (/* */
`id` int(4) NOT NULL AUTO_INCREMENT, /* */
`title` varchar(255) NOT NULL, /* */
`date` date NOT NULL, /* */
`description` text NOT NULL, /* */
`text` text NOT NULL, /* */
`author` varchar(255) NOT NULL, /* */
PRIMARY KEY (`id`)) /* */
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=10;
. . , , , .
. mysql, , . , .
|
|
:
<? echo $myrow['meta_d'];?> ;
<? echo $myrow['meta_k'];?> ;
<? echo $myrow['title'];?> ;
<?php include ("blocks/bd.php");?> ;
<? include("blocks/header.php");?> ;
<? include("blocks/left.php");?> +;
<? include("blocks/footer.php");?> ( );
<? echo $myrow['author'];?> ;
<? echo $myrow['date'];?> ;
<? echo $myrow['text'];?> ;
<?mysql_query();?> ;
<?mysql_fetch_array();?> ;
<?if isset();?> ;
<?php $db = mysql_connect ("localhost", "root", ""); ;
mysql_select_db ("zerov_prod",$db);?> ;
<? printf?> ( echo).
.[11] , , , , , , , -; , , . , , .[12]
, . , ,
:
;
;
;
;
;
;
.
, left, , , .
.
4.1 -
. , .
4.2 -
, , . , -, .
|
|
4.3 -
. , , . , . , .
-, 13 . .
4.4 -
, , . , .
4.5 -
, .
4.6 -
, . , . , , , , .
, . , , . , , , , .
4.7 -
, , , . , , , , .
: , . CMS , , , .
, - Zerov Productions. , . php+mysql , . , , , .
, , , , .
, . -.
|
|
, , , -, , Zerov Production .