/PHP/Laravel/Laravel Eloquent, group by month/year

Laravel Eloquent, group by month/year

$model->select(DB::raw('count(id) as `data`'), DB::raw("DATE_FORMAT(created_at, '%m-%Y') new_date"),  DB::raw('YEAR(created_at) year, MONTH(created_at) month'))
->groupby('year','month')
->get();

Similar codes

-1 vote193 views1 answer
Return true false laravel
PHP Laravel
0 vote190 views1 answer
Laravel maintenance mode custom class
PHP Laravel
7 votes180 views6 answers
Laravel url
PHP Laravel
0 vote200 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
51 votes511 views6 answers
Create model with controller laravel
PHP Laravel
0 vote207 views1 answer
Entrust laravel
PHP Laravel
0 vote183 views1 answer
Laravel API Endpoint "401 Unauthorized" on Server But Works Fine On Localhost
PHP Laravel
0 vote225 views1 answer
How to retrieve data from database using select option in laravel
PHP Laravel
0 vote187 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
39 votes132 views2 answers
Create request laravel command
PHP Laravel