list.php修改下:
在你显示每个楼层的留言信息后面加上一行
<a href="del.php?id=<?php echo $row['id']; ?>">删除</a> <a href="update.php?id=<?php echo $row['id']; ?>">编辑</a>
然后建立del.php文件
<?php
if (isset($_GET['id'])) {
include_once(你建立mysql连接的那个php文件);
mysql_query('DELETE FROM `bbtliuyanban` WHERE `id` = \'' . $_GET['id'] . '\'');
}
就一句话,mysql_query执行删除语句就好了,重点是GET接收到传递来的ID值
建立update.php
<?php
include_once(你建立mysql连接的那个php文件);
if (!empty($_POST))
{
mysql_query("UPDATE `bbtliuyanban` SET `user` = '$_POST[user]', `title` = '$_POST[title]', `content` = '$_POST[content]' WHERE `id` = '$_POST[id]'");
}
if (isset($_GET['id']))
{
$result = mysql_query('SELECT * FROM `bbtliuyanban` WHERE `id` = \'' . $_GET['id'] . '\'');
$row = mysql_fetch_array($result);
?>
输出标单信息
<form action="update.php" method="POST"> <input type="hidden" name="id" value="<?php echo $row['id']; ?>" /> 标题:<input type="text" name="title" value="<?php echo $row['title']; ?>" /> 用户:<input type="text" name="user" value="<?php echo $row['user']; ?>" /> <textarea name="content"><?php echo $row['content']; ?></textarea> <input type="submit" /> </form> <?php } ?>