How to append query string to pagination links using Laravel

Question

Hello and thanks for your help. I've done some research and tried a few options but can't seem get this to work properly. I'm passing a URL with a query string into a function that loads the page via URL passed. However, I'm trying to find a way to paginate the results as well. Is there a way I can pass the query string url to Laravel's pagination links? Thanks.

My URL with query string

            <a id="searchData"class="btn btn-primary ml-1 mr-5 text-light" title="Search" type="submit" 
        onclick="ajaxLoad('{{url('dma/data')}}?startDate='+$('#startDate').val()+'&endDate='+$('#endDate').val() 
            + '&dmaNameFilter=' + encodeURI(dma_name) + '&memberNameFilter=' + encodeURI(member_name))">Search Results
        </a>

I tried this for the links():

{{ $data->appends(request()->query())->links() }}

I have this in my Controller:

$data = Report::where('CallDate', '>=', $start_date)->where('CallDate', '<=', $end_date)->paginate(13)->appends(request()->query());

If you are sure request()->query() is an array with startDate/endDate / dmaNameFilter / memberNameFilter, your pagination links in blade is OK. But it seems incorrect in the controller which I think you should add more where conditions for the query, e.g. dmaNameFilter, memberNameFilter,... — Phil
– Phil, Commented Sep 28, 2019 at 0:56

Angel · Accepted Answer · 2020-04-05 21:33:56Z

4

You can also add this:

$this->app->resolving(\Illuminate\Pagination\LengthAwarePaginator::class, function ($paginator) {
   return $paginator->appends(Arr::except(request()->query(), $paginator->getPageName()));
});

To your AppServiceProvider

answered Apr 5, 2020 at 21:33

Angel

712 silver badges10 bronze badges

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

Comments

Aldoo Rayan · Accepted Answer · 2021-12-07 11:42:58Z

1

Try This

$data->appends(request()->input())->links()

answered Dec 7, 2021 at 11:42

Aldoo Rayan

214 bronze badges

Comments

Laynor · Accepted Answer · 2022-08-23 12:40:14Z

1

Since Laravel 8, You can simply use

$paginator->withQueryString();

answered Aug 23, 2022 at 12:40

Laynor

1,54311 silver badges22 bronze badges

Comments

jnbn · Accepted Answer · 2019-09-28 01:43:00Z

0

You can pass any data to pagination by calling

{{ $paginator->links('view.name', ['foo' => 'bar']) }}

on your situation I think you want to pass query string to paginator; you may try

{{ $paginator->links('view.name', request()->getQueryString() ) }}

If you need to append querystrings for your ajax controller you'd better check https://github.com/spatie/laravel-query-builder

answered Sep 28, 2019 at 1:43

jnbn

703 silver badges7 bronze badges

1 Comment

Eduardo Güereque Over a year ago

Awesome! I'll give this a try. Thank you for your help.

Collectives™ on Stack Overflow

How to append query string to pagination links using Laravel

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related