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 vote132 views1 answer
SetUp() must be compatible with Illuminate\Foundation\Testing\TestCase::setUp()
PHP
1 vote153 views3 answers
Php dump
PHP
60 votes130 views6 answers
Php artisan make migration
PHP
0 vote124 views1 answer
Read xml file in php wordpress
PHP
0 vote154 views1 answer
Spatie sluggable not working
PHP
0 vote133 views1 answer
Php pdo setting error modes
PHP
1 vote144 views1 answer
Wp add_action
PHP Wordpress
18 votes105 views4 answers
Carbon time laravel
PHP
0 vote183 views1 answer
How to make core controller codeigniter 3 more than 1
PHP CodeIgniter
6 votes149 views4 answers
Illuminate database queryexception could not find driver laravel
PHP