azmicolejr

Edit Data Checkbox CI3 Mysql

Nov 3rd, 2020 (edited)
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.54 KB | None | 0 0
  1. CONTROLLER
  2. <?php
  3. defined('BASEPATH') or exit('No direct script access allowed');
  4.  
  5. class Auth extends CI_Controller
  6. {
  7.   function update($id){
  8.     $this->data['user']                 = $this->Auth_model->get_by_id($id);
  9.     $this->data['get_all_data_access']  = $this->Dataaccess_model->get_all();
  10.  
  11.     $this->load->view('back/auth/user_edit', $this->data);
  12.   }
  13. }
  14.  
  15. MODEL
  16. <?php
  17. defined('BASEPATH') or exit('No direct script access allowed');
  18.  
  19. class Auth_model extends CI_Model
  20. {
  21.   function get_by_id($id){
  22.     $this->db->where($this->id, $id);
  23.     return $this->db->get($this->table)->row();
  24.   }
  25. }
  26.  
  27.  
  28. <?php
  29. defined('BASEPATH') or exit('No direct script access allowed');
  30.  
  31. class Dataaccess_model extends CI_Model
  32. {
  33.   function get_all(){
  34.     return $this->db->get($this->table)->result();
  35.   }
  36. }
  37.  
  38. VIEW
  39. <?php
  40. $this->db->where('user_id', $user->id_users);
  41. $dataAccessOld = $this->db->get('users_data_access')->result();
  42. print_r($dataAccessOld);
  43.  
  44. foreach ($get_all_data_access as $alldataAccess) {                      
  45.   foreach($dataAccessOld as $oldDataAccess){
  46.     if($oldDataAccess->data_access_id == $alldataAccess->id_data_access){
  47.       $checked = 'checked';
  48.     }else{$checked = '';}
  49.   }
  50. ?>
  51.  
  52. <div class="pretty p-icon p-smooth">
  53.   <input type="checkbox" name="data_access_id[]" value="<?php echo $alldataAccess->id_data_access ?>" <?php echo $checked ?>>
  54.   <div class="state p-success">
  55.     <i class="icon fa fa-check"></i>
  56.     <label><?php echo $alldataAccess->data_access_name ?></label>
  57.   </div>
  58. </div>
  59. <?php } ?>
Add Comment
Please, Sign In to add comment