/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

7 votes261 views5 answers
Laravel foreach loop index in controller
PHP Laravel
0 vote268 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel
1 vote255 views1 answer
Get data based on date in laravel
PHP Laravel
2 votes320 views2 answers
How to add data to the request object in laravel
PHP Laravel
0 vote273 views6 answers
Socialite laravel 7
PHP Laravel
3 votes265 views2 answers
Custom 404 page in laravel
PHP Laravel
0 vote300 views1 answer
Use font awesome in laravel 8
PHP Laravel
2 votes240 views2 answers
Laravel select query return array
PHP Laravel
8 votes290 views2 answers
Laravel storage hard link
PHP Laravel
1 vote247 views2 answers
Laravel init
PHP Laravel