/PHP/Laravel/Laravel where condition with if

Laravel where condition with if

Laravel when condition

$invisiblePosts = $request->query('invisible');

Article::query()
            ->when($invisiblePosts , function ($query){
                return $query->where('invisible' , true);
            },function ($query){
                return $query->where('invisible' , false);
            })
            ->get();

Laravel where condition with if

$query = DB::table('user_ads')
            ->join('ads', 'users_ads.ad_id', '=', 'ads.id')
            ->orderBy($column, $method);

if ($input['search']) {
    $query->where('short_description', $input['search']);
}

if ($input['category']) {
    $query->where('category', $input['category']);
}

$query->join('users', 'users_ads.user_id', '=', 'users.id')
    ->select('ads.id', 'ads.img1', 'ads.short_description', 'ads.category', 'ads.product', 'ads.price', 'users.city')

$result= $query->get();

return $result;

Source: stackoverflow.com

Laravel if else condition in query

$query = SocialMediaFeed::where('location_id', $location_id);
if(!$filters) {
    $query = $query->where('self', '<>', true);
} else {
    $query = $query->orWhere('self', true);
}

-2

Source: stackoverflow.com

Similar codes

3 votes357 views3 answers
Insert timestamps manually in laravel
PHP Laravel
6 votes347 views2 answers
Laravel : commande introuvable
PHP Laravel
0 vote391 views1 answer
Laravel excel set cell height
PHP Laravel
0 vote332 views1 answer
Laravel count soft delete data
PHP Laravel
0 vote383 views1 answer
Laravel eloquent with query parameter
PHP Laravel
16 votes373 views3 answers
Laravel make model along with its controller and migration file
PHP Laravel
39 votes342 views6 answers
Create table laravel
PHP Laravel
0 vote360 views1 answer
Laravel Upsert always inserting
PHP Laravel
0 vote370 views1 answer
Counting time execution duration in time laravel
PHP Laravel
0 vote387 views1 answer
Set default value for column in laravel model
PHP Laravel