/PHP/Laravel/Group where conditions in laravel

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 votes154 views4 answers
Laravel route namespace and prefix
PHP Laravel
0 vote150 views1 answer
Laravel Secured Password
PHP Laravel
2 votes164 views2 answers
Laravel validation if data exists
PHP Laravel
0 vote153 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote151 views1 answer
Laravel mcq questions
PHP Laravel
4 votes221 views2 answers
Laravel sum group by
PHP Laravel
2 votes163 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel
0 vote156 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
0 vote173 views1 answer
Background image in laravel blade
PHP Laravel
6 votes162 views2 answers
Laravel findorfail
PHP Laravel