/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

3 votes141 views3 answers
Php artisan make services
PHP Laravel
23 votes195 views6 answers
Laravel 6 auth
PHP Laravel
3 votes193 views3 answers
Laravel get certain columns
PHP Laravel
1 vote190 views1 answer
Laravel active route check
PHP Laravel
7 votes198 views6 answers
Sort laravel eloquent
PHP Laravel
0 vote209 views1 answer
Laravel in array blade
PHP Laravel
0 vote188 views2 answers
Laravel filesystem
PHP Laravel
-2 votes219 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
0 vote187 views1 answer
Publish laravel scout
PHP Laravel
1 vote184 views1 answer
DB::connection('local')->create() laravel
PHP Laravel