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

4 votes215 views2 answers
How to Get Last Executed Query in Laravel
PHP Laravel
0 vote216 views1 answer
Php get parent url from script location
PHP
33 votes162 views4 answers
Make:controller in laravel 8
PHP
2 votes150 views2 answers
Laravel create migration file
PHP Laravel
-1 vote167 views1 answer
Composer cache clean
PHP
0 vote190 views1 answer
Double in migration laravel
PHP Laravel
7 votes160 views4 answers
With message in laravel
PHP
12 votes154 views2 answers
Php while loop array
PHP
1 vote159 views2 answers
Getting last day of next month in php
PHP
12 votes263 views2 answers
Timestamp false in laravel
PHP