/** * Display a listing of qas * * @return Response */ public function index() { $search = Input::get('search'); if ($search) { $query = Qa::with('user')->where('title', 'LIKE', '%' . $search . '%')->orWhere('body', 'LIKE', '%' . $search . '%'); } else { $query = Qa::with('user'); } $qas = $query->orderBy('created_at', 'desc')->paginate(30); return View::make('qas.index')->with(['qas' => $qas, 'search' => $search]); }
public function search() { $search = Input::get('search'); $searchTerms = explode(' ', $search); $queryTutorial = Tutorial::with('user'); $queryQa = Qa::with('user'); foreach ($searchTerms as $term) { $queryTutorial->where('title', 'LIKE', '%' . $term . '%')->orWhere('content', 'LIKE', '%' . $term . '%')->orWhere('description', 'LIKE', '%' . $term . '%'); $queryQa->where('question', 'LIKE', '%' . $term . '%')->orWhere('content', 'LIKE', '%' . $term . '%'); } $resultsTutorial = $queryTutorial->orderBy('created_at', 'desc')->get(); $resultsQa = $queryQa->orderBy('created_at', 'desc')->get(); return View::make('search')->with(['resultsTutorial' => $resultsTutorial, 'resultsQa' => $resultsQa]); }