How to Multiple Delete With CodeIgniter
In this tutorial I will discuss about how to create Multiple Delete With CodeIgniter , If you guys often use
wordpress definitely friends will know, because wordpress apply this in
their system.
First prepare your codeigniter folder named delete_multiple, Here I assume friends already know how to setup initial CodeIgniter like config.php, autoload.php dll, database.php. We will use the Controller welcome.php default is Codeigniter or at least have followed the basic tutorial of the use of Codeigniter .
Read Also: CRUD Tutorial (Create, Read, Update and Delete) With CodeIgniter - Part 1 & Part 2
Next create a database codeigniter_crud , create a student table like the following conditions below sqlnya:
Open Controller welcome.php then edit as below:
Create a new file in the Models folder where msiswa.php :
The snippet of this image describes the coding to display the existing data
in the databasecodeigniter_crud student
table :
This is for the process when the data will be deleted:
Then create a new file in the Views folder named index.php :
Description in the index.php file , you
must first download
JQuery Docs: Selectors / checked
then input jquery script to checkAll below:
Read Also: Tutorial Making Check & Uncheck All Checkboxs with Jquery
In the table script snippet you enter the id to call the javascript function that we apply:
Named the checkbox id like this, intended to call the javascript function we created, when the checkbox is clicked fed automate all checkAll:
For the post method submitted by the input checkbox we created, we named the checkbox mgs [], to create the array when the data is deleted, following the script snippet:
After completing all the above discussion, you can directly try the program that friend made earlier, if it is correct it will appear as below, so when checkbox next door clicked to eat data will check all, and to delete data Sahabat must choose Select Bulk Action Changed to Delete option then press Action button:
Okay, so my tutorial this time about Multiple Delete With Codeigniter.
Hope can increase knowledge of Friends: D: D
Download Tutorial
First prepare your codeigniter folder named delete_multiple, Here I assume friends already know how to setup initial CodeIgniter like config.php, autoload.php dll, database.php. We will use the Controller welcome.php default is Codeigniter or at least have followed the basic tutorial of the use of Codeigniter .
Read Also: CRUD Tutorial (Create, Read, Update and Delete) With CodeIgniter - Part 1 & Part 2
Next create a database codeigniter_crud , create a student table like the following conditions below sqlnya:
-- -- Database: `codeigniter_crud` -- -- -------------------------------------------------------- -- -- Table structure for table `siswa` -- CREATE TABLE IF NOT EXISTS `siswa` ( `nis` bigint(11) NOT NULL, `nama` varchar(30) NOT NULL, `jurusan` varchar(10) NOT NULL, `alamat` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=998765336 DEFAULT CHARSET=latin1; -- -- Dumping data for table `siswa` -- INSERT INTO `siswa` (`nis`, `nama`, `jurusan`, `alamat`) VALUES (998765122, 'Yusuf Hamdani', 'RPL', 'Jln. Cipaku Haji Rt.02/07 No.15 Kel.Cipaku Kec.Bogor Selatan'), (998765335, 'Rahmayanti', 'Multimedia', 'Jln. Muarasari, Kel.Gunung Batu Kec.Bogor Barat'); -- -- Indexes for dumped tables --
Codeigniter_crud.sql
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Welcome extends CI_Controller { /** * Index Page for this controller. * * Maps to the following URL * http://example.com/index.php/welcome * - or - * http://example.com/index.php/welcome/index * - or - * Since this controller is set as the default controller in * config/routes.php, it's displayed at http://example.com/ * * So any other public methods not prefixed with an underscore will * map to /index.php/welcome/<method_name> * @see http://codeigniter.com/user_guide/general/urls.html */ public function index() { $this->load->model('msiswa'); $data['hasilsiswa'] = $this->msiswa->ambildata(); $this->load->view('index', $data); } function delete_multiple() { $this->load->model('msiswa'); $this->msiswa->remove_checked_siswa(); redirect('welcome/index'); } } /* End of file welcome.php */ /* Location: ./application/controllers/welcome.php */
Welcome.php
<?php class Msiswa extends CI_Model { function ambildata() { $ambildata = $this->db->get('siswa'); if ($ambildata->num_rows() > 0) { foreach ($ambildata->result() as $data) { $hasilsiswa[] = $data; } return $hasilsiswa; } } function remove_checked_siswa() { $action = $this->input->post('action'); if ($action == "delete") { $delete = $this->input->post('msg'); for ($i=0; $i < count($delete) ; $i++) { $this->db->where('nis', $delete[$i]); $this->db->delete('siswa'); } } } } ?>
Msiswa.php
This is for the process when the data will be deleted:
Then create a new file in the Views folder named index.php :
<!DOCTYPE html> <html> <head> <title>AZZURA Media | Membuat Multiple Delete Dengan CodeIgniter</title> <script type="text/javascript" src="<?php echo base_url(''); ?>assets/js/jquery-1.5.2.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $("input[name='checkAll']").click(function() { var checked = $(this).attr("checked"); $("#myTable tr td input:checkbox").attr("checked", checked); }); }); </script> </head> <body> <h1>Multiple Delete Dengan CodeIgniter</h1> <form action="<?php echo site_url('welcome/delete_multiple'); ?>" method="post"> <select name="action"> <option value="null">Bulk Action</option> <option value="delete">Delete</option> </select> <input type="submit" name="submit" value="Action"> <p></p> <table border="1" id="myTable"> <thead> <tr> <th><input type="checkbox" id="checkAll" name="checkAll"></th> <th>NIS</th> <th>Nama</th> <th>Jurusan</th> <th>Alamat</th> </tr> </thead> <tbody> <?php if (count($hasilsiswa)>0) { foreach ($hasilsiswa as $data): ?> <tr> <td><input type="checkbox" name="msg[]" value="<?php echo $data->nis; ?>"></td> <td><?php echo $data->nis; ?></td> <td><?php echo $data->nama; ?></td> <td><?php echo $data->jurusan; ?></td> <td><?php echo $data->alamat; ?></td> </tr> <?php endforeach; } else { echo "<tr><td colspan=5>DATA KOSONG!!</td></tr>"; } ?> </tbody> </table> </form> </body> </html>
Index.php
<script type="text/javascript"> $(document).ready(function() { $("input[name='checkAll']").click(function() { var checked = $(this).attr("checked"); $("#myTable tr td input:checkbox").attr("checked", checked); }); }); </script> 
Read Also: Tutorial Making Check & Uncheck All Checkboxs with Jquery
In the table script snippet you enter the id to call the javascript function that we apply:
Named the checkbox id like this, intended to call the javascript function we created, when the checkbox is clicked fed automate all checkAll:
For the post method submitted by the input checkbox we created, we named the checkbox mgs [], to create the array when the data is deleted, following the script snippet:
After completing all the above discussion, you can directly try the program that friend made earlier, if it is correct it will appear as below, so when checkbox next door clicked to eat data will check all, and to delete data Sahabat must choose Select Bulk Action Changed to Delete option then press Action button:
Okay, so my tutorial this time about Multiple Delete With Codeigniter.
Hope can increase knowledge of Friends: D: D
Download Tutorial
Comments
Post a Comment
Bila Ada posting yang kurang, atau error atau yang lainnya, silahkan tinggalkan komentar agar artikel/post di perbaiki.
Jangan Lupa Cek Box "Notify Me" agar tahu komentar kamu dibalas oleh saya.
If there are any posts that are missing, or error or anything else, please leave a comment for the article / post to be fixed.
Do not Forget Check Box "Notify Me" to know our comments replied by me.