/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

0 vote295 views1 answer
Css en linea php
PHP
23 votes293 views6 answers
Laravel select count
PHP Laravel
1 vote330 views1 answer
Date casting from datetime to d-m-Y laravel
PHP Laravel
0 vote312 views1 answer
Laravel custom validation check if valid url
PHP
1 vote300 views2 answers
Laravel check collection has key
PHP
13 votes302 views6 answers
Laravel migration change column type
PHP Laravel
12 votes347 views3 answers
How to remove composer package in laravel
PHP
0 vote300 views1 answer
Php class comment
PHP
-1 vote282 views1 answer
Return true false laravel
PHP
6 votes316 views2 answers
Laravel route regex except
PHP