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

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

$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函数来实现这一目标？

最佳答案

尝试这个:

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

设置星期的开始/结束:

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

关于laravel - Laravel 5.4 : How do I get records from just this week?，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/44473685/