CODEWITHSUNDEEP
laravelmethodspagination
Andrii H.
Andrii H.

Reputation: 1812

Laravel Method paginate does not exist

I am trying to paginate Model result, but I am getting "Method paginate does not exist.". Here is my code:

$user_dispatches = Dispatch::all()->where('user_id', Auth::id())->paginate(10);

I need to get all records where users id equals current authenticated users id. Works well without paginate() method.

Upvotes: 35

Views: 114313

Answers (9)

Mostafa Norzade
Mostafa Norzade

Reputation: 1766

for use all recorde and pagination , you need use below code :

$user_dispatches = Disspath::paginate(25);

Upvotes: 20

Daniela Wuerich
Daniela Wuerich

Reputation: 131

If working on laravel + Blade there's a case when I need to keep the all() or get() what I do is to add a toQuery() function to make it work. In my case, this snippet of code helped me get the pagination on Blade without changing my index function:

public function index()
  {
    $users = User::all();
    foreach ($users as $user) {
      //some code I need
      }
    }

    return view('users.index', ['users' => $users->toQuery()->paginate(5)]);
  }

Upvotes: 0

Javier Duque
Javier Duque

Reputation: 71

The method toQuery() changes a collection to query:

$pacientes = Paciente::get()->toQuery()->paginate(20);

Upvotes: 7

launghe
launghe

Reputation: 11

**Solved To Clarify the solution from above
Change...

$user_dispatches = Dispatch::all()->where('user_id', Auth::id())->paginate(10);

to

$user_dispatches = Dispatch::where('user_id', Auth::id())->paginate(10)

In another project I was attempting to return a view with my posts array and I was also able to paginate like this...In PostController

public function index()
{
  $posts = Post::where('user_id', Auth::id());
  return view('admin.posts.index', ['posts'=>$posts->paginate(5)]);
}

Upvotes: 0

Azek
Azek

Reputation: 37

You can create own custom class:

<?php
namespace App\CustomClasses;

use Illuminate\Container\Container;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Pagination\Paginator;
use Illuminate\Support\Collection;

class ColectionPaginate
{
    public static function paginate(Collection $results, $pageSize)
    {
        $page = Paginator::resolveCurrentPage('page');
        
        $total = $results->count();

        return self::paginator($results->forPage($page, $pageSize), $total, $pageSize, $page, [
            'path' => Paginator::resolveCurrentPath(),
            'pageName' => 'page',
        ]);

    }

    /**
     * Create a new length-aware paginator instance.
     *
     * @param  \Illuminate\Support\Collection  $items
     * @param  int  $total
     * @param  int  $perPage
     * @param  int  $currentPage
     * @param  array  $options
     * @return \Illuminate\Pagination\LengthAwarePaginator
     */
    protected static function paginator($items, $total, $perPage, $currentPage, $options)
    {
        return Container::getInstance()->makeWith(LengthAwarePaginator::class, compact(
            'items', 'total', 'perPage', 'currentPage', 'options'
        ));
    }
}

and then use it:

use App\CustomClasses\ColectionPaginate;
...
$result = $query->limit(100)->get();
$paginatedResult = ColectionPaginate::paginate($result, 10);

Upvotes: 2

Joan Nguyen
Joan Nguyen

Reputation: 372

You need remove method all() : 

$user_dispatches = Dispatch::where('user_id', Auth::id())->paginate(10);

Because all() return a Collection while paginate() used a Builder

Upvotes: 7

Amarnasan
Amarnasan

Reputation: 15529

Extending a bit Alexey's perfect answer :

Dispatch::all() => Returns a Collection

Dispatch::all()->where() => Returns a Collection

Dispatch::where() => Returns a Query

Dispatch::where()->get() => Returns a Collection

Dispatch::where()->get()->where() => Returns a Collection

You can only invoke "paginate" on a Query, not on a Collection.

And yes, it is totally confusing to have a where function for both Queries and Collections, working as close as they do, but it is what it is.

Upvotes: 113

parastoo
parastoo

Reputation: 2469

Dispatch::where('user_id', auth()->user()->id)->paginate(10);

Upvotes: 2

Alexey Mezenin
Alexey Mezenin

Reputation: 163748

You need to remove all():

Dispatch::where('user_id', Auth::id())->paginate(10);

When you're using all() you get all the rows from the table and get a collection. Then you're using collection method where() (and not Query Builder method where()) and then you're trying to use paginate() method on the collection and it doesn't exist.

Upvotes: 56

Related Questions