/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 vote351 views1 answer
Laravel: Session message exist while click on browser back button
PHP Laravel
0 vote344 views2 answers
Adminlte con laravel 8
PHP Laravel
5 votes352 views2 answers
Check session in blade laravel
PHP Laravel
0 vote326 views1 answer
Laravel parse markdown
PHP Laravel
19 votes359 views5 answers
Php artisan auth in laravel 8
PHP Laravel
0 vote355 views1 answer
Laravel app running in console
PHP Laravel
2 votes327 views3 answers
Laravel fortify
PHP Laravel
18 votes355 views1 answer
Schema::default string laravel
PHP Laravel
0 vote354 views1 answer
Italic text in laravel notification
PHP Laravel
0 vote356 views3 answers
Laravel get all records order by
PHP Laravel