/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 vote362 views2 answers
Upload a pdf file laravel
PHP Laravel
6 votes309 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
1 vote337 views1 answer
Cart::total return number format value laravel
PHP Laravel
2 votes358 views1 answer
Find word in text in laravel
PHP Laravel
0 vote344 views1 answer
Laravel 7 create-project
PHP Laravel
4 votes336 views1 answer
Laravel validation numeric vs integer
PHP Laravel
0 vote377 views1 answer
Laravel eloquent hasmany select
PHP Laravel
11 votes337 views6 answers
Datetime validation in laravel
PHP Laravel
0 vote342 views1 answer
Send multiple db notification same function in laravel
PHP Laravel
-1 vote356 views1 answer
Sometimes validation in laravel
PHP Laravel