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 vote101 views1 answer
Get_the_author_meta display name
PHP
0 vote105 views1 answer
Laravel 8 date difference in days
PHP
0 vote98 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP
0 vote100 views1 answer
Php client enable short tags
PHP
3 votes89 views1 answer
How can I prevent SQL injection in PHP?
PHP
9 votes100 views3 answers
Alias seeddb='php artisan db:seed'
PHP
2 votes102 views2 answers
Get session id in laravel
PHP
0 vote109 views1 answer
Text to sha256 converter in laravel
PHP Laravel
0 vote111 views1 answer
Check the existing image in s3 laravel
PHP Laravel
2 votes90 views1 answer
Laravel required if another field has value
PHP