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 vote244 views2 answers
Php pop up message
PHP
0 vote271 views1 answer
Php.hello
PHP
4 votes258 views5 answers
Laravel array_pluck
PHP Laravel
44 votes247 views4 answers
Deleting an element from an array in PHP
PHP
0 vote278 views1 answer
Thousand seperator php
PHP
0 vote270 views2 answers
General error: 1215 Cannot add foreign key constraint laravel
PHP
1 vote271 views2 answers
Php string replace space
PHP
0 vote263 views1 answer
Prety php
PHP
0 vote247 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP
19 votes256 views6 answers
Laravel Route Group
PHP