/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

0 vote259 views1 answer
Array.diff solution
PHP
2 votes243 views1 answer
Varchar max length define laravel migration
PHP Laravel
0 vote256 views1 answer
Wordpress add_action echo on edit page
PHP
0 vote300 views1 answer
Execute sql query codeigniter
PHP
3 votes273 views2 answers
Confirm before submit form php
PHP
0 vote274 views1 answer
Twig to pdf
PHP
0 vote244 views1 answer
Where condition in array in codeigniter
PHP
8 votes269 views5 answers
Laravel route is current route
PHP
0 vote329 views4 answers
Laravel backup
PHP Laravel
0 vote294 views1 answer
Return false inside loop of function php
PHP