PHP development...LOGIN

PHP development article publishing system backend article modification page

The approximate layout of the page is as follows:

文章文章修改.png

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

Next Section
<?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>
submitReset Code
ChapterCourseware