Laravel count group by date

    $usersData = User::select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as total'))
            ->groupBy('date')
            ->orderBy('date', 'desc')
            ->take(7)
            ->get();

Similar codes

1 vote102 views1 answer
Php sql sever connection code
PHP
0 vote119 views2 answers
Send email php smtp
PHP
1 vote139 views3 answers
Delete a migration laravel
PHP Laravel
2 votes148 views1 answer
Command to delete storage logs in laravel
PHP Laravel
9 votes143 views5 answers
Php get day number
PHP
0 vote113 views1 answer
Laravel collection pipe
PHP
2 votes112 views1 answer
File_put_contents php json file
PHP
0 vote116 views2 answers
Sorting sql query array by column key php
PHP
10 votes118 views2 answers
Php json data to array
PHP
4 votes162 views2 answers
Php http method
PHP