PHP develops simple news release system and news list page deletion function module
Introduction to this section This section introduces how to delete news from the news list page and delete the record of the news in the database.
We still cannot do without operating the database. Here we need to use delete: delete the data in the data table
Idea:
By deleting Use the id field in the new table of the data path table to delete a news item
The SQL statement is:
<?php $sql = "delete from new where id = '$id'"; ?>
The complete delete.php file that implements the deletion function:
<?php
header("content-type:text/html;charset=utf8");
$link = mysqli_connect('localhost','root','root','test');
mysqli_set_charset($link, "utf8");
if (!$link) {
die("連接失敗:".mysqli_connect_error());
}
$id = $_GET['id'];
$sql = "delete from new where id = '$id'";
//echo $sql;
$rel = mysqli_query($link,$sql);
if($rel){
echo "<script>alert('刪除成功');window.location.href='list.php'</script>";
}else{
echo "<script>alert('刪除失敗');window.location.href='list.php'</script>";
}
?>
