/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 vote246 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP Laravel
51 votes280 views6 answers
Left join laravel
PHP Laravel
1 vote199 views1 answer
Get data based on date in laravel
PHP Laravel
0 vote213 views1 answer
Laravel controller create command in a folder
PHP Laravel
0 vote215 views1 answer
Laravel model insert multiple
PHP Laravel
2 votes251 views1 answer
Laravel time to human redable format
PHP Laravel
3 votes224 views2 answers
Name csrf token laravel mismatch
PHP Laravel
0 vote240 views1 answer
Create laravel project 8.16.1
PHP Laravel
7 votes229 views3 answers
Laravel 8 validation unique 2 columns
PHP Laravel
1 vote235 views1 answer
Laravel blade skip entry
PHP Laravel