handling All dropdowns

DvdController.php

$genre = $request->input('genre');

$movies = DB::table('dvds')
  ->select('title', 'genre_name', 'rating_name', 'label_name', 'sound_name', 'format_name')
  // more joins here
  ->join('genres', 'dvds.genre_id', '=', 'genres.id');
  
if ($genre !== 'All') {
  $movies = $movies->where('genre_id', '=', $genre);
}

$movies = $movies->get();