/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 vote248 views1 answer
Loop laravel 8
PHP Laravel
7 votes262 views3 answers
One to many laravel
PHP Laravel
1 vote273 views2 answers
Laravel get url parameter value in controller
PHP Laravel
2 votes277 views3 answers
Laravel auth check login
PHP Laravel
0 vote249 views1 answer
Php laravel convert blob type to string
PHP Laravel
6 votes262 views5 answers
Laravel collection map
PHP Laravel
0 vote335 views2 answers
Save big data with laravel
PHP Laravel
0 vote306 views1 answer
Redirect to intent url after login laravel
PHP Laravel
0 vote314 views1 answer
Laravel download file change name
PHP Laravel
0 vote268 views1 answer
Import facade URL laravel
PHP Laravel