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

0 vote321 views1 answer
Pre_get_posts get product by tag php\
PHP
2 votes339 views2 answers
Add [nom] to fillable property to allow mass assignment
PHP
2 votes331 views2 answers
Confirm popup laravel
PHP Laravel
0 vote312 views1 answer
Laravel dateinterval not found
PHP
24 votes321 views4 answers
Get PHP Date Time Difference in Days, Hours, Minutes, and Seconds
PHP
3 votes332 views1 answer
Laravel validation pdf
PHP
3 votes319 views1 answer
Carbon parse subday
PHP
0 vote333 views1 answer
Separate numbers with commas laravel
PHP
3 votes385 views3 answers
Laravel clear table
PHP Laravel
3 votes326 views1 answer
Wherehas laravel search
PHP