/PHP/Laravel/Group where conditions in laravel

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 vote189 views2 answers
Laravel file upload
PHP Laravel
0 vote160 views1 answer
Laravel follow and unfollow relationship
PHP Laravel
0 vote222 views1 answer
Macos how host laravel website on localhost and intranet wifi
PHP Laravel
9 votes167 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
1 vote164 views1 answer
Laravel carbon time format AM PM
PHP Laravel
0 vote169 views1 answer
Laravel console example
PHP Laravel
0 vote154 views3 answers
Laravel postgres deadlock
PHP Laravel
0 vote166 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP Laravel
0 vote151 views1 answer
Laravel validate form data unique array
PHP Laravel
8 votes163 views6 answers
Laravel validation date
PHP Laravel