/**
* 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);
}
