/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

21 votes174 views5 answers
Laravel 7 auth command
PHP Laravel
2 votes109 views1 answer
Laravel slug route
PHP Laravel
0 vote163 views1 answer
Laravel model where set fields laravel
PHP Laravel
0 vote171 views2 answers
Save big data with laravel
PHP Laravel
8 votes143 views6 answers
Laravel collection unique
PHP Laravel
2 votes148 views2 answers
Laravel throw exception with status code
PHP Laravel
1 vote159 views1 answer
Integer nullable laravel
PHP Laravel
1 vote148 views1 answer
Config clear laravel
PHP Laravel
0 vote148 views2 answers
Laravel allow all fillable
PHP Laravel
14 votes123 views6 answers
Laravel migration set default value
PHP Laravel