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

4 votes188 views2 answers
Laravel order by random
PHP Laravel
0 vote149 views1 answer
Push collection php
PHP
0 vote175 views2 answers
How to add woocommerce cart counter
PHP
-1 vote184 views1 answer
Element cakephp
PHP CakePHP
0 vote109 views1 answer
Cannot be cast automatically to type integer laravel
PHP
24 votes203 views4 answers
Laravel carbon isoformat
PHP
0 vote151 views1 answer
Php execute command and display output
PHP
1 vote155 views1 answer
Magento debug white page
PHP
0 vote157 views1 answer
Wordpress custom post type disable add new
PHP
2 votes193 views2 answers
Laravel get default locale
PHP Laravel