Why Pagination laravel ignores requests - skip, take

Question

I wanted to use skip and take but pagination does not work. Why does it not work?

Code:

    $posts = DB::table('posts')
        ->orderBy('id','desc')
        ->skip(9)
        ->take(3)
        ->paginate(3);



    if ($request->ajax()) {
        return ['posts' => view('blog.ajax.index')->with(compact('posts'))->render(),
            'next_page' => $posts->nextPageUrl()
        ];
    }

I definitely need to use pagination

score 2 · Answer 1 · answered Jul 20 '17 at 06:17

2

You can not use paginate and skip at the same time. so your alternate option would be something like this

$take = 100;
$skip = 9;
$currentPage = Request::get('page', 1);
$poster = DB::table('posts')        
    ->take(100)
    ->skip($skip + (($currentPage - 1) * $take))        
    ->orderBy('id','desc');

for pagination try

@if (Request::has('page') && Request::get('page') > 1)
<a href="{{ route('some.route', ['page' => Request::get('page') - 1]) }}">Previous page</a>
@endif

@if (Request::has('page'))
    <a href="{{ route('some.route', ['page' => Request::get('page') + 1]) }}">Next page</a>
@else
    <a href="{{ route('some.route', ['page' =>2]) }}">Next page</a>
@endif

answered Jul 20 '17 at 06:17

Nileshsinh Rathod

948
1
17
37

I definitely need to use pagination – Arman Turebekov Jul 20 '17 at 06:27
@ArmanTurebekov you can use pagination, also i mention pagination part in answer. and calculate the number of pages before you send the data to the view this is just example modify as per your requirement. – Nileshsinh Rathod Jul 20 '17 at 06:33
@ArmanTurebekov if you are satisfied with my answer please accept my answer. – Nileshsinh Rathod Jul 20 '17 at 06:46
Oh sorry, I forgot about it – Arman Turebekov Jul 20 '17 at 06:54
And we can implement all this in blade.php – Arman Turebekov Jul 20 '17 at 06:57

Why Pagination laravel ignores requests - skip, take

1 Answers1