The user selects the class and enters the date, you need to display all existing entries for the selected class and date.

$check_class = Lesson::where('class',$class)->where(function ($query) use ($class) { $query->whereBetween('date_start',[$date_start, $date_end]) ->orWhereBetween('date_end',[$date_start, $date_end]); })->get();

This request gives

 "Undefined variable: date_start"

    1 answer 1

    I did it and it works)

     $check_class = Lesson::whereBetween('date_start',[$date_start, $date_end]) ->orWhereBetween('date_end',[$date_start, $date_end])->where(function ($query) use ($class){ $query->where('class',$class); })->count();