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 vote229 views1 answer
Laravel weekly data
PHP Laravel
0 vote259 views1 answer
Laravel creating event get data
PHP
3 votes167 views1 answer
Laravel foreach index
PHP
0 vote197 views1 answer
Symfony retun json
PHP
0 vote228 views1 answer
Laravel console example
PHP Laravel
0 vote239 views1 answer
Laravel translation parameter send
PHP Laravel
5 votes198 views3 answers
Get users of specific role laravel role spatie
PHP
0 vote240 views2 answers
Get post title by post id wordpress
PHP
0 vote212 views1 answer
Determining if input is present in Laravel
PHP
1 vote270 views1 answer
Default index page for laravel in cpanel
PHP Laravel