HOW TO DELETE DATA IN THE DATABASE USING PHP WITH AJAX

Hey guys, Today we are learning MYSQLI DELETE QUERY execute in the database using PHP with AJAX. (How to delete data in the database using PHP with AJAX)

1. HTML Source Code(Index.php)

<table border="1" cellspacing="10">
<tr>
<th>S. N.</th>
<th>Name</th>
<th>Email Id</th>
<th>Action.</th>
</tr>
<?php
$conn=mysqli_connect("localhost", "root", "", "testproject");
$query=mysqli_query($conn, "SELECT * FROM userdetails"); while($rows=mysqli_fetch_array($query)){
?>
<tr>
<td><?php echo $rows['id']; ?></td>
<td><?php echo $rows['name']; ?></td>
<td><?php echo $rows['email']; ?></td>
<td><a href="#" class="del" id=<?php echo $rows['id']; ?>">Delete</a></td>
</tr>
<?php } ?>
</table>

<script>
$(function () {
$('.del').click(function () {
var delid=$(this).attr("id"); var interval = 700;
$.ajax({
type: 'post',
url: 'delete.php,
data: { delid:delid },
success: function (data) {
if(data=='success'){
swal("Updated", "Password has been successfully updated", "success");
setTimeout(function() {
location.reload();
}, interval);
}
else{
swal("Updated Failed", "Password has been updated failed", "error");
}
}
});
return false;
});
});
</script>

2. PHP Source Code(delete.php)

<?php
$conn=mysqli_connect("localhost", "root", "", "testproject");
$id=$_GET["delid"];
$query=mysqli_query($conn, "DELETE FROM userdetails WHERE id='$id'");
if(query==true){
echo"success";
}
else{
echo"Failed";
}
?>