public function getFoodFromSearchBox($search_input) { $foods = array(); $res = mysql_query("SELECT * FROM food WHERE food like '%" . $search_input . "%'"); if (mysql_num_rows($res) > 0) { while ($userRow = mysql_fetch_array($res)) { $food = new Foods(); $food->setId($userRow['fid']); $food->setFood_id($userRow['id']); $food->setFood($userRow['food']); $food->setImgs($userRow['imgs']); $food->setPrice($userRow['price']); $food->setIngredients($userRow['description']); $food->setType($userRow['type']); $food->setMeal($userRow['meal']); $food->setVeg($userRow['veg']); $food->setSpicy($userRow['spices']); $food->setStock($userRow['stock']); $food->setDelivery($userRow['delivery']); $food->setDtime($userRow['dtime']); $foods[] = $food; } } return $foods; }