/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

17 votes155 views6 answers
Update query laravel
PHP Laravel
0 vote199 views2 answers
Laravel lumen
PHP Laravel
2 votes192 views1 answer
Laravel how to test email testing
PHP Laravel
0 vote160 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
0 vote165 views1 answer
Write if and else in one line laravel
PHP Laravel
1 vote176 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
21 votes178 views5 answers
Laravel 7 auth command
PHP Laravel
1 vote155 views2 answers
Get all laravel validation failed messages
PHP Laravel
13 votes174 views5 answers
Laravel get last record
PHP Laravel
33 votes216 views6 answers
Migrate specific migration laravel
PHP Laravel