Date based pagination

I would really like to be able to "paginate" an eloquent query by date (specifically so all rows from a particularly date are grouped on each "page", going to the previous page would go to the previous date).

Is this something that the paginate (probably simplePaginator) can handle in Laravel; or is this best handled with some custom query scoping?

mikefolsom

9 years ago

Best Answer

Level 21

One approach would be to add a query parameter to your URL, like ?date=2017-02-23, then in your controller, something like

public function index(Request $request)
{
    $collection = MyModel::whereDate('date_column', $request->date)->get();

    return view('myview', compact('collection'));
}

(Validation omitted for brevity) :)

You could make "next" and "previous" links pretty easily with Carbon.

1 like

Please or to participate in this conversation.