/** * @param Request $request * * @return \Illuminate\Contracts\View\Factory|\Illuminate\Http\RedirectResponse|\Illuminate\View\View */ public function postSearch(Request $request) { $search = $request->all(); $keyword = $search['query']; if (empty($keyword)) { return redirect(route('classified.search'))->with(['error' => 'No keyword given']); } $items = Classified::havingRaw(' title LIKE \'%' . $keyword . '%\' OR body LIKE \'%' . $keyword . '%\' ORDER BY publish_at DESC;')->get(); if ($items->count()) { return view('classifieds.classified_search_results', compact('keyword', 'items')); } return redirect(route('classified.search'))->with(['error' => 'Search on \'' . $keyword . '\' has no results']); }