Codeigniter : Deleting multiple rows with checkbox

Tweet

// Model
/* Delete checkbox */
   function delete_check($id){
        $this->db->query('DELETE FROM users WHERE id ='.$id);
   }

// Controller
function delete_checkbox(){
        $dat=$this->input->post('forms');
        for($i=0; $i<sizeof($dat);$i++){
            print_r($dat[$i]);
            $this->your_model->delete_check($dat[$i]);
            }
        }

// View

<form name="forms" action="auth/delete_checkbox" method="post">
<tbody>
<?php foreach ($users as $user):?>

<tr>
<td><input type="checkbox" name="forms[]" id="air" value="<?php echo $user->id;?>" /></td>
<td><a href="<?php echo base_url();?>index.php/auth/update_user/<?php echo $user->id; ?>"><?php echo $user->username;?></a></td>
<td><?php echo $user->first_name;?></td>
<td><?php echo $user->last_name;?></td>
<td><a href="#"><?php echo $user->email;?></a></td>
</tr>
<?php endforeach;?>
<input type="submit" value="DELETE" class="button"/>
</tbody>
</form>

Comments (Your Comments)