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

6 votes193 views2 answers
Laravel check if request has value
PHP
4 votes215 views1 answer
Limit offset array php
PHP
1 vote210 views1 answer
Cart laravel
PHP
0 vote198 views1 answer
Header in fpdi
PHP
1 vote232 views1 answer
Doctrine php driver execption
PHP
0 vote189 views1 answer
Features of PHP7
PHP
0 vote249 views1 answer
Htaccess post max size
PHP
-2 votes235 views1 answer
Laravel if else condition in query
PHP Laravel
0 vote194 views2 answers
Laravel get request in blade
PHP
0 vote215 views1 answer
Return view inside subfolder laravel
PHP