diff options
Diffstat (limited to 'app')
| -rw-r--r-- | app/Http/Controllers/CinemaController.php | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/app/Http/Controllers/CinemaController.php b/app/Http/Controllers/CinemaController.php index c1cb215..c6fec3b 100644 --- a/app/Http/Controllers/CinemaController.php +++ b/app/Http/Controllers/CinemaController.php @@ -104,10 +104,18 @@ class CinemaController extends Controller ->orWhere('imdb.original_title', 'like', '%' . $query . '%') ->orWhere('imdb.synopsis', 'like', '%' . $query . '%'); }) - ->orderBy('imdb.average_rating', 'desc') ->simplePaginate(12); - $total = $movies->total(); + $total = DB::connection('cinema') + ->table('imdb') + ->whereNotNull('primary_title') + ->where('title_type', 'movie') + ->where(function ($q) use ($query) { + $q->where('primary_title', 'like', '%' . $query . '%') + ->orWhere('original_title', 'like', '%' . $query . '%') + ->orWhere('synopsis', 'like', '%' . $query . '%'); + }) + ->count(); return view('cinema', ['movies' => $movies, 'count' => $total, 'search_query' => $query]); } |