Nrthugu

I have two different querys that I merge to return a collection

$combinados = $histMe->merge($hist)->sortByDesc('created_at');

And I return them this way:

$final = $combinados->all();

But this prints all the collection, how can I paginate this? The paginate() laravel method doesn't work with collections. And how can I controll it from the view?

Thanks!

You can use this code that I wrote a long time ago:

You must use Length aware paginator:

use IlluminatePaginationLengthAwarePaginator;





public function paginate($items, $perPage,$setDefaultOption = true, $options = )

    {

        if($setDefaultOption){

            $options = ['path' => request()->url(), 'query' => request()->query()];

        }

        $page = Input::get('page', 1); // Get the current page or default to 1





        $items = $items instanceof Collection ? $items : Collection::make($items);



        return new LengthAwarePaginator($items->forPage($page, $perPage), $items->count(), $perPage, $page, $options);

    }

The api has changed slightly in newer versions. To paginate a collection you now need to use forPage.

The method forPage takes two parameters:

forPage(int $page, int $perPage)

So you can do something like this in your controller:

...

public function index(Request $request)

{

    $combinados = $histMe->merge($hist)->sortByDesc('created_at');



    $combinados->forPage($request->get('page'), 25);

}

...