PHP development article publishing system backend article modification handler

The article modification processing program flow chart is roughly as follows:

##The code is as follows

<?php 
	require_once('../connect.php');
	$id = $_POST['id'];
	$title = $_POST['title'];
	$author = $_POST['author'];
	$description = $_POST['description'];
	$content = $_POST['content'];
	$dateline =  time();
	$sql = "update article set title='$title',author='$author',description='$description',content='$content',dateline=$dateline where id=$id";
	if(mysqli_query($conn,$sql)){
		echo "<script>alert('修改文章成功');window.location.href='admin_manage.php';</script>";
	}else{
		echo "<script>alert('修改文章失败');window.location.href='aadmin_manage.php';</script>";
	}
?>

# Code comments

Connect to the database
Get the value passed by the post method of modifying the page, and the time is obtained by timestamp
Execute the modification statement. If it succeeds, it will prompt that the modification is successful and jump to the background article management page. If it fails, it will prompt that the article modification failed and jump to the article management page.

Next Section