fetching data from db based on datetime using laravel query

Question

I am trying to fetch data from database based on datetime in laravel. But the result returns empty array.When I use the raw query from log file in MYSQL,It displays the results. Thanks In Advance

Below is my laravel query

public function lists(){
$start_date = '20-5-2015';
$end_date = '28-5-2015';
$str_start_date = date("Y-m-d H:i:s",strtotime($start_date));
$str_end_date = date("Y-m-d H:i:s",strtotime($end_date));
$result = DB::table('a')
    ->where('start_date_time','>=',"'$str_start_date'")
    ->where('end_date_time','<=',"'$str_end_date'")
    ->select('a.*')
    ->get();
 dd($result);
}

Below is my raw query for the above laravel query

select `a`.* from `a` where `start_date_time` >= '2015-05-20 00:00:00' and `end_date_time` <= '2015-05-28 00:00:00'

Marc B · Accepted Answer · 2015-06-03 14:10:54Z

2

->where('start_date_time','>=',"'$str_start_date'")
                                ^---------------^

You're embedding extra quotes inside your values...

answered Jun 3, 2015 at 14:10

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fetching data from db based on datetime using laravel query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related