public function show_details($id) { $movie = DB::table('dvds')->select('dvds.id', 'title', 'genre_name', 'rating_name', 'label_name', 'sound_name', 'format_name')->where('dvds.id', '=', $id)->join('genres', 'dvds.genre_id', '=', 'genres.id')->join('ratings', 'dvds.rating_id', '=', 'ratings.id')->join('labels', 'dvds.label_id', '=', 'labels.id')->join('sounds', 'dvds.sound_id', '=', 'sounds.id')->join('formats', 'dvds.format_id', '=', 'formats.id'); $movie = $movie->get(); // $reviews = DB::table('reviews') // ->select('title', 'description', 'rating') // ->where('dvd_id', '=', $id); // $reviews = $reviews->get(); // $reviews = Review::all(); return view("review", ['movie' => $movie, 'reviews' => Review::All($id)]); }