/** * get user details by email */ private function getUserDetails($email) { $_db = new Core\Dbconfig(); $qry = 'select * from user where email = ?'; $res = array(); $res = $_db->query($qry, array($email)); return $res; }
/** * search product * @param {"name":"tes","price":12} */ public function search() { $req_data = $this->_request; $sub_qry = ''; $_db = new Core\Dbconfig(); $params = array(); if (!empty($req_data['name'])) { $sub_qry .= ' name like "' . $_db->escape($req_data['name']) . '%"'; } if (!empty($req_data['price'])) { $sub_qry .= empty($sub_qry) ? '' : ' OR '; $sub_qry .= ' price = ?'; $params[] = $req_data['price']; } $res = array(); $res['data'] = $_db->query('SELECT * FROM product WHERE ' . $sub_qry, $params); $res['message'] = empty($res['data']) ? 'No records found' : 'Search complete'; $this->response($this->json($res), 200); }