PHP开发文章发布系统之后台文章修改页面
页面的大概布局如下：
布局介绍:
修改页面的布局和添加页面是一样的
代码如下：
<?php
require_once("../connect.php");
$id=$_GET['id'];
$SQL="SELECT * FROM article WHERE id=$id";
$query = mysqli_query($conn,$SQL);
$data = mysqli_fetch_assoc($query);
?>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
<meta name="format-detection" content="telephone=no" />
<title>发布文章</title>
<meta charset="utf-8" />
<style>
.box{
background-color:#f0f0f0;
}
.title{
background-color:#f0f0f0;
width:400px;
height:100px;
border-bottom:1px solid black;
}
.menu{
margin:-25px 0px 1px 319px;
width:80px;
}
.middle{
border-bottom:1px solid black;
}
</style>
</head>
<body>
<div class="box">
<div class="title">
<h1>后台管理系统</h1>
<div class="menu">
<a href="admin_add.php">发布文章</a><br/>
<a href="admin_manage.php">管理文章</a>
</div>
</div>
<div class="middle">
<form method="post" action="admin_modify_handle.php">
<input type="hidden" name="id" value="<?php echo $data['id']?>" />
<div><h2>修改文章</h2></div>
<div>标题:<input type="text" name="title" value="<?php echo $data['title']; ?>"/></div><br/>
<div>作者:<input type="text" name="author" value="<?php echo $data['author']; ?>"/></div><br/>
<div>简介:<br/><textarea name="description" cols="50" rows="4"><?php echo $data['description']; ?></textarea></div><br/>
<div>内容:<br/><textarea name="content" cols="50" rows="9" ><?php echo $data['content']; ?></textarea></div><br/>
<div><input type="submit" name="button" value="提交" /></div><br/>
</form>
</div>
<br/><div class="bottom">欢迎联系我们<a href="http://www.php.cn">php中文网</a></div>
</div>
</body>
</html>php代码主要逻辑如下：
修改页面主要是接收管理页面里修改按钮传递过来的id号，通过id查询数据库，取出当前这条文章的数据
在输出区域将数据里面的每一项输出出来
增加了一个隐藏域<input type="hidden">,用于将当前修改文章的id号传递给文章修改处理程序
<?php
require_once("../connect.php");
$id=$_GET['id'];
$sql="select * from article where id=$id";
$query = mysqli_query($conn,$sql);
$data = mysqli_fetch_assoc($query);
?>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
<meta name="format-detection" content="telephone=no" />
<title>发布文章</title>
<meta charset="utf-8" />
<style>
.box{
background-color:#f0f0f0;
}
.title{
background-color:#f0f0f0;
width:400px;
height:100px;
border-bottom:1px solid black;
}
.menu{
margin:-25px 0px 1px 319px;
width:80px;
}
.middle{
border-bottom:1px solid black;
}
</style>
</head>
<body>
<div class="box">
<div class="title">
<h1>后台管理系统</h1>
<div class="menu">
<a href="admin_add.php">发布文章</a><br/>
<a href="admin_manage.php">管理文章</a>
</div>
</div>
<div class="middle">
<form method="post" action="admin_modify_handle.php">
<input type="hidden" name="id" value="<?php echo $data['id']?>" />
<div><h2>修改文章</h2></div>
<div>标题:<input type="text" name="title" value="<?php echo $data['title']; ?>"/></div><br/>
<div>作者:<input type="text" name="author" value="<?php echo $data['author']; ?>"/></div><br/>
<div>简介:<br/><textarea name="description" cols="50" rows="4"><?php echo $data['description']; ?></textarea></div><br/>
<div>内容:<br/><textarea name="content" cols="50" rows="9" ><?php echo $data['content']; ?></textarea></div><br/>
<div><input type="submit" name="button" value="提交" /></div><br/>
</form>
</div>
<br/><div class="bottom">欢迎联系我们<a href="http://www.php.cn">php中文网</a></div>
</div>
</body>
</html>
