How to paginate query builder results in Laravel 5?
Paginate Query Builder Results in Laravel
Most of times while building admin panels; we need to show listings with pagination. We can do this by using jQuery plugins like DataTables but we can also do paginate query builder results in Laravel 5.
Laravel’s paginator is integrated with query builder and eloquent query and it provides pagination of database results. Pagination HTML is compatible with the Bootstrap CSS Framework.
We can use a very simple method paginate on query builder or an eloquent query to show pagination. Following is the example.
/// in controller
public function index()
{
$items = DB::table('items')->paginate(15);
return view('items.index', ['items' => $items]);
}
Now show pagination result as following in “items.index”.
{{ $items->links() }}
Following are few other Laravel posts.
Disable inactive users to log in.
Set foreign key checks Laravel 5
