/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($slug) { $article = Article::where('slug', $slug)->firstOrFail(); $articleSide = DB::select("select title, slug, image_lead\n from articles\n WHERE ID !='{$article->id}' limit 5;"); $googlePhrahes = Google::limit(30)->orderBy('id', 'DESC')->get(); return view('article', compact('article', 'articleSide', 'googlePhrahes')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $medsASC = Meds::limit(15)->offset(0)->orderBy('id', 'ASC')->get(); $medsDESC = Meds::limit(15)->offset(0)->orderBy('id', 'DESC')->get(); $medsRAND = Meds::limit(15)->orderByRaw("RAND()")->get(); $googlePhrahes = Google::limit(30)->orderBy('id', 'DESC')->get(); $articles = Article::limit(30)->orderBy('id', 'DESC')->get(); return view('index', compact('articles', 'medsASC', 'medsDESC', 'medsRAND', 'googlePhrahes')); }