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

0 vote338 views2 answers
Where () laravel Eloquent
PHP
1 vote346 views1 answer
Laravel inRandomOrder
PHP
1 vote340 views1 answer
Call to undefined function str_limit() laaravel8
PHP
-1 vote423 views1 answer
Laravel migration table bigint
PHP Laravel
22 votes305 views2 answers
The PHP Else If statement must be preceded by an If statement before it can be used.
PHP
0 vote396 views1 answer
Href in laravel view
PHP Laravel
3 votes386 views1 answer
Laravel find by
PHP Laravel
13 votes356 views5 answers
Php get extension from string
PHP
0 vote329 views1 answer
Php explode and get first value
PHP
0 vote356 views2 answers
Remove number after decimal in php
PHP