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

9 votes178 views3 answers
Define url wordpress
PHP
0 vote180 views1 answer
Root composer.json requires PHP extension ext-gmp * but it is missing from your system. Install or enable PHP's gmp extension.
PHP
0 vote229 views4 answers
Sweetalert laravel
PHP Laravel
20 votes171 views5 answers
Carbon date from format
PHP
0 vote183 views1 answer
Php string mayusculas
PHP
6 votes190 views1 answer
How to calculate the difference between two dates
PHP
0 vote187 views1 answer
Laravel collection except
PHP
0 vote179 views1 answer
Executar comando linux php
PHP
0 vote228 views1 answer
Keep only n elements of array php
PHP
0 vote188 views1 answer
Php explode multiple delimiters
PHP