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

3 votes177 views2 answers
Valdidate laravel if falid
PHP Laravel
0 vote135 views1 answer
Laravel eloquent get 3 months
PHP
0 vote143 views1 answer
Php hash list
PHP
1 vote113 views1 answer
Laravel foreach else
PHP Laravel
4 votes116 views5 answers
Php move_uploaded_file
PHP
3 votes225 views4 answers
Codeigniter apache remove index.php
PHP CodeIgniter
2 votes124 views2 answers
Public_path laravel
PHP Laravel
9 votes218 views4 answers
Datetime format laravel
PHP Laravel
4 votes106 views1 answer
Uuid package generator laravel
PHP
3 votes92 views1 answer
Php define strict types
PHP