Laravel 5.4 : How do I get records from just this week?

Question

为了获得当天的所有记录，我做了

$dt = Carbon::now();
$dataToday = Data::whereDay('created_at', $dt->day)->get();

为了获得本周的记录，我尝试了以下但没有成功。

$dataThisWeek = Data::where('created_at', $dt->weekOfYear);
$dataThisWeek = Data::where('created_at', $dt->weekOfMonth);
$dataThisWeek = Data::whereWeek('created_at', $dt->week);

我们如何使用 Eloquent 和 Carbon(最好)或 native MYSQL 函数来解决这个问题？

Answer 1

尝试这个:

Data::whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])->get();

设置周开始/结束:

Carbon::setWeekStartsAt(Carbon::SUNDAY);
Carbon::setWeekEndsAt(Carbon::SATURDAY);