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)]);
}
