1 <?php  
2 class Crud_model extends CI_Model  
3 {  
4      var $table = "users";  
5      var $select_column = array("id", "first_name", "last_name", "image");  
6      var $order_column = array(null, "first_name", "last_name", null, null);  
7      function make_query()  
8      {  
9           $this->db->select($this->select_column);  
10           $this->db->from($this->table);  
11           if(isset($_POST["search"]["value"]))  
12           {  
13                $this->db->like("first_name", $_POST["search"]["value"]);  
14                $this->db->or_like("last_name", $_POST["search"]["value"]);  
15           }  
16           if(isset($_POST["order"]))  
17           {  
18                $this->db->order_by($this->order_column[$_POST['order']['0']['column']], $_POST['order']['0']['dir']);  
19           }  
20           else  
21           {  
22                $this->db->order_by('id', 'DESC');  
23           }  
24      }  
25      function make_datatables(){  
26           $this->make_query();  
27           if($_POST["length"] != -1)  
28           {  
29                $this->db->limit($_POST['length'], $_POST['start']);  
30           }  
31           $query = $this->db->get();  
32           return $query->result();  
33      }  
34      function get_filtered_data(){  
35           $this->make_query();  
36           $query = $this->db->get();  
37           return $query->num_rows();  
38      }       
39      function get_all_data()  
40      {  
41           $this->db->select("*");  
42           $this->db->from($this->table);  
43           return $this->db->count_all_results();  
44      }  
45      function insert_crud($data)  
46      {  
47           $this->db->insert('users', $data);  
48      }  
49      function fetch_single_user($user_id)  
50      {  
51           $this->db->where("id", $user_id);  
52           $query=$this->db->get('users');  
53           return $query->result();  
54      }  
55      function update_crud($user_id, $data)  
56      {  
57           $this->db->where("id", $user_id);  
58           $this->db->update("users", $data);  
59      }  
60 }  
61