/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

0 vote216 views1 answer
Laravel fetch max value
PHP Laravel
0 vote214 views2 answers
Laravel get namespace
PHP Laravel
1 vote282 views2 answers
Laravel JWTAuthentication
PHP Laravel
0 vote211 views1 answer
How to add a clock in laravel
PHP Laravel
3 votes256 views4 answers
Laravel where has Relation
PHP Laravel
0 vote318 views1 answer
Convert time to 24 hour format laravel
PHP Laravel
28 votes254 views6 answers
Laravel drop foreign key
PHP Laravel
23 votes228 views6 answers
Laravel select count
PHP Laravel
-4 votes222 views1 answer
Alert laravel 7
PHP Laravel
6 votes232 views4 answers
Laravel previous url
PHP Laravel