Delete a Record with animation effect using jQuery and Ajax (Updated)

In this tutorials i will explain the easy steps to Delete a Record with animation effect using jQuery and Ajax. I like Twitter API very much, it’s clean and faster. So i prepared this jQuery tutorial delete action with out refreshing page.

After this tutorials you will be able to create a web application which will delete records from mysql table like animation using jQuery and PHP, so keep close attention in this post and you can also download the complete script of this tutorial.

Ajax delete

Create Database Table Code

Open PHPMyAdmin in your browser and select a database. Click on SQL tabs, Copy paste below snippet and execute the code. Now you have successfully created the mysql table named “updates” and inserted some dummy data.

--
-- Table structure for table `updates`
--

CREATE TABLE IF NOT EXISTS `updates` (
  `ms_id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text,
  PRIMARY KEY (`ms_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`ms_id`, `message`) VALUES
(2, 'Delete a Record with animation effect using jQuery and Ajax'),
(3, 'Twitter Like Parsing URLs with JavaScript'),
(4, 'Delete a Record with animation effect using jQuery and Ajax');

-- Table structure for table `updates`

CREATE TABLE IF NOT EXISTS `updates` (

`ms_id` int(11) NOT NULL AUTO_INCREMENT,

`message` text,

PRIMARY KEY (`ms_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- Dumping data for table `updates`

INSERT INTO `updates` (`ms_id`, `message`) VALUES

(2, 'Delete a Record with animation effect using jQuery and Ajax'),

(3, 'Twitter Like Parsing URLs with JavaScript'),

(4, 'Delete a Record with animation effect using jQuery and Ajax');

Dbconfig.php code

Now create a folder in your www folder. Create dbconfig.php file and add below code to connect your code with mysql database.

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "post";

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");

?>

<?php

$mysql_hostname = "localhost";

$mysql_user = "root";

$mysql_password = "";

$mysql_database = "post";

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");

mysql_select_db($mysql_database, $bd) or die("Could not select database");

Index.php (user interface page)

Here Displaying records form database using while loop. Delete button included in anchor tag attribute id=< ?php echo $row['ms_id']; ?>. This we are passing to delete.php page.

<body> 
<form action="" method="post">
<span class="what">What are you doing?</span>
<textarea  =""  cols="55" id="update" maxlength="145" name="update" rows="3"></textarea>
<input type="submit" value=" Update "  class="update_button" />
</form>
<?php
include("dbconfig.php");
$sql="select * from updates order by ms_id desc"; 
$result = mysql_query($sql); 
while($row=mysql_fetch_array($result)) 
{ 
$message=stripslashes($row["message"]); 
?>
<tr><td><?php echo $message; ?></td><td><a href="#" id="<?php echo $row["ms_id"]; ?>" class="delbutton"><img src="trash.png" alt="delete"/></a> </td></tr>
<?php
}
?>

</body>

<body>

<span class="what">What are you doing?</span>

</form>

<?php

include("dbconfig.php");

$sql="select * from updates order by ms_id desc";

$result = mysql_query($sql);

while($row=mysql_fetch_array($result))

{

$message=stripslashes($row["message"]);

<tr><td><?php echo $message; ?></td><td><a href="#" id="<?php echo $row["ms_id"]; ?>" class="delbutton"><img src="trash.png" alt="delete"/></a> </td></tr>

<?php

}

</body>

Delete.php

<?php
include("dbconfig.php");
if($_POST['id'])
{
$id=$_POST['id'];

$sql = "delete from {$prefix}updates where ms_id='$id'";
mysql_query( $sql);
}
?>

<?php

include("dbconfig.php");

if($_POST['id'])

{

$id=$_POST['id'];

$sql = "delete from {$prefix}updates where ms_id='$id'";

mysql_query( $sql);

}

Ajax with Jquery code

<head>
<script type="text/javascript" src="js/jquery.js"></script>

<script type="text/javascript" 
$(function() {

$(".delbutton").click(function(){
var del_id = element.attr("id");
var info = 'id=' + del_id;
if(confirm("Sure you want to delete this update? There is NO undo!"))
{
$.ajax({
type: "POST",
url: "delete.php",
data: info,
success: function(){
}
});
$(this).parents(".record").animate({ backgroundColor: "#fbc7c7" }, "fast")
.animate({ opacity: "hide" }, "slow");
}
return false;
});
});
</script>

</head>

<head>

$(function() {

$(".delbutton").click(function(){

var del_id = element.attr("id");

var info = 'id=' + del_id;

if(confirm("Sure you want to delete this update? There is NO undo!"))

{

$.ajax({

type: "POST",

url: "delete.php",

data: info,

success: function(){

}

});

$(this).parents(".record").animate({ backgroundColor: "#fbc7c7" }, "fast")

.animate({ opacity: "hide" }, "slow");

}

return false;

});

</script>

</head>

Do like & share it with your friends on social media. Don’t forget to follow us on Facebook and Twitter to learn cool tutorials.

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

Delete a Record with animation effect using jQuery and Ajax (Updated)

Create Database Table Code

Dbconfig.php code

Index.php (user interface page)

Delete.php

Recommended Posts:

webmentor