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 vote167 views1 answer
Wordpress wpdb delete
PHP
0 vote240 views2 answers
How to set optional third parameter in routes of codeigniter
PHP CodeIgniter
0 vote217 views1 answer
Laravel allow null records relationship
PHP Laravel
0 vote157 views1 answer
Eloquent ORM means
PHP
0 vote147 views1 answer
Function id codeigniter 3
PHP
1 vote151 views1 answer
Php get bool from string
PHP
0 vote146 views1 answer
Atom emmet php
PHP
18 votes158 views6 answers
Redirect to route laravel
PHP
16 votes227 views2 answers
How to fetch data from database in php
PHP
0 vote171 views1 answer
How to display limited post content in wordpress
PHP Wordpress