/**
* Display a listing of tutorials
*
* @return Response
*/
public function index()
{
$search = Input::get('search');
if ($search) {
$query = Tutorial::with('user')->where('title', 'LIKE', '%' . $search . '%')->orWhere('content', 'LIKE', '%' . $search . '%');
} else {
$query = Tutorial::with('user');
}
$tutorials = $query->orderBy('created_at', 'desc')->paginate(30);
return View::make('tutorials.index')->with(['tutorials' => $tutorials, '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]);
}
