Level 27
You should be able to use orWhere: https://laravel.com/docs/7.x/queries#where-clauses
Jun 15, 2020
4
Level 1
Get Events which overlap with FullCalendar View start and end Date
I need a little help regarding the syntax of Eloquent. I want to add more where clauses but can't get the OR working.
Works:
$events = DB::table('events')->select('id','resourceId','title','start','end')
->whereDate('start', '>=', $start)->whereDate('end', '<=', $end)->get();
Does not work:
$events = DB::table('events')->select('id','resourceId','title','start','end')
->whereDate('start', '>=', $start)->whereDate('end', '<=', $end) OR
->whereDate('start', '<=', $start)->whereDate('end', '>=', $end)->get();
Level 1
No luck so far with
$events = DB::table('events')->select('id','resourceId','title','start','end')
->whereDate('start', '>=', $start)->whereDate('end', '<=', $end)
->orWhere(function($query) {
$query->whereDate('start', '<=', $start)
->whereDate('end', '>=', $end);
})
->get();
Is orWherenot supposed to work with whereDate?
Level 1
Please share error message
Level 1
500 : Internal Server Error
...it's an invalid query.
Please or to participate in this conversation.