我想在表中按天查询记录并按天分组,但它没有显示正确的数据
$VisitsTrends=DB::table('visits')
->select('created_at',DB::raw('count(*) as total'))
-> groupBy('created_at')->get();
dd($VisitsTrends);
它只是每次显示数据并计数不同
您可以使用
use IlluminateSupportFacadesDB;
//...
$VisitsTrends = Visit::groupBy('date')->get(array(
DB::raw('Date(created_at) as date'),
DB::raw('COUNT(*) as "total"')
));