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 vote373 views1 answer
Get post by name wordpress
PHP Wordpress
0 vote342 views1 answer
Laravel creating_table_name
PHP Laravel
2 votes315 views2 answers
Add two numbers as string in php
PHP
2 votes307 views3 answers
Kill phpstorm
PHP
2 votes301 views3 answers
Laravel get input from request
PHP
1 vote444 views1 answer
Symfony get path to route
PHP Symfony
1 vote261 views1 answer
Laravel request integer
PHP
0 vote349 views5 answers
Date format change in laravel
PHP Laravel
12 votes338 views3 answers
Php read csv file line by line
PHP
13 votes420 views2 answers
Wp get logged in user id
PHP Wordpress