Codeigniter Tutorials

Home » Codeigniter »

Delete Selected data using check box and delete all data using ajax.

Controller :

File name : Delete_All.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Delete_All extends CI_Controller {

public function __construct() {
parent::__construct();
//$this->load->database();
}

public function index()
{
$data['data'] = $this->db->get("items")->result();
$this->load->view('delete_all_view', $data);
}

public function deleteAll()
{
$id = $this->input->post('id');

$this->db->where_in('id', explode(",", $id));
$this->db->delete('items');
echo json_encode(['success'=>"Item Deleted successfully."]);

//$data = $this->Auth_model->del_selected_row($id);
//echo json_encode($data);
exit;

}

}

view

File name : delete_all_view.php

<!DOCTYPE html>
<html>
<head>
<title>how to delete multiple records using checkbox in codeigniter - 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>how to delete multiple records using checkbox in codeigniter.</h2>
</div>
</div>
</div>

<button style="margin-bottom: 10px" class="btn btn-primary delete_all" data-url="/itemDelete">Delete All Selected</button>

<table class="table table-bordered" style="margin-top:20px">

<thead>
<tr>
<th width="50px"><input type="checkbox" id="master"></th>
<th>Title</th>
<th>Description</th>
</tr>
</thead>

<tbody>
<?php foreach ($data as $item) { ?>
<tr>
<td><input type="checkbox" class="sub_chk" data-id="<?php echo $item->id; ?>"></td>
<td><?php echo $item->title; ?></td>
<td><?php echo $item->description; ?></td>
</tr>
<?php } ?>
</tbody>

</table>
</div>

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

$('#master').on('click', function(e) {
if($(this).is(':checked',true))
{
$(".sub_chk").prop('checked', true);
} else {
$(".sub_chk").prop('checked',false);
}
});

$('.delete_all').on('click', function(e) {

var allVals = [];
$(".sub_chk:checked").each(function() {
allVals.push($(this).attr('data-id'));
});

if(allVals.length <=0)
{
alert("Please select row.");
} else {

var check = confirm("Are you sure you want to delete this row?");
if(check == true){
var join_selected_values = allVals.join(",");
//alert(join_selected_values);
$.ajax({
//url: $(this).data('url'),
url: '<?php echo base_url();?>Delete_All/deleteAll',
type: 'POST',
//data: 'ids='+join_selected_values,
data:{id:join_selected_values},
datatype:'json',
success: function (data) {
console.log(data);
$(".sub_chk:checked").each(function() {
$(this).parents("tr").remove();
});
alert("Item Deleted successfully.");

},
error: function (data) {
alert(data.responseText);
}
});

$.each(allVals, function( index, value ) {
$('table tr').filter("[data-row-id='" + value + "']").remove();
});
}
}
});
});
</script>

</body>
</html>

model

File name : Auth_model.php

public function del_selected_row($id)
{
$this->db->where('id',$id);
$this->db->delete('items');
}

File name : index.php

Itechtuto