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

12 votes309 views2 answers
Debug bar laravel print array
PHP Laravel
3 votes359 views1 answer
Php curl print status
PHP
0 vote308 views1 answer
How to calculate age using query builder in laravel?
PHP
8 votes301 views3 answers
Laravel 8 check if record exists
PHP
1 vote283 views1 answer
How to add property to the request object
PHP
2 votes276 views1 answer
Php modules list ubuntu
PHP
1 vote248 views2 answers
Laravel loop counter
PHP Laravel
1 vote285 views1 answer
Php single quote vs double quote
PHP
0 vote274 views1 answer
Phpmyadmin change database import size
PHP
2 votes289 views4 answers
Laravel where in array
PHP