/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

44 votes298 views3 answers
Mcrypt_decrypt php 7.2
PHP
0 vote249 views1 answer
Like %% inside the string php
PHP
0 vote253 views1 answer
Does heat prevent radiation
PHP
0 vote307 views1 answer
Laravel checkbox checked
PHP Laravel
7 votes267 views6 answers
Sort laravel eloquent
PHP
5 votes296 views3 answers
Display all errors in blade laravel
PHP Laravel
1 vote257 views1 answer
Magento debug white page
PHP
5 votes254 views2 answers
Php get string size
PHP
1 vote265 views1 answer
Laravel word count utf8
PHP
0 vote729 views1 answer
Failed opening required 'PHPMailer\PHPMailer\PHPMailer'
PHP