Get query string parameters are lost when using pagination links in laravel

Question

I have tried to use pagination with laravel and everything works fine until I navigate to another page, then the request doesn't preserve the previous query string and, as a result, the query doesn't work anymore.

This is the query in the controller:

$inputDate =$request->input('date') ;
$endDate = date('Y-m-d', strtotime($inputDate. ' + 7 days'));

$shifts = DB::table('driver_shifts')
    ->join('drivers','drivers.PermitNumber','=','driver_shifts.driver_badge_id')
    ->where ('driver_shifts.shift_start_time','>',$inputDate)
    ->where ('driver_shifts.shift_start_time','<',$endDate)
    ->orderby("vehicle_id")
    ->orderby("shift_start_time")
    ->paginate(20);

return view('reports.WeeklyTaxiShifts.WeeklyTaxiShifts', compact('shifts','inputDate'));

mdexp · Accepted Answer · 2019-08-18 19:00:21Z

2

You can try to use:

$shifts = DB::table('driver_shifts')
    ->join('drivers','drivers.PermitNumber','=','driver_shifts.driver_badge_id')
    ->where ('driver_shifts.shift_start_time','>',$inputDate)
    ->where ('driver_shifts.shift_start_time','<',$endDate)
    ->orderby("vehicle_id")
    ->orderby("shift_start_time")
    ->paginate(20)
    // this line will put back the query string parameters on the generated links
    ->appends(request()->query());

That is also explained with a blade usage example in the documentation

answered Aug 18, 2019 at 19:00

mdexp

3,5872 gold badges11 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Get query string parameters are lost when using pagination links in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related