/PHP/Laravel/How to get yearly chart in laravel

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 vote189 views1 answer
Laravel maintenance mode custom class
PHP Laravel
2 votes195 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel
3 votes197 views3 answers
Laravel csrf-token in view
PHP Laravel
1 vote197 views1 answer
Where date laravel
PHP Laravel
7 votes212 views6 answers
Laravel get url path
PHP Laravel
3 votes400 views7 answers
Laravel 8 livewire tutorial
PHP Laravel
0 vote205 views1 answer
Multiple databases user validation in Laravel
PHP Laravel
1 vote287 views1 answer
How if charactor is exist in text in laravel
PHP Laravel
1 vote189 views1 answer
Laravel validation in controller
PHP Laravel
8 votes193 views1 answer
If any error in blade laravel
PHP Laravel