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