/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 vote155 views1 answer
Install php apache
PHP
0 vote153 views1 answer
Php 2 decimal even if not exists
PHP
9 votes184 views2 answers
Php artisan storage link cpanel
PHP
0 vote195 views1 answer
Laravel 8 get app folder
PHP
0 vote153 views1 answer
Export PATH=/Applications/MAMP/bin/php/php5.4.10/bin:$PATH
PHP
0 vote215 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
0 vote308 views1 answer
Php first 20 words
PHP
0 vote186 views1 answer
A table was not found you might have forgotten to run your migrations. you can run your migrations using php artisan migrate. pressing the button below will try to run your migrations.
PHP
0 vote181 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote148 views2 answers
Php file download from url
PHP