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

Continuing Learning

new file

<?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>

submit Reset Code

Automatic operation

PHP development article publishing system backend article modification page

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]