PHP development article publishing system backend article modification page
The approximate layout of the page is as follows:
Layout introduction:
Modifying the layout of the page is the same as adding a page
The code is as follows:
<?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>The main logic of the php code is as follows:
The modification page mainly receives the id number passed by the modification button in the management page. Query the database by id and retrieve the data of the current article
Output each item in the data in the output area
Added A hidden field<input type="hidden">, used to pass the ID number of the currently modified article to the article modification handler
<?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>
