Codeigniter Tutorials

Home » Codeigniter »

Delete Data using ajax with confirmation message

File name : Delete_Record_Confirm.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Delete_Record_Confirm extends CI_Controller {
public function __construct() {
parent::__construct();
$this->load->database();
}

public function index()
{
$data['data'] = $this->db->get("items")->result();
$this->load->view('itemlist_view', $data);
}
public function delete($id)
{
$this->db->delete('items', array('id' => $id));
echo 'Deleted successfully.';
}
}

File name : itemlist_view.php

<!DOCTYPE html>
<html>
<head>
<title>codeigniter confirm before delete itsolutionstuff.com</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left">
<h2>codeigniter confirm before delete itsolutionstuff.com</h2>
</div>
</div>
</div>

<table class="table table-bordered">
<thead>
<tr>
<th>Title</th>
<th>Description</th>
<th width="220px">Action</th>
</tr>
</thead>
<tbody>
<?php foreach ($data as $item) { ?>
<tr id="<?php echo $item->id; ?>">
<td><?php echo $item->id; ?></td>
<td><?php echo $item->title; ?></td>
<td><?php echo $item->description; ?></td>
<td>
<button type="submit" class="btn btn-danger remove"> Delete</button>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>

<script type="text/javascript">
$(".remove").click(function(){
var id = $(this).parents("tr").attr("id");
//alert(id);

if(confirm('Are you sure to remove this record ?'))
{
$.ajax({
//url: '/item-list/'+id,
url: '<?php echo base_url();?>' + 'Delete_Record_Confirm/delete/' +id,
type: 'DELETE',
error: function() {
alert('Something is wrong');
},
success: function(data) {
$("#"+id).remove();
alert("Record removed successfully");
}
});
}
});

</script>

</body>
</html>

Delete specific record from db using Ajax.

File name : index.php

<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.0/jquery.min.js"></script>

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

$('.delRecord').click(function(){
var ids = this.id ;
//alert(ids);

if(confirm('Are you sure to delete this record ?')) {
$.ajax({
type:'post',
data:'id='+ids,
url : '<?php echo base_url();?>admin/action/deltecomments',
success:function(result){
alert("Your data deleted successfully");
setTimeout(function(){
location.reload();
}, 100);

},
error: function(result){

alert("error");
}

});

}

});
});

</script>
</head>
<body>

<a href="javascript:void(0)" class="delRecord" id="<?php echo $userlist[$i]->cid; ?>">
<button class="btn btn-danger btn-rounded btn-sm">Delete</button></a>

</body>
</html>

Controller

File name : Action.php

<?php
defined('BASEPATH') OR exit('no direct access allowd');
class Action extends CI_Controller
{
public function __construct()
{
parent::__construct();
}

public function deltecomments()
{
$id = $this->input->post('id');
if (empty($id))
{
show_404();
}

$this->db->where('cid', $id);
$this->db->delete('comments_details');
$this->session->set_flashdata('message', 'Deleted Sucessfully');
return;

}
}

File name :

Dekete row without reload page

File name :

<tbody>
<?php
$j=1;
for($i = 0; $i < count ( $adminlist ); ++ $i) {

?>

<tr id="row<?php echo $adminlist[$i]->id;?>">
<td><?php echo $j ?></td>
<td><?php echo $adminlist[$i]->id; ?></td>
<td><?php echo $adminlist[$i]->user_id; ?></td>
<td><?php echo $adminlist[$i]->password; ?></td>
<td><?php echo $adminlist[$i]->email; ?></td>

<td>



<a href="javascript:void(0)" class="editAdmin" id="<?php echo $adminlist[$i]->id;?>" data-userid="<?php echo $adminlist[$i]->user_id; ?>"
data-password="<?php echo $adminlist[$i]->password; ?>" data-email="<?php echo $adminlist[$i]->email; ?>">
<button class="btn btn-default btn-rounded btn-sm" data-backdrop="static" data-keyboard="false">
<span class="fa fa-pencil"></span>
</button>

</a>

<a href="javascript:void(0)" class="delAdmin"id="<?php echo $adminlist[$i]->id; ?>">
<button class="btn btn-danger btn-rounded btn-sm">
<span class="fa fa-times"></span>
</button>
</a>

</td>

<td></td>

</tr>
<?php $j++; } ?>

</tbody>

Ajax

File name :

File name :

Itechtuto

Codeigniter Tutorials

Delete Data using ajax with confirmation message

File name : Delete_Record_Confirm.php

File name : itemlist_view.php

Delete specific record from db using Ajax.

File name : index.php

Controller

File name : Action.php

File name :

Dekete row without reload page

File name :

Ajax

File name :

File name :

Connect Us Socially:

Quick Links