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 votes127 views1 answer
How to modify a string that’s passed by reference in php
PHP
-1 vote127 views2 answers
Get array of last 3 dates with carbon
PHP
21 votes152 views6 answers
Laravel seeder update
PHP Laravel
0 vote223 views2 answers
Array collapse laravel
PHP Laravel
0 vote124 views1 answer
Yii2 clear schema cache
PHP
1 vote151 views1 answer
Laravel uppercase first letter
PHP Laravel
0 vote126 views4 answers
There is no extension able to load the configuration for "_translation_webui"
PHP
0 vote175 views3 answers
Is_unique in codeigniter form validation
PHP CodeIgniter
0 vote137 views2 answers
Laravel apiresource
PHP
0 vote154 views1 answer
Redirect to intent url after login laravel
PHP Laravel