Laravel execute where condition based on variable null or not

Question

I am new to laravel. I want to execute my where condition if my variable value is not null. I tried the below code exactly not getting an idea of what to do.

$search = $array['search'];
$id = $array['id'];
$Data = Model::where('id', '=', $id)

if($search != '') {
    //I want to include where condition here
}

You wish to include filter based on id and search or from search only? — Lijesh Shakya
– Lijesh Shakya, Commented Feb 1, 2021 at 3:42

IGP · Accepted Answer · 2021-02-01 03:44:51Z

3

Use Conditional Clauses

Model::when($search !== null, function ($query) use ($search) {
    return $query->where('column', $search);
})

answered Feb 1, 2021 at 3:44

IGP

16.4k5 gold badges35 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Test Human Over a year ago

$Data = DB::table('mytable')->where('id', '=', $Id) ->when(!is_null($searchBy) !== null, function ($query) use ($searchBy) { return $query->where('pid', '=', $searchBy)->orWhere('pname', 'like', '%' . $searchBy . '%')->orWhere('ps', 'like', '%' . $searchBy . '%'); })->get(); As per your answer, i build this query, but it didn't give me the appropriate result. My query should be like this select * from table where id=$id AND (pid = $searchby OR pname = $searchby OR ps = $searchby)

IGP Over a year ago

is_null($searchBy) !== null will always return false because is_null returns true or false. Either use when(is_null($search), ...) or when($search !== null, ...). Don't combine them.

Test Human Over a year ago

Got it. Can i use multiple conditions in when like this Model::when($search !== null && $search >0, function ($query) use ($search) { return $query->where('column', $search); })

IGP Over a year ago

You can do whatever you want as long as it evaluates to a bool.

lagbox · Accepted Answer · 2021-02-01 03:43:38Z

0

Your $Data variable is an Eloquent Query Builder object so you can add conditions to it for the query you are building:

if ($search) {
    $Data->where('field', $search);
}

answered Feb 1, 2021 at 3:43

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Collectives™ on Stack Overflow

Laravel execute where condition based on variable null or not

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related