/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 vote169 views1 answer
Wordpress get archive title
PHP Wordpress
0 vote200 views1 answer
Comment php laravel template blade
PHP
0 vote135 views1 answer
Hide all updates from WordPress
PHP
0 vote262 views1 answer
Laravel - access file from storage path - alternative to symlink
PHP Laravel
-1 vote175 views2 answers
Adding column to array php
PHP
0 vote187 views1 answer
Symfony blob file add
PHP Symfony
0 vote175 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
0 vote174 views1 answer
Get array key based on value php
PHP
3 votes147 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
0 vote169 views1 answer
Foreign key cosntraint laravel
PHP Laravel