/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 votes263 views2 answers
Array_fill php
PHP
2 votes260 views2 answers
Twig create new array
PHP
21 votes280 views6 answers
Wordpress do shortcode
PHP
0 vote250 views2 answers
Php string max length
PHP
6 votes260 views3 answers
Array reverse php
PHP
0 vote248 views1 answer
Php get from second character of string to middle
PHP
2 votes291 views3 answers
Pdo db connection
PHP
1 vote277 views1 answer
Image uploading and validation php
PHP
0 vote275 views1 answer
Complete url php
PHP
1 vote259 views1 answer
Integer default value laravel
PHP