/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 votes310 views4 answers
Wordpress get plugin root directory
PHP Wordpress
2 votes302 views1 answer
Laravel create search
PHP
5 votes280 views3 answers
Laravel drop column if exists
PHP
0 vote268 views1 answer
Json_encode alternative
PHP
3 votes292 views2 answers
Laravel collection concat
PHP Laravel
0 vote329 views1 answer
Wordpress fs_method direct
PHP Wordpress
6 votes351 views2 answers
Laravel 6 get user id
PHP Laravel
6 votes330 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
15 votes365 views6 answers
Wordpress create shortcode
PHP Wordpress
0 vote277 views2 answers
How to link external php file to html
PHP