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

42 votes201 views5 answers
Laravel create controller command
PHP Laravel
1 vote178 views1 answer
$_GET["name"]
PHP
0 vote172 views1 answer
Laravel login shows 404
PHP
0 vote166 views1 answer
Ternary operator for three conditions in php
PHP
-4 votes193 views2 answers
Why we use pusher in laravel
PHP
0 vote187 views2 answers
Woocommerce_variation_option_name on frontend
PHP
0 vote159 views1 answer
Dot after each character php
PHP
0 vote177 views3 answers
Laravel where json array column
PHP
0 vote175 views1 answer
Remove element from xml on php
PHP
1 vote177 views1 answer
Wp_list_custom_post type
PHP