/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 vote328 views1 answer
Laravel eloquent set timestamps values upon seed
PHP Laravel
31 votes276 views6 answers
Laravel update
PHP Laravel
0 vote302 views1 answer
Refresh web route laravel
PHP Laravel
0 vote292 views1 answer
Import facade URL laravel
PHP Laravel
1 vote265 views1 answer
Laravel latest
PHP Laravel
11 votes312 views5 answers
Laravel check auth
PHP Laravel
0 vote282 views1 answer
Confiruando passaport no laravel
PHP Laravel
1 vote316 views2 answers
Get current month laravel
PHP Laravel
6 votes331 views3 answers
How assign default value to laravel migration column
PHP Laravel
1 vote374 views1 answer
How laravel return the old value
PHP Laravel