/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

13 votes155 views5 answers
Laravel validation custom message example
PHP Laravel
0 vote238 views1 answer
Laravel not rollback even has error
PHP Laravel
0 vote158 views3 answers
Laravel remove duplicates from array
PHP Laravel
5 votes143 views2 answers
Throwexception laravel
PHP Laravel
0 vote156 views2 answers
Loop variable in laravel
PHP Laravel
2 votes148 views1 answer
Laravel 8 previous page
PHP Laravel
8 votes139 views1 answer
Object not found in laravel xampp
PHP Laravel
0 vote242 views1 answer
Show sender name laravel
PHP Laravel
2 votes103 views2 answers
Laravel select query return array
PHP Laravel
0 vote176 views1 answer
How to update request all value in laravel controller before save in database
PHP Laravel