PET SIGHTING DETAILS
SPOTTED TIME
2024/02/16 10:35
2024/02/16 10:35
CONTACT NUMBER
frterdye5 y6575
frterdye5 y6575
NOTE
'asc'); public function __construct() { parent::__construct(); $this->load->database(); } private function _get_datatables_query() { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->group_by('keys.id'); $this->db->order_by('keys.id', 'asc'); $this->db->from($this->table); $i = 0; foreach ($this->column_search as $item) // loop column { if ($_POST['search']['value']) // if datatable send POST for search { if ($i === 0) // first loop { $this->db->group_start(); // open bracket. query Where with OR clause better with bracket. because maybe can combine with other WHERE with AND. $this->db->like($item, $_POST['search']['value']); } else { $this->db->or_like($item, $_POST['search']['value']); } if (count($this->column_search) - 1 == $i) //last loop $this->db->group_end(); //close bracket } $i++; } if (isset($_POST['order'])) // here order processing { $this->db->order_by($this->column_order[$_POST['order']['0']['column']], $_POST['order']['0']['dir']); } else if (isset($this->order)) { $order = $this->order; $this->db->order_by(key($order), $order[key($order)]); } } function get_datatables() { $this->_get_datatables_query(); if ($_POST['length'] != -1) $this->db->limit($_POST['length'], $_POST['start']); $query = $this->db->get(); return $query->result(); } function count_filtered() { $this->_get_datatables_query(); $query = $this->db->get(); return $query->num_rows(); } public function count_all() { $this->db->from($this->table); return $this->db->count_all_results(); } public function get_by_id($id) { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->from($this->table); $this->db->where('id', $id); $query = $this->db->get(); return $query->row(); } public function save($data) { $this->db->insert($this->table, $data); return $this->db->insert_id(); } public function update($where, $data) { $this->db->update($this->table, $data, $where); return $this->db->affected_rows(); } public function delete_by_id($id) { $this->db->where('id', $id); $this->db->delete($this->table); } public function check_key($key, $id = null) { $this->db->from($this->table); $this->db->where('key', $key); if ($id != null) { $this->db->where('id !=', $id); } $query = $this->db->get(); return $query; } public function get($id = null) { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->from($this->table); if ($id != null) { $this->db->where('id', $id); } $this->db->order_by('id', 'asc'); $query = $this->db->get(); return $query; } }
'asc'); public function __construct() { parent::__construct(); $this->load->database(); } private function _get_datatables_query() { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->group_by('keys.id'); $this->db->order_by('keys.id', 'asc'); $this->db->from($this->table); $i = 0; foreach ($this->column_search as $item) // loop column { if ($_POST['search']['value']) // if datatable send POST for search { if ($i === 0) // first loop { $this->db->group_start(); // open bracket. query Where with OR clause better with bracket. because maybe can combine with other WHERE with AND. $this->db->like($item, $_POST['search']['value']); } else { $this->db->or_like($item, $_POST['search']['value']); } if (count($this->column_search) - 1 == $i) //last loop $this->db->group_end(); //close bracket } $i++; } if (isset($_POST['order'])) // here order processing { $this->db->order_by($this->column_order[$_POST['order']['0']['column']], $_POST['order']['0']['dir']); } else if (isset($this->order)) { $order = $this->order; $this->db->order_by(key($order), $order[key($order)]); } } function get_datatables() { $this->_get_datatables_query(); if ($_POST['length'] != -1) $this->db->limit($_POST['length'], $_POST['start']); $query = $this->db->get(); return $query->result(); } function count_filtered() { $this->_get_datatables_query(); $query = $this->db->get(); return $query->num_rows(); } public function count_all() { $this->db->from($this->table); return $this->db->count_all_results(); } public function get_by_id($id) { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->from($this->table); $this->db->where('id', $id); $query = $this->db->get(); return $query->row(); } public function save($data) { $this->db->insert($this->table, $data); return $this->db->insert_id(); } public function update($where, $data) { $this->db->update($this->table, $data, $where); return $this->db->affected_rows(); } public function delete_by_id($id) { $this->db->where('id', $id); $this->db->delete($this->table); } public function check_key($key, $id = null) { $this->db->from($this->table); $this->db->where('key', $key); if ($id != null) { $this->db->where('id !=', $id); } $query = $this->db->get(); return $query; } public function get($id = null) { $this->db->select('*'); $this->db->join('admin', 'admin.id_admin = keys.user_id', 'left'); $this->db->from($this->table); if ($id != null) { $this->db->where('id', $id); } $this->db->order_by('id', 'asc'); $query = $this->db->get(); return $query; } }
SPOTTED LOCATION
SPOTTED TIME
2000/01/24 10:02
2000/01/24 10:02
CONTACT NUMBER
237864723546782
237864723546782
NOTE
hai bro nemu nih
hai bro nemu nih
SPOTTED LOCATION
SPOTTED TIME
2024/02/01 10:01
2024/02/01 10:01
CONTACT NUMBER
089272762385237
089272762385237
NOTE
tolong hilang
tolong hilang
SPOTTED LOCATION
SPOTTED TIME
2024/01/15 14:52
2024/01/15 14:52
CONTACT NUMBER
99988877755666
99988877755666
NOTE
anugerahwati ditemukan
anugerahwati ditemukan
SPOTTED LOCATION
SPOTTED TIME
2024/01/16 14:52
2024/01/16 14:52
CONTACT NUMBER
6867766767
6867766767
NOTE
ditemukan
ditemukan
SPOTTED LOCATION
SPOTTED TIME
2023/06/01 20:00
2023/06/01 20:00
CONTACT NUMBER
9999715535
9999715535
NOTE
testing
testing
SPOTTED LOCATION
SPOTTED LOCATION