/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 vote211 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel
23 votes202 views4 answers
Laravel carbon isoformat
PHP Laravel
0 vote296 views5 answers
Laravel create multiple models at once
PHP Laravel
0 vote220 views1 answer
Laravel post request search query
PHP Laravel
1 vote206 views1 answer
How to save data from api to laravel
PHP Laravel
0 vote232 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel
1 vote209 views2 answers
How to make active color in menu laravel
PHP Laravel
2 votes176 views2 answers
Laravel create migration file
PHP Laravel
-1 vote159 views1 answer
Validate rule if row exist laravel
PHP Laravel
6 votes233 views3 answers
Current time in laravel migration
PHP Laravel