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

}

?>