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 vote162 views1 answer
Create a custom method laravel model
PHP
0 vote144 views1 answer
How to Get Radio Button Value in PHP Without Submit
PHP
0 vote133 views1 answer
Wordpress function _() not working
PHP
0 vote225 views10 answers
Laravel relations find
PHP
-1 vote162 views1 answer
Views_pre_view
PHP
2 votes144 views2 answers
Laravel migration remove unique
PHP
0 vote167 views1 answer
Executar comando linux php
PHP
3 votes153 views1 answer
Codeigniter check affected rows
PHP
4 votes175 views5 answers
Laravel storage
PHP
12 votes158 views3 answers
How to log object laravel logger
PHP Laravel