/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 vote225 views2 answers
Laravel bootstrap navbar active
PHP Laravel
5 votes232 views1 answer
Eloquent chunk laravel model chunk
PHP Laravel
0 vote181 views1 answer
Target class [BannerController] does not exist.
PHP
3 votes186 views2 answers
Php rand vs mt_rand
PHP
1 vote191 views1 answer
Ubuntu php7.4-curl : Depends: libcurl3 (>= 7.44.0) but it is not going to be installed E: Unable to correct problems, you have held broken packages.
PHP
0 vote228 views1 answer
How to add page link in laravel
PHP Laravel
0 vote182 views1 answer
Image::make en php
PHP
0 vote229 views2 answers
Curl post laravel
PHP Laravel
3 votes194 views3 answers
Send attachment in mail php
PHP
5 votes246 views2 answers
Laravel groupby and latest
PHP Laravel