php开发留言板的CRUD(增，删，改，查)操作

create database form; use form; CREATE TABLE `message` (
`id` tinyint(1) NOT NULL auto_increment,
`user` varchar(25) NOT NULL,
`title` varchar(50) NOT NULL,
`content` tinytext NOT NULL,
`lastdate` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

$conn = @ mysql_connect("localhost","root","") or die("数据库链接错误");
mysql_select_db("form",$conn);
mysql_query("set names 'gbk'");
?>

include 'conn.php';
if($_POST['submit']){
$sql="INSERT INTO message(id,user,title,content,lastdate) VALUES (NULL,'$_POST[user]','$_POST[title]','$_POST[content]',now())";
mysql_query($sql); //页面跳转，实现方式为javascript
$url = "list.php";
echo "";
}
?>

用户：

标题：

内容：<br /> <BR><INPUT TYPE="submit" name="submit" value="add" /></FORM> <BR></div> <BR>list.php <BR><div class="codetitle"><span></U> 代码如下:</div><div class="codebody" id="code74818"> <BR><?php <BR>include 'conn.php'; <BR>?> <BR><?php <BR>echo "<div align='center'>继续添加</div>"; <BR>?> <BR><table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef"> <BR><?php <BR>$sql="select * from message order by id"; <BR>$query=mysql_query($sql); <BR>while ($row=mysql_fetch_array($query)){ <BR>?> <tr bgcolor="#eff3ff"> <BR><td>标题：<font color="red"><?=$row[title]?></font> 用户：<font color="red"><?=$row[user] ?></font><div align="right">">编辑|">删除</div></td> <BR></tr> <BR><tr bgColor="#ffffff"> <BR><td>内容：<?=$row[content]?></td> <BR></tr> <BR><tr bgColor="#ffffff"> <BR><td><div align="right">发表日期：<?=$row[lastdate]?></div></td> <BR></tr> <BR><?php }?> <BR></table> <BR></div> <BR>delete.php <BR><div class="codetitle"><span></U> 代码如下:</div><div class="codebody" id="code56255"> <BR><?php <BR>include 'conn.php'; <BR>$id = $_GET['id']; <BR>$query="delete from message where id=".$id; <BR>mysql_query($query); <BR>?> <BR><?php <BR>//页面跳转，实现方式为javascript <BR>$url = "list.php"; <BR>echo "<script language='javascript' type='text/javascript'>"; <BR>echo "window.location.href='$url'"; <BR>echo "</script>"; <BR>?> <BR></div> <BR>preEdit.php <BR><div class="codetitle"><span></U> 代码如下:</div><div class="codebody" id="code38501"> <BR><?php <BR>include 'conn.php'; <BR>$id=$_GET[id]; <BR>$query="SELECT * FROM message WHERE id =".$id; <BR>$result=mysql_query($query); <BR>while ($rs=mysql_fetch_array($result)){ <BR>?> <BR><FORM METHOD="POST" ACTION="postEdit.php"> <BR><input type="hidden" name="id" value="<?=$rs[id]?>"> <BR>用户：<INPUT TYPE="text" NAME="user" value="<?=$rs[user]?>"/><br /> <BR>标题：<INPUT TYPE="text" NAME="title" value="<?=$rs[title]?>"/><br /> <BR>内容：<TEXTAREA NAME="content" ROWS="8" COLS="30"><?=$rs[content]?>

include 'conn.php';
$query="update message set user='$_POST[user]',title='$_POST[title]',content='$_POST[content]' where id='$_POST[id]'";
mysql_query($query);
?>
//页面跳转，实现方式为javascript
$url = "list.php";
echo "";
?>