/PHP/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

4 votes342 views5 answers
Get numbers from string php
PHP
0 vote385 views1 answer
Bu7scador con laravel
PHP Laravel
0 vote410 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
24 votes309 views4 answers
Laravel query not null
PHP
0 vote374 views1 answer
Prevent xss attack in laravel
PHP Laravel
2 votes316 views2 answers
Importing current year in laravel blade
PHP Laravel
0 vote316 views1 answer
Return json in middleware laravel
PHP
2 votes322 views2 answers
Allowed memory size of 1610612736 bytes exhausted 4096
PHP
22 votes285 views2 answers
The PHP Else If statement must be preceded by an If statement before it can be used.
PHP
0 vote310 views2 answers
Drupal set message
PHP