Laravel 8 Eloqunet: How to set OR condition to where clause in Laravel

Admin 1
Viewed 3672

I want to show all the Orders from orders table where the status field of that table, equals to canceled OR ignored.

Currently my query goes like this:

$canceled = Order::where('status', 'canceled')
                  ->where('user_id', $uid)
                   ->latest()
                   ->paginate(2);

So how can I add ignored as well to the where clause here?

laravel-8 eloquent laravel php
2 Answers

I think whereIn will do the trick

$canceled = Order::whereIn('status', ['canceled','ignored'])
                   ->where('user_id', $uid)
                   ->latest()
                   ->paginate(2);
user_160021990

Try this query -

$canceled = Order::where(function($q) {
                   $q->where('status', 'canceled')
                      ->orWhere('status', 'ignored');
                    })
                    ->where('user_id', $uid)
                    ->latest()
                    ->paginate(2);
user_148517720
Related