PET DETAILS
Dex
Dog » Akita GPC00001832
REPORTED SIGHTING
GENDER
Male
Male
SPAYED/NEUTERED
Unknown
Unknown
PRIMARY COLOR
Black Brindle
Black Brindle
SECONDARY COLOR
Apricot
Apricot
TEMPERAMENT
Handle with care
Handle with care
MIXED BREED
--
--
MICROCHIP ID
gghghg
gghghg
TATTOO
Bow wow
Bow wow
OWNED BY
renn burke
Phone: 3478030066
renn burke
Phone: 3478030066
LAST KNOWN LOCATION
SECONDARY CONTACT
Big Lou
Phone: 9178389510
Big Lou
Phone: 9178389510
VETERINARIAN
Camp Bow wow
Phone: 555-555-5555
Camp Bow wow
Phone: 555-555-5555
LATEST SIGHTING
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
We are showing your current location in the map. You can also drag the pin to mark the exact location of sighting or use the search field to find an address.