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 vote104 views1 answer
Laravel chunk select
PHP
5 votes112 views3 answers
PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes)
PHP
1 vote125 views1 answer
Wp get field taxonomy
PHP
1 vote114 views1 answer
Install php mysql extension ubuntu
PHP
7 votes118 views3 answers
Laravel append array to array
PHP
0 vote125 views1 answer
Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at http://vtl-lab.com/VN/crecc-cms/api/member/register.json. (Reason: CORS request did not succeed).
PHP
25 votes100 views1 answer
Write php online
PHP
13 votes110 views6 answers
Named route with parameter laravel
PHP
0 vote152 views1 answer
How to increase the WordPress Multisite Network limit for Maximum Filesize Upload?
PHP Wordpress
0 vote137 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter