/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

1 vote227 views1 answer
Wordpress escape string
PHP Wordpress
0 vote161 views1 answer
Http error code php
PHP
2 votes167 views1 answer
Laravel where update query
PHP
0 vote200 views1 answer
Php mysql datetime format string
PHP
3 votes154 views2 answers
Sum of multidimensional array in php
PHP
0 vote246 views1 answer
Show data as per url slug change in laravel
PHP Laravel
1 vote180 views1 answer
Laravel 6 make http request
PHP Laravel
1 vote165 views1 answer
Laravel websockets onclose
PHP
0 vote211 views1 answer
Laravel components scripts
PHP Laravel
0 vote159 views1 answer
Php date from mysql and date
PHP