Group where conditions in laravel

<?php

$results = DB::table('table')
             ->where(function($query) use ($starttime,$endtime){
                 $query->where('starttime', '<=', $starttime);
                 $query->where('endtime', '>=', $endtime);
             })
             ->orWhere(function($query) use ($otherStarttime,$otherEndtime){
                 $query->where('starttime', '<=', $otherStarttime);
                 $query->where('endtime', '>=', $otherEndtime);
             })
             ->orWhere(function($query) use ($anotherStarttime,$anotherEndtime){
                 $query->where('starttime', '>=', $anotherStarttime);
                 $query->where('endtime', '<=', $anotherEndtime);
             })
             ->get();

Source: stackoverflow.com

Similar codes

7 votes293 views2 answers
Php compare string
PHP
0 vote350 views1 answer
Laravel store multiple files
PHP
1 vote347 views1 answer
Laravel get extension from url
PHP
28 votes262 views12 answers
Laravel middleware
PHP
2 votes377 views2 answers
How to add data to the request object in laravel
PHP Laravel
5 votes338 views2 answers
Php implode associative array
PHP
0 vote328 views1 answer
Laravel hiding attributes JSON
PHP Laravel
1 vote372 views1 answer
Laravel trans with parameters
PHP Laravel
1 vote380 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
1 vote284 views1 answer
Fopen(F:\xampp\htdocs\Escubydu\storage\fonts//themify_normal_f60486608aadd4e36c92c9895f99838f.ufm): failed to open stream: No such file or directory
PHP