How do I get a "select count(*) group by" using laravel eloquent
You could use this:
$reserves = DB::table('reserves')->selectRaw('*, count(*)')->groupBy('day');
As you wish to do it with Laravel Eloquent I assume you have a model name Reserve
. In this case you can use this
$reserve = Reserve::all()->groupBy('day')->count();
You could use:
#Laravel Raw Expressions $reserves = DB::table('reserves') ->select(DB::raw('count(*) as reserves_count')) ->groupBy('day') ->get();OR $reserves = Reserve::select(['reserves.*']) ->groupBy('day') ->count();
Further read here