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

2 votes120 views1 answer
How to set ist in php
PHP
0 vote113 views1 answer
Complete url php
PHP
0 vote126 views1 answer
Bootstrap carousel foreach loop not working wordpressp php wp
PHP
0 vote143 views1 answer
How to get session variables from cookie string
PHP
0 vote129 views1 answer
Laravel count without pagination
PHP
1 vote131 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
0 vote208 views1 answer
Drupal 9 Get taxonomy term objects by vocabulary machine name vid
PHP Drupal
5 votes149 views5 answers
Table drop foreign php laravel
PHP Laravel
1 vote117 views1 answer
What is lang in laravel
PHP
0 vote117 views1 answer
Laravel redis sentinel
PHP