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 vote227 views1 answer
Onclick call route laravel
PHP Laravel
0 vote239 views1 answer
Pdo mysqli error handling
PHP
0 vote206 views3 answers
Laravel validation alphanumeric with spaces
PHP
6 votes190 views3 answers
Laravel collection put
PHP
0 vote255 views2 answers
Transient wordpress
PHP Wordpress
0 vote200 views1 answer
Wordpress get posts by multiple authors
PHP Wordpress
0 vote205 views1 answer
Codeingniter 3 not like
PHP
0 vote203 views1 answer
Request update password laravel
PHP Laravel
0 vote184 views1 answer
Php call method from another class
PHP
0 vote171 views1 answer
How to auto increment id after delete value in php mysql
PHP