/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

40 votes105 views6 answers
Laravel create migration
PHP Laravel
0 vote127 views1 answer
Laravel Service Unavailable
PHP Laravel
7 votes145 views2 answers
Laravel mail send to multiple recipients
PHP Laravel
1 vote114 views1 answer
Laravel difference between fill and update
PHP Laravel
1 vote110 views1 answer
Valet laravel
PHP Laravel
13 votes127 views5 answers
How to change validation message in laravel
PHP Laravel
0 vote150 views1 answer
Laravel deleted controller still cached
PHP Laravel
8 votes113 views3 answers
Check for an existing user laravel eloquent
PHP Laravel
1 vote117 views2 answers
Laravel get data from request
PHP Laravel
0 vote110 views1 answer
Create command laravel sample parameter
PHP Laravel