/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

2 votes92 views3 answers
How to get the size of an uploaded file in laravel
PHP
0 vote92 views1 answer
Quiz
PHP
1 vote106 views1 answer
Wordpress hook add javascript
PHP
0 vote95 views1 answer
Obtener datos de orden wordpress php
PHP
5 votes100 views6 answers
Array sort php
PHP
1 vote137 views1 answer
Laravel return list of ids
PHP Laravel
0 vote112 views3 answers
Get category name by id wordpress
PHP Wordpress
16 votes112 views4 answers
Wherenotnull laravel
PHP Laravel
0 vote105 views1 answer
Laravel subtract date
PHP Laravel
0 vote93 views2 answers
Codeigniter 4 limit query
PHP