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

24 votes347 views4 answers
Laravel query not null
PHP Laravel
1 vote336 views1 answer
Searching and removing element from an array php
PHP
3 votes333 views1 answer
How can I prevent SQL injection in PHP?
PHP
0 vote377 views2 answers
Laravel login register api
PHP
2 votes334 views1 answer
Laravel wherin softdelete
PHP
0 vote345 views2 answers
Php header pdf
PHP
1 vote369 views2 answers
Laravel observer get old value
PHP Laravel
0 vote347 views1 answer
Cara membuat looping table dengan php
PHP
0 vote370 views2 answers
Get post title by post id wordpress
PHP
2 votes325 views1 answer
Interval Between Different Dates
PHP