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>";
}
?>