laravel requested



  • Please indicate how to optimize the request:

    select * from (select * from `bron` where DATE('2015-12-14') between `start` and `end`)t1 where nomer = '2';  
    

    and implemented by designer

    $bron_between2 = DB::table('bron')
    ->select(DB::raw("DATE('$date') between start and end"))
    ->where('nomer', $nomer)->get();
    


  • It's settled.

        $bron_between= DB::table('bron')
        ->whereRaw("DATE('$date') between start and end")
        ->where('nomer', '=', $nomer->id)
        ->get();
    


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2