put an if condition around where clause in laravel query

Hi,

Laravel query, we have a where clause.

->where('addresses.city_id',$city_id)

I want to apply this where clause if the city_id > 0. If the city_id =0, then I would not like to pass this where clause to the query. Can I do something like

$query = DB::table('users')->select('first_name') If($city_id > 0) { ->where('addresses.city_id',$city_id) } ->get();

If not, where would be the other possible options?

Nakov

5 years ago

Level 73

You can use when() for that:

DB::table('users')->select('first_name')
	->when($city_id > 0, function($query) use ($city_id) {
            $query->where('addresses.city_id',$city_id);
        })->get();

More here: https://laravel.com/docs/8.x/queries#conditional-clauses

Please or to participate in this conversation.