From 0d4c4fbabc4469d533ca309d3342df0bb92fc4d6 Mon Sep 17 00:00:00 2001 From: horus Date: Mon, 13 May 2019 15:32:29 +0200 Subject: Adds custom pagination. (site) --- site/app/Http/Controllers/FKSearchController.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'site/app/Http/Controllers/FKSearchController.php') diff --git a/site/app/Http/Controllers/FKSearchController.php b/site/app/Http/Controllers/FKSearchController.php index a148bba..efa6c8a 100644 --- a/site/app/Http/Controllers/FKSearchController.php +++ b/site/app/Http/Controllers/FKSearchController.php @@ -60,7 +60,7 @@ class FKSearchController extends Controller { $query = Input::get("q"); $q = "%" . Utility::escapeLike($query) . "%"; - $data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orWhere('shop', 'like', $q)->orderBy($sort_by, $order_by)->simplePaginate(20); + $data = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orWhere('shop', 'like', $q)->orderBy($sort_by, $order_by)->paginate(20); $count = DB::table('all_view')->whereNotNull('url')->where('name', 'like', $q)->orWhere('spirit_type', 'like', $q)->orWhere('shop', 'like', $q); $query_string = ""; -- cgit v1.2.3