PHP留言板项目之七 —— 7.编辑留言
编辑留言 edit.php 代码如下所示：
<?php
require('./db.php');
//地址栏获取id
$id = $_GET['id'];
if(empty($_POST)) {
//获取原留言内容
$sql = "select * from guestbook where id=$id";
$rs = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($rs);
print_r($row);
//exit();
require('./edit.html');
} else {
$sql = "update guestbook set
nickname='$_POST[nickname]',txtTitle='$_POST[txtTitle]',
txtContent='$_POST[txtContent]',addtime='$_POST[addtime]'
where id=$id";
if(!mysqli_query($conn,$sql)) {
echo '修改失败';
require('./edit.html');
} else {
//echo '修改成功';
require('./list.php');
}
}
?>编辑页面edit.html，代码如下所示：
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>修改留言</title> <link rel="stylesheet" type="text/css" href="./css/bootstrap.min.css"> <script type="text/javascript" src="./js/bootstrap.bundle.min.js"></script> </head> <body> <h1>修改留言</h1> <form action="" method="post" > <div class="mb-3"> <label for="nickname" class="form-label">昵称</label> <input type="text" name="nickname" class="form-control" id="nickname" value="<?php echo $row['nickname'] ?>" > </div> <div class="mb-3"> <label for="txtTitle" class="form-label">留言标题</label> <input type="text" name="txtTitle" class="form-control" id="txtTitle" value="<?php echo $row['txtTitle'];?>" > </div> <div class="mb-3"> <label for="txtContent" class="form-label">留言内容</label> <textarea name="txtContent" class="form-control" id="txtContent" rows="3"><?php echo $row['txtContent'];?> </textarea> </div> <div class="mb-3"> <label for="addtime" class="form-label">添加时间</label> <input type="date" name="addtime" class="form-control" id="addtime" value="<?php echo $row['addtime'];?>"> </div> <button type="submit" class="btn btn-primary">修改提交</button> </form> </body> </html>
预览，如图所示：
