/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 vote385 views1 answer
Php laravel intervention base64 to image save
PHP Laravel
7 votes355 views6 answers
Set session in laravel
PHP Laravel
2 votes412 views1 answer
Multiple routes same controller laravel
PHP Laravel
0 vote382 views1 answer
Laravel repository update multiple row
PHP Laravel
25 votes364 views6 answers
Laravel use cache
PHP Laravel
1 vote381 views1 answer
Laravel blade skip entry
PHP Laravel
3 votes364 views2 answers
Name csrf token laravel mismatch
PHP Laravel
0 vote398 views1 answer
Laravel select option form add please select option
PHP Laravel
0 vote381 views1 answer
Boot add schema in laravel
PHP Laravel
2 votes365 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP Laravel