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 vote256 views1 answer
SQLSTATE[22023]: Invalid parameter value:
PHP
3 votes276 views1 answer
Laravel inrandomorder
PHP Laravel
0 vote268 views1 answer
Get name of parent dir php
PHP
22 votes270 views6 answers
Where like in laravel
PHP
0 vote289 views1 answer
Codeigniter remote queries very slow
PHP
4 votes272 views4 answers
Delete all rows from table laravel
PHP Laravel
2 votes252 views3 answers
Orm
PHP
-2 votes291 views4 answers
Laravel get ID from insert
PHP Laravel
0 vote278 views1 answer
$score = $score + $bonus Score; return $score; php
PHP
5 votes221 views2 answers
Cmd download file
PHP