How to make such a filter on laravel 5.2 stateful?

Question

MySQL

Tell me how and with what tools, methods to make a filter as in the screenshot. You need pagination to save the filter. The filter should search the database, not the frontend data. Those. jquery plugins probably won't help here. Hypothetically, I can imagine how to do this, but I don’t want to ride a bike)

I would be grateful for your help!

Answer 1

In general, such components (Grid View) are in all frameworks, somewhere right out of the box, somewhere they are installed separately.
Use this package for Laravel 5.x

Answer 2

You just need to display the paginator correctly

$myPaginator->appends(['sortBy'=>$sortBy,'filterBy' => $filterBy, 'perPage' =>$perPage, 'search'=> $search])
       ->setPath("Если надо здесь базовый uri")))
       ->render()

Those. all this data will please get parameters on each page.