while($c=mysql_fetch_array($result)){
echo
$c['id']." ".$c['title']." "."<br
/>".
$c['content']."<br />";
echo "<a href='update.php?id=".$c['id']."'>编辑
</a>"." "."<a
href='act.php?id=".
$c['id']."&act=delete'>删除</a>";
echo "<hr>";
}
mysql_free_result($result);
mysql_close();
?>
Act.php 后台文件
<?php
$act=$_GET['act'];
$id=$_POST['id'];
$id1=$_GET['id'];
$title=$_POST['title'];
$content=$_POST['content'];
include ('db.php');
$db=new Db;
switch($act){
case 'add':
$sql="insert
into
demo1.table
(title,content)
values
('$title','$content')";
$db->del($sql);
break;
case 'update':
$sql="update demo1.table set title= '$title' , content= '$content'
where id=$id";
$db->del($sql);
break;
case 'delete':
$sql="delete from demo1.table where id=$id1";
$db->del($sql);
break;
}