How to write conditional query in laravel 5.2?

Question

How can I write this kind of queries in laravel 5.2 eloquent or query builder?

$query = Customers::leftjoin('Query string');    
if(condition)
    {
        //This part added to query   
    }
    else
    {
        //This part added to query
    }
->get();

Please read how to ask - stackoverflow.com/help/how-to-ask. Its a good idea to have a tight title. — micstr
– micstr, Commented Oct 11, 2016 at 15:30

user1897253 · Accepted Answer · 2016-10-11 11:18:02Z

4

You have to remember your query in a variable, I.E. like this:

$query = Customers::leftjoin('Query string');   

if(condation){
    $query = $query->where('something', '=', 'something');
} else {
    $query = $query->where('somethingelse', '=', 'somethingelse');
}

$query = $query->get();

Normally you would have $query->where()-get();, which is basically the same thing, $query will hold the result of your ->where() and allows you to chain further on $query

answered Oct 11, 2016 at 11:18

user1897253

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

Collectives™ on Stack Overflow

How to write conditional query in laravel 5.2?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related