Laravel Eloquent Paginate Doesn't Exist Error

Question

I'm trying to set pagination in a Laravel blade/view but it's showing an error with this message below:

BadMethodCallException

Method Illuminate\Database\Eloquent\Collection::paginate does not exist.

Controller

public function view()
{
    $user = Auth::user();
    $basic_info = User::find($user->id)->basic_info;
    $category = Category::all()->paginate(10); 

    return view('admin.article.category-view')->with(['user' => $user, 'basic_info' => $basic_info, 'category' => $category]);
}

View Blade (admin.article.category-view)

<div class="panel-body">
    <table class="table table-hover">
        <thead>
        <tr>
            <th>Category Name</th>
        </tr>
        </thead>
        <tbody>
        @foreach($category as $cat)
            <tr>
                <td>{{ $cat->name }}</td>
            </tr>
        @endforeach
        </tbody>
    </table>
    {{ $category->links() }}
</div>

MyLibary · Accepted Answer · 2019-01-14 07:58:55Z

5

Using paginate method on the query builder or an Eloquent query only, not on collection, like so:

public function view()
{
    $user = Auth::user();
    $basic_info = User::find($user->id)->basic_info;
    $category = Category::paginate(10); 

    return view('admin.article.category-view')->with(['user' => $user, 'basic_info' => $basic_info, 'category' => $category]);
}

answered Jan 14, 2019 at 7:58

MyLibary

1,77110 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ismoil Shifoev · Accepted Answer · 2019-01-14 08:32:41Z

1

You need to remove all():

 $category = Category::paginate(10);

When you're using all() you get all the rows from the table and get a collection

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

answered Jan 14, 2019 at 8:32

Ismoil Shifoev

6,0893 gold badges27 silver badges34 bronze badges

1 Comment

Mosharof Zitu Over a year ago

It worked. Now I can understand how collections work. Thanks a lot for enlightening me.

Collectives™ on Stack Overflow

Laravel Eloquent Paginate Doesn't Exist Error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related