/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

0 vote116 views1 answer
Datetime-local laravel migration data type
PHP Laravel
3 votes137 views6 answers
Laravel jwt token
PHP Laravel
2 votes122 views2 answers
Laravel get file in public folder
PHP Laravel
1 vote108 views1 answer
How create page 419 in laravel
PHP Laravel
1 vote111 views2 answers
Laravel view data
PHP Laravel
13 votes125 views5 answers
Laravel validation custom message example
PHP Laravel
0 vote128 views3 answers
Count with left join in laravel
PHP Laravel
50 votes245 views6 answers
Laravel migration add column to existing table
PHP Laravel
9 votes112 views6 answers
Pluck laravel
PHP Laravel
2 votes114 views2 answers
Confirm popup laravel
PHP Laravel