/PHP/Laravel/How to get yearly chart in laravel

How to get yearly chart in laravel

    public function getYearlyVisits()
    {
        $monthlyVisitors = DB::table('shorteners')
            ->select([
                DB::raw('YEAR(created_at) as year'),
                DB::raw('count(total_visits as total_visits'),
            ])
            ->groupBy('year')
            ->get();
    }

Source: stackoverflow.com

Similar codes

1 vote137 views2 answers
Laravel maximum execution time of 30 seconds exceeded
PHP Laravel
5 votes144 views2 answers
Laravel groupby and latest
PHP Laravel
0 vote154 views1 answer
Include navbar or part in layout in laravel blade template
PHP Laravel
0 vote142 views1 answer
Laravel store multiple files
PHP Laravel
3 votes170 views1 answer
Send multiple mail in laravel
PHP Laravel
46 votes180 views6 answers
Laravel make controller with model
PHP Laravel
0 vote141 views1 answer
Get records from Sunday to Sunday laravel
PHP Laravel
0 vote175 views1 answer
Laravel 8 created at format
PHP Laravel
24 votes155 views4 answers
Where not null in laravel
PHP Laravel
-1 vote156 views2 answers
String and number laravel faker
PHP Laravel