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

2 votes137 views1 answer
Wordpress get post time
PHP
0 vote140 views1 answer
Array session
PHP
0 vote151 views1 answer
Thousand seperator php
PHP
113 votes322 views6 answers
Date time in php
PHP
6 votes186 views4 answers
Laravel set config
PHP
0 vote167 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote133 views1 answer
Switch php version ubuntu 20.04 site:stackoverflow.com
PHP
1 vote124 views1 answer
Php namespace class
PHP
7 votes135 views5 answers
Laravel slug
PHP
1 vote108 views1 answer
Where () mayor que laravel Eloquent
PHP Laravel