/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

1 vote315 views1 answer
Composer require laravel/ui not working laravel 8
PHP Laravel
0 vote340 views3 answers
Laravel load relationship
PHP Laravel
4 votes333 views2 answers
Laravel get current route in app.js
PHP Laravel
0 vote357 views1 answer
Create auto image path folder in laravel 8
PHP Laravel
0 vote354 views1 answer
Displaying laravel error in below input field
PHP Laravel
0 vote417 views1 answer
Deleting all files inside a directory laravel 8
PHP Laravel
0 vote357 views1 answer
Laravel get next and previous record
PHP Laravel
0 vote401 views2 answers
Laravel notification database
PHP Laravel
3 votes371 views1 answer
Laravel check if array is empty
PHP Laravel
0 vote409 views1 answer
Comparison of two tables in laravel using model
PHP Laravel