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 vote321 views1 answer
Laravel get current action name
PHP
6 votes336 views4 answers
Enset laravel session
PHP Laravel
7 votes331 views1 answer
Rollback laravel transaction
PHP Laravel
0 vote361 views1 answer
Delay queue laravel
PHP
0 vote350 views1 answer
Php nginx file not found
PHP
34 votes371 views6 answers
Php random number
PHP
0 vote366 views1 answer
Php implode as key value of object
PHP
4 votes338 views5 answers
Laravel storage
PHP
0 vote368 views1 answer
Return pdft download and back with msg in laravel
PHP Laravel
-2 votes370 views3 answers
Laravel where condition with if
PHP Laravel