How to paginate a collection after get() in Laravel?

by

best way for paginate collection:

1- add this to boot function in \app\Providers\AppServiceProvider 

  /**
         * Paginate a standard Laravel Collection.
         *
         * @param int $perPage
         * @param int $total
         * @param int $page
         * @param string $pageName
         * @return array
         */
        Collection::macro('paginate', function($perPage, $total = null, $page = null, $pageName="page") {
            $page = $page ?: LengthAwarePaginator::resolveCurrentPage($pageName);
            return new LengthAwarePaginator(
                $this->forPage($page, $perPage),
                $total ?: $this->count(),
                $perPage,
                $page,
                [
                    'path' => LengthAwarePaginator::resolveCurrentPath(),
                    'pageName' => $pageName,
                ]
            );
        });

2-From hereafter for all collection you can paginate like this

$events1 = \App\Event::Where('valid_to','>=',$today)->orderByRaw('valid_to','ASC')->get();
$events2 = \App\Event::Where('valid_to','<',$today)>orderByRaw('valid_to','ASC')->get();
$events = $events1->merge($events2); 

$events->paginate(5)

More Related Contents:

  1. Laravel 5 – Manual pagination
  2. Trying to get property of non-object error on laravel 5.4
  3. Browser Version and laravel Version
  4. Vue js in laravel [closed]
  5. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  6. How to protect image from public view in Laravel 5?
  7. How to place the ~/.composer/vendor/bin directory in your PATH?
  8. Eloquent Collection: Counting and Detect Empty
  9. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  10. laravel with() method versus load() method
  11. NotFoundHttpException with Lumen
  12. Laravel 5.4^ – How to customize notification email layout?
  13. How to use paginate() with a having() clause when column does not exist in table
  14. Can’t call Auth::user() on controller’s constructor
  15. Select Last Row in the Table
  16. How to get distinct values for non-key column fields in Laravel?
  17. Where can I set headers in laravel
  18. What is the difference between queue:work –daemon and queue:listen
  19. How to select specific columns in laravel eloquent
  20. Laravel API, how to properly handle errors
  21. Laravel 4.1: How to paginate eloquent eager relationship?
  22. Vue.js – validation fails for file upload in axios when multipart/form-data used in header
  23. How to change value of a request parameter in laravel
  24. Laravel save / update many to many relationship
  25. How to fix the error “You may need an appropriate loader to handle this file type”
  26. I’m getting error “Class ‘Predis\Client’ not found” in Laravel 5.2
  27. Error Field doesn’t have a default value in laravel 5.3
  28. Laravel 4 : Route to localhost/controller/action
  29. laravel migration best way to add foreign key
  30. Install vue 3.0 in laravel

Leave a Comment