Laravel pagination according to drop-down

Question

How to paginate in laravel 5 by drop-down values? I have tried as below.

public function getreport() {

        ->Paginate(10);

        $links = str_replace('/?', '?', $buildings->render());

        return view('daily_entry_report',compact('buildings'));
    }

Here buildings refer to my database query.

Is your question really just `how to add where clause to pagination`? — Ohgodwhy, Jan 27 '18 at 11:12
i want to paginate my view page according to drop-down values which are 5,10,15 entries per page — dev.amit, Jan 27 '18 at 11:30
in the above it paginates 10 pages,but i want the user to select the drop-down values. — dev.amit, Jan 27 '18 at 11:32
Simple solution is to have dynamic value for `paginate()` as `paginate(Input::get('number'))` where number you send from frontend — Ganesh Ghalame, Jan 27 '18 at 12:22
public function getreport(Request $request) { $school = DB::table('school') ->Paginate((Input::get('number'))); $links = str_replace('/?', '?', $buildings->render()); return view('view',compact('school')) — dev.amit, Jan 27 '18 at 15:43

score 0 · Answer 1 · answered Jan 27 '18 at 15:12

0

Pass a parameter ($dropdownvalue) to the method and use it with paginate:

public function getreport($dropdownvalue = 10) {
     ->Paginate($dropdownvalue);

For this to work, you also have to edit the route (route/web.php) so that it takes the value (what does your route look like?):

Route::get('/getreport/{dropdownvalue}', ['as'=>'report.get', 'uses' => 'ReportController@getreport']);

In order to show 5 reports at a time, you can access:

mydomaine.com/getreport/5

To use it with your dropdown, you need to "reload"/"redirect" the page after each selection. Simplest way would be to use javascript. Click here to see how.

Note that this is not the best way to do this but it works.

answered Jan 27 '18 at 15:12

Andreasfi

347
6
16

public function getreport($dropdownvalue = 10) { $school = DB::table('school') - ->Paginate($dropdownvalue); $links = str_replace('/?', '?', $buildings->render()); return view('view',compact('school'); my controller – dev.amit Jan 27 '18 at 16:25
on selecting the value it says page not found – dev.amit Jan 27 '18 at 16:31
– dev.amit Jan 27 '18 at 16:32
What does your route look like? You can find it in routes/web.php And what is the url when it says page not found? – Andreasfi Jan 27 '18 at 16:53
$searchby = $request->get('number') returning null value after passing dd($searchby) where number is select name in view – dev.amit Jan 28 '18 at 04:34
I mean the route you use. You can find it in routes/web.php – Andreasfi Feb 01 '18 at 11:59

Laravel pagination according to drop-down

1 Answers1