search
  • Sign In
  • Sign Up
Password reset successful

Follow the proiects vou are interested in andi aet the latestnews about them taster

PHP development student management system to delete student information

Create

We made a delete link on the index.php page

<a href='javascript:void(0);' onclick='doDel({$ row['id']})'>Delete</a>

Also used JS warning box to confirm deletion

<script>
function doDel(id) {
if(confirm('Confirm deletion?')) {
window.location='action.php?action=del&id='+id;
}
}
</script>

Delete information

Link to the database and delete the related information passed from the delete page The ID information

0.jpg

The code is as follows

<?php
header("content-type:text/html;charset=utf8");
$id = $_GET['id'];
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
$sql = "delete from stu where id='$id'";
$rw = mysqli_query($conn,$sql);
if ($rw > 0){
    echo "<script>alter('删除成功');</script>";
}else{
    echo "<script>alter('删除失败');</script>";
}
header('Location: index.php');
?>

In this way, our deletion function is completed. We will simplify and integrate all our previous codes


new file
<?php header("content-type:text/html;charset=utf8"); $conn=mysqli_connect("localhost","root","root","study"); mysqli_set_charset($conn,"utf8"); $id = $_GET['id']; $sql = "delete from stu where id='$id'"; $rw = mysqli_query($conn,$sql); if ($rw > 0){ echo "<script>alter('删除成功');</script>"; }else{ echo "<script>alter('删除失败');</script>"; } header('Location: index.php'); ?>
Reset Code
Automatic operation
submit
Preview Clear