Most Popular Tutorials
-
What is Ajax
-
How Ajax Work in Php
-
ajax() and load() function
-
AJAX get() and post() Method
-
$.ajax() function
-
Get data using Ajax call
-
Load div content on button click
-
Insert Data in mysql Database
-
Delete Record
-
Fetch Data from database
-
User Registration form
-
ContactUs form
-
Change Password
-
ajax search
-
insert data usign Serialize
-
Insert Data without serialize function
-
User Check Availability
-
Star rating
-
Pin check availability
-
Dynamically Add / Remove input fields in PHP with Jquery Ajax
-
clear form field after submitting form
-
Loader show / hide
-
Javascript and Ajax function
-
Ajax Programs
-
Success and Failure message
-
getJSON Function in ajax
Most Popular Tutorials :-
Simply Easy Learning at Your Fingertips. Click Tutorials Menu to view More Tutorial List
How to delete data from table using ajax with php and mysql?
Delete Data using Ajax
Table
File name : index.php
CREATE TABLE `posts` (
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
config.php
<?php
$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "tutorial"; /* Database name */
$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "tutorial"; /* Database name */
$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
}
File name : html page
<div class='container'>
<table border='1' >
<tr style='background: whitesmoke;'>
<th>S.no</th>
<th>Title</th>
<th>Operation</th>
</tr>
<?php
$query = "SELECT * FROM posts";
$result = mysqli_query($con,$query);
$count = 1;
while($row = mysqli_fetch_array($result) ){
$id = $row['id'];
$title = $row['title'];
$link = $row['link'];
?>
<tr>
<td align='center'><?php echo $count; ?></td>
<td><a href='<?php echo $link; ?>'><?php echo $title; ?></a></td>
<td align='center'>
<span class='delete' id='del_<?php echo $id; ?>'>Delete</span>
</td>
</tr>
<?php
$count++;
}
?>
</table>
</div>
<table border='1' >
<tr style='background: whitesmoke;'>
<th>S.no</th>
<th>Title</th>
<th>Operation</th>
</tr>
<?php
$query = "SELECT * FROM posts";
$result = mysqli_query($con,$query);
$count = 1;
while($row = mysqli_fetch_array($result) ){
$id = $row['id'];
$title = $row['title'];
$link = $row['link'];
?>
<tr>
<td align='center'><?php echo $count; ?></td>
<td><a href='<?php echo $link; ?>'><?php echo $title; ?></a></td>
<td align='center'>
<span class='delete' id='del_<?php echo $id; ?>'>Delete</span>
</td>
</tr>
<?php
$count++;
}
?>
</table>
</div>
File name : remove.php
<?php
include "config.php";
$id = $_POST['id'];
if($id > 0){
// Check record exists
$checkRecord = mysqli_query($con,"SELECT * FROM posts WHERE id=".$id);
$totalrows = mysqli_num_rows($checkRecord);
if($totalrows > 0){
// Delete record
$query = "DELETE FROM posts WHERE id=".$id;
mysqli_query($con,$query);
echo 1;
exit;
}
}
echo 0;
exit;
include "config.php";
$id = $_POST['id'];
if($id > 0){
// Check record exists
$checkRecord = mysqli_query($con,"SELECT * FROM posts WHERE id=".$id);
$totalrows = mysqli_num_rows($checkRecord);
if($totalrows > 0){
// Delete record
$query = "DELETE FROM posts WHERE id=".$id;
mysqli_query($con,$query);
echo 1;
exit;
}
}
echo 0;
exit;
Ajax function
File name :
$(document).ready(function(){
// Delete
$('.delete').click(function(){
var el = this;
var id = this.id;
var splitid = id.split("_");
// Delete id
var deleteid = splitid[1];
// AJAX Request
$.ajax({
url: 'remove.php',
type: 'POST',
data: { id:deleteid },
success: function(response){
if(response == 1){
// Remove row from HTML Table
$(el).closest('tr').css('background','tomato');
$(el).closest('tr').fadeOut(800,function(){
$(this).remove();
});
}else{
alert('Invalid ID.');
}
}
});
});
});
// Delete
$('.delete').click(function(){
var el = this;
var id = this.id;
var splitid = id.split("_");
// Delete id
var deleteid = splitid[1];
// AJAX Request
$.ajax({
url: 'remove.php',
type: 'POST',
data: { id:deleteid },
success: function(response){
if(response == 1){
// Remove row from HTML Table
$(el).closest('tr').css('background','tomato');
$(el).closest('tr').fadeOut(800,function(){
$(this).remove();
});
}else{
alert('Invalid ID.');
}
}
});
});
});
Previous Next
Trending Tutorials
Review & Rating
0.0 / 5
0 Review
5
(0)
4
(0)
3
(0)
2
(0)
1
(0)
Write Review Here
Most Popular Tutorials
-
Fetch Data from database
-
Loader show / hide
-
Change Password
-
Star rating
-
getJSON Function in ajax
-
AJAX get() and post() Method
-
Pin check availability
-
ContactUs form
-
Javascript and Ajax function
-
Success and Failure message
-
Load div content on button click
-
insert data usign Serialize
-
Ajax Programs
-
User Registration form
-
$.ajax() function
-
Delete Record
-
Insert Data in mysql Database
-
How Ajax Work in Php
-
ajax search
-
ajax() and load() function
Important Link
-
How to manage Session in php Tutorials.
More ....... -
upcomming codeigniter and angular js tutorials.
Click here to see More ...
