Level 39
How can I specify that if the first condition is true, to not check the rest ?
Like you wrote.
Are you sure your error don't come form $enchere->prix that can be Null
Try, $enchere->prix ?? 0
May 20, 2021
1
Level 1
Laravel Query whereNull orWhere
Hello, i have to retreive a collection of products where the price is null or under a value. $products = Product::where('envoi_encheres',1) ->where(function ($query) use ($enchere) { $query->whereNull(self::PRIX_MIN) ->orWhere(self::PRIX_MIN, '<=', $enchere->prix); })
But when the product has a price at NULL, the line orWhere(self::PRIX_MIN, '<=', $enchere->prix); returns an "illegal operator and value combination" so even if the whereNull is true it does the orWhere test. How can I specify that if the first condition is true, to not check the rest ?
Thank you !!!
Please or to participate in this conversation.