使用Laravel 4选择MySQL中时间范围内的记录

Question

Hello everyone I am having a problem I cant figure out. I have a database with a couple of columns. title, body, start, and end.

The start and end columns are of the datetime type. I have rows in my database with start and end dates.

I am trying to select all rows that fall within a date range. In this case a 24 hour span.

So for example, if i have a row that has a start day of today(Sept. 24, 2013) and an end date of Jan. 1, 2014, I expect it to be returned.

Route::get('/', function()
{
//Start of Day
$start = date('Y-m-d 00:00:00');

//End of Day    
$end = date('Y-m-d 23:59:59'); 

$data['flyers'] = Flyer::where('start', '>=', $start)->where('end', '<=', $end)->get();

//return homepage
return View::make('view', $data);
});

Thanks in advance. I will post my answer if I figure it out first.

Answer 1

The comparison operators on your where() calls are backwards. The way your code is now, you are only selecting Flyers that start and end today. What you want is this:

$data['flyers'] = Flyer::where('start', '<=', $start)->where('end', '>=', $end)->get();