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

laravel laravel-5 eloquent query-builder
Ugo Guazelli picture Ugo Guazelli · Jan 16, 2016 · Viewed 42.3k times · Source

I would like to execute the follow sentence using 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.

Answer

Marcin Nabiałek picture Marcin Nabiałek · Jan 16, 2016

You could use this:

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

Related questions

Laravel 5.1 Create or Update on Duplicate

In Laravel 5.1, for MySQL insert, I want to see if the record already exists and update on duplicate or create new if none exists. I have already searched SO where the answers were for old laravel versions. In one of …

Read More
Laravel upsert operations with Query Builder

In one of the my worker scripts to store aggregate counts based on some metrics, I am not using Eloquent as the queries are a little complex and and it is easy to write using query builder. I am currently …

Read More
Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More