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 vote182 views6 answers
Create global function laravel
PHP
4 votes221 views1 answer
Laravel relation of relation
PHP
2 votes190 views2 answers
Check if date between two dates laravel
PHP
1 vote180 views2 answers
Force https redirection laravel
PHP
1 vote176 views1 answer
What does $ sign mean in php
PHP
8 votes190 views4 answers
Laravel between dates
PHP
3 votes279 views2 answers
How to get file extension in laravel
PHP
3 votes194 views2 answers
Search function using php for database entries
PHP
0 vote241 views3 answers
Embed the site when you click on the link laravel
PHP Laravel
2 votes209 views2 answers
Laravel valet 504 gateway time-out
PHP Laravel