简单的CMS实例

//连接数据库
$dblink=mysql_connect("localhost","username","password");
mysql_select_db('cms',$dblink);

//读取本页的内容
$result = mysql_query('select * from `pages` where id='.$_GET['id']);
$rs = mysql_fetch_array($result);
echo $rs['content'];

制作后台

数据结构:
数据库: cms 数据表: pages
三个字段: ` id`   `menu`   `content`

CREATE TABLE `cms`.`pages` ( `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`menu` VARCHAR( 20 ) NOT NULL ,
`content` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) ,
INDEX ( `id` ) ) ENGINE = MYISAM ;

 

1.添加页:
<form action="page.php?action=add" method="post">
<input type="text" name="menu" size="50" value=""/>
<textarea name="content" cols="30" rows="5"></textarea>
<input type="submit" value="add" />
</form>

<?
//page.php
if ($_GET['action']=='add'){
insert into `pages` (`menu`,`content`）values（$_POST['menu'],$_POST['content']);
mysql_query($query);
}
?>

2.修改页:

<?
$result = mysql_query('select * from `pages` where id='.$_GET['id']);
$rs = mysql_fetch_array($result);
?>
<form action="page.php?action=edit&id=<? echo $_GET['id']) ?>" method="post">
<input type="text" name="menu" size="50" value="<? echo $rs['menu']?>"/>
<textarea name="content" cols="30" rows="5"><? echo $rs['content']?></textarea>
<input type="submit" value="update" />
</form>

<?
//page.php
if ($_GET['action']=='edit'){
$query='update `pages` set `menu`="'.$POST['menu'].'", `content`="'.$POST[content].'" where `id`='.$_GET['id'];
mysql_query($query);
}
?>

 

 

3.删除页
<?
//page.php?action=del&id=1
if ($_GET['action']=='del'){
$query='delete from `pages` where `id` = '.$_GET['id'];
mysql_query($query);
}
?>

XHTML - CSS