/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

0 vote198 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
0 vote210 views1 answer
Laravel get mysql column datatype
PHP Laravel
1 vote200 views1 answer
How handle the number with k in laravel balde
PHP Laravel
0 vote213 views1 answer
Ignore user id on email validation laravel
PHP Laravel
8 votes173 views1 answer
Laravel link storage to public
PHP Laravel
12 votes205 views5 answers
Laravel run single migration
PHP Laravel
0 vote200 views2 answers
Laravel collection sort by date
PHP Laravel
2 votes203 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
3 votes262 views2 answers
Laravel migration remove nullable
PHP Laravel
0 vote224 views1 answer
Merge two objects php laravel
PHP Laravel