/PHP/Laravel/Laravel pagination with search filter

Laravel pagination with search filter

// if $id has value it will include "where('id','<',$id) else will return all"
$wells = DB::table('well_s')
        ->when($id, function ($query, $id) {
            return $query->where('id','<',$id);
        })
        ->paginate(20);

Source: stackoverflow.com

Laravel 7 pagination with search filter

$tests = DB::table('view_tests')
    ->whereIn('metric_id',$metricsIds)
    ->where('name', '=', $var)
    ->paginate(4);
Copy code

Source: programmierfrage.com

Laravel 7 pagination with search filter

$tests = DB::table('view_tests')->whereIn('metric_id',$metricsIds)->paginate(4);

        $tests = $tests->filter(function ($item) use ($var) {
                    return false !== stristr($item->name, $var) || 
                    false !== stristr($item->section_name, $var) || 
                    false !== stristr($item->method, $var) || 
                    false !== stristr($item->limit, $var) || 
                    false !== stristr($item->accredited_detail, $var);

               return view('frontend.test_detailes',compact('tests'))->render();
Copy code

Source: programmierfrage.com

Similar codes

32 votes302 views2 answers
Add column migration laravel 8
PHP Laravel
0 vote273 views1 answer
Laravel Deploy in production
PHP Laravel
0 vote313 views1 answer
Referencing constant in config laravel
PHP Laravel
8 votes285 views4 answers
Laravel model soft delete
PHP Laravel
0 vote298 views2 answers
Create file in laravel
PHP Laravel
3 votes289 views2 answers
Return last inserted id in laravel
PHP Laravel
26 votes309 views6 answers
Laravel model with migration
PHP Laravel
10 votes257 views6 answers
Laravel blade date format
PHP Laravel
3 votes353 views6 answers
Email verification laravel
PHP Laravel
11 votes303 views5 answers
Get count laravel
PHP Laravel