Delete Records with using jQuery and Ajax.

Index.php

<ol class="update">

<?php

$sql="select * from updates order by msg_id desc";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result))
{
$message=stripslashes($row["message"]);
$msg_id=$row["msg_id"]; 

?>

<li>

<?php echo $message; ?>
<a href="#" id="<?php echo $msg_id; ?>" class="delete_button">X</a>

</li>

<?php

}

?>

</ol>

 

jQuery code

 

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(function() {
$(".delete_button").click(function() {
var id = $(this).attr("id");
var dataString = 'id='+ id ;
var parent = $(this).parent();

$.ajax({
type: "POST",
url: "deleteajax.php",
data: dataString,
cache: false,

success: function()
{
if(id % 2)

{

parent.fadeOut('slow', function() {$(this).remove();});

}

else

{

parent.slideUp('slow', function() {$(this).remove();});

}

}
});

return false;
});
});
</script>

 

deleteajax.php

<?php
if($_POST['id'])

{

$id=$_POST['id'];
$id = mysql_escape_String($id);
$sql = "delete from updates where msg_id='$id'";
mysql_query( $sql);
}
?>