mardi 22 septembre 2015

How to handle And Where and Or Where conditions in Lumen?

I have this query:

SELECT * FROM users 
WHERE 
gender = "$gender" AND country = "$country" 
AND ((city = "$city" AND status = "1") 
OR (status IN(2,3)))";

How can I write above query in Lumen ?

What I have tried so far is :

$users = User::where('country', '=', $country)
             ->where('gender', '=', $gender)
             ->where(function ($users) {
                    $users->where('city', '=', '$city')
                          ->where('status', '=', "1");
             })
             ->whereIn('status', [2, 3])
             ->first();

But this query doesn't returns the expected result.

Any idea what is the fault in my query?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire