Level 29
You can chain your wheres, like where(condition1 ...) -> where(condition2) -> get();
Also, check out whereRaw if you need to do some modification on the fields.
Mar 18, 2016
7
Level 15
Eloquent date range and multiple where
How can I do a SELECT where a date is < three weeks old and also matches an ID?
Bit like this:
$availableProductID = AvailableProduct::where('product_id', '=', $productID, 'made_available', '<', $weeksAvailableFor )->get();
Level 15
Got the chaining working now.
Now I want to do WHERE (made_available + 3 weeks) < today
Can I do that in one hit?
Level 29
->where('made_available ', '<', Carbon::now()->addWeeks(-3))
Level 54
$results = AvailableProduct::where('product_id', '=', $productID)
->where('made_available', '<', Carbon::now()->subWeeks(3))
->get();
1 like
Level 15
Thanks, was having a mental block with that!
Level 29
Really ??
Level 15
Yes ???
Please or to participate in this conversation.