/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

1 vote391 views2 answers
How to get data from a table in laravel
PHP Laravel
0 vote382 views1 answer
Autogenerate slug for model laravel
PHP Laravel
0 vote373 views1 answer
Laravel faker title
PHP Laravel
11 votes391 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
12 votes381 views5 answers
Laravel transactions
PHP Laravel
1 vote402 views1 answer
How to add dummy records using factory in laravel 8
PHP Laravel
1 vote378 views1 answer
Laravel form action with parameter
PHP Laravel
0 vote348 views1 answer
Laravel username validation
PHP Laravel
1 vote358 views1 answer
Laravel collection toJson
PHP Laravel
1 vote404 views1 answer
Laravel return list of ids
PHP Laravel