如何使用 Laravel eloquent 获得“选择计数（*）组”

How do I get a "select count(*) group by" using laravel eloquent

提问by Ugo Guazelli

I would like to execute the follow sentence using laravel eloquent

我想使用 laravel eloquent 执行以下语句

SELECT *, count(*) FROM reserves  group by day

The only solution occurs to me is to create a view in the DB, but I am pretty sure there is a way to do it in laravel way.

我想到的唯一解决方案是在数据库中创建一个视图，但我很确定有一种方法可以用 laravel 的方式来做到这一点。

回答by Marcin Nabia?ek

You could use this:

你可以用这个：

$reserves = DB::table('reserves')->selectRaw('*, count(*)')->groupBy('day');

回答by smartrahat

As you wish to do it with Laravel Eloquent I assume you have a model name Reserve. In this case you can use this

当您希望使用 Laravel Eloquent 时，我假设您有一个模型名称Reserve。在这种情况下，您可以使用此

$reserve = Reserve::all()->groupBy('day')->count();

回答by Khine Thu

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

进一步阅读这里