Delete confirmation Records jquery ajax php

Delete confirmation Records jquery ajax php

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Delete confirmation Records jquery ajax</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>
<script type="text/javascript">
$(function() {
$(".delbutton").click(function(){
 //Save the link in a variable called element
 var element = $(this);
 //Find the id of the link that was clicked
 var del_id = element.attr("id");
 //Built a url to send
 var info = 'id=' + del_id;
 if(confirm("Sure you want to delete this records? There is NO undo!")) {
    $.ajax({
     type: "GET",
     url: "deleterec.php",
     data: info,
     success: function(data){ 
     alert(data);
     }
  });
    $(this).parents(".record").animate({ backgroundColor: "#fbc7c7" }, "fast")
    .animate({ opacity: "hide" }, "slow");
  }
 return false;
});
});
</script>
</head>
<body>
<table id="box-table-a" summary="Employee Pay Sheet">
 <thead>
  <tr>
   <th scope="col" width="60">Photo</th>
   <th scope="col">Employee</th>
   <th scope="col">Bonus</th>
   <th scope="col" width="40">Action</th>
  </tr>
 </thead>
 <tbody>
<?php 
include("dbcon.php");
$query = $conn->query("SELECT * FROM updates order by msg_id desc");
while ($result = $query ->fetch_object()) {
 $fullname=stripslashes($result->fullname); 
?>
  <tr class="record">
   <td><img src="img/<?php echo $result->photo; ?>" width="50" height="50"/></td>
   <td><?php echo $fullname; ?></td>
   <td>$50</td>
   <td align="center"><a href="#" id="<?php echo $result->msg_id; ?>" class="delbutton"><img src="img/delete.png" style="background:#FFFFFF;width:15px;"/></a></td>
  </tr>
<?php } ?>  
 </tbody>
</table>
<style>
#box-table-a {
    font-family: lucida sans unicode,lucida grande,Sans-Serif;
    font-size: 12px;
    width: 480px;
    text-align: left;
    border-collapse: collapse;
    margin: 20px;
}
.tr, tr {
    border-bottom: 1px solid #ddd;
}
#box-table-a th {
    font-size: 13px;
    font-weight: 400;
    background: #b9c9fe;
    border-top: 4px solid #aabcfe;
    border-bottom: 1px solid #fff;
    color: #039;
    padding: 8px;
}
#box-table-a td {
    background: #e8edff;
    border-bottom: 1px solid #fff;
    color: #669;
    border-top: 1px solid transparent;
    padding: 8px;
}
#box-table-a tr:hover td{background:#d0dafd;color:#339}
</style> 
</body>
</html>

//dbcon.php
<?php
$conn = new mysqli('localhost','root','','testingdb');
if ($conn->connect_error) {
    die('Error : ('. $conn->connect_errno .') '. $conn->connect_error);
}
?>

//deleterec.php
<?php
include("dbcon.php");
if($_GET['id'])
{
 $id=$_GET['id'];
 $sql = "delete from updates where msg_id='$id'";
 if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully";
 } else {
  echo "Error deleting record: " . $conn->error;
 }
}
?>

Labels: