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 vote179 views1 answer
Mongodb uploading csv php
PHP
1 vote237 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote158 views1 answer
<?php echo do_shortcode('[gravityform id="1" title="false" description="false" ajax="true"]') ?>
PHP
0 vote215 views3 answers
Laravel 'Choice question must have at least 1 choice available.'
PHP Laravel
0 vote254 views1 answer
Laravel display old value in form
PHP Laravel
0 vote196 views1 answer
Laravel migration unknown column type double requested
PHP
0 vote216 views1 answer
Eloquent limit vs take
PHP
1 vote201 views1 answer
$this
PHP
2 votes237 views1 answer
Laravel time to human redable format
PHP Laravel
0 vote249 views1 answer
Limiter la révision des articles WordPress
PHP