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

1 vote199 views3 answers
Laravel artisan command run in route
PHP Laravel
0 vote221 views1 answer
Laravel display the date the participation was created
PHP Laravel
12 votes195 views2 answers
Php array get value at index
PHP
0 vote216 views1 answer
Laravel run seeder enter timestamps
PHP
0 vote172 views2 answers
Readable var dump php
PHP
0 vote267 views1 answer
Activerecord yii2 select with limit(start,end) not working
PHP
0 vote196 views1 answer
Launch new tab and refresh original page codeigniter
PHP
4 votes178 views1 answer
PHP artisan create model and seeder shortcut
PHP
4 votes149 views1 answer
Disable register laravel
PHP
0 vote227 views1 answer
Create a button add in laravel
PHP Laravel