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 vote158 views1 answer
Undefined type excel
PHP
0 vote160 views1 answer
Markdown mail html rendering laravel
PHP
0 vote223 views1 answer
How to create an Invoice with watermark FPDF
PHP
1 vote204 views4 answers
How to fix 419 page expired in laravel
PHP Laravel
9 votes165 views4 answers
Php check if string ends with
PHP
0 vote161 views1 answer
Run php code file
PHP
15 votes317 views6 answers
Wordpress shortcode
PHP Wordpress
0 vote193 views1 answer
Wordpress if admin
PHP Wordpress
0 vote172 views1 answer
Convert am pm time to 24 hour in php
PHP
0 vote177 views2 answers
Check if $_files is empty php
PHP