LOST & FOUND PETS

PET DETAILS

Dex
Dog » Akita
GPC00001832
REPORTED SIGHTING
GENDER
Male
SPAYED/NEUTERED
Unknown
PRIMARY COLOR
Black Brindle
SECONDARY COLOR
Apricot

TEMPERAMENT
Handle with care
MIXED BREED
--
MICROCHIP ID
gghghg
TATTOO
Bow wow

OWNED BY
renn burke
Phone: 3478030066
LAST KNOWN LOCATION

SECONDARY CONTACT
Big Lou
Phone: 9178389510
VETERINARIAN
Camp Bow wow
Phone: 555-555-5555

LATEST SIGHTING

SPOTTED TIME
2024/02/16 10:35
CONTACT NUMBER
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; } }
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.