/PHP/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

5 votes321 views2 answers
In laravel date duration validation rule
PHP Laravel
0 vote431 views1 answer
Régler l’enregistrement automatique dans WordPress
PHP Wordpress
0 vote328 views1 answer
Cron job every 5 minutes wordpress
PHP Wordpress
1 vote223 views2 answers
Wordpress get post slug
PHP
11 votes287 views4 answers
Laravel validator make custom message
PHP
0 vote261 views1 answer
Laravel vue error 500
PHP
0 vote247 views1 answer
Upper php
PHP
0 vote284 views2 answers
Php get duplicate keys in array without using inbuilt function
PHP
0 vote332 views1 answer
If post checked category wordpress
PHP Wordpress
7 votes351 views3 answers
Php get this week date range
PHP