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

5 votes166 views4 answers
App url laravel
PHP Laravel
0 vote146 views1 answer
Php foreach ($_post as $key = $value)
PHP
21 votes142 views6 answers
Php empty array
PHP
1 vote143 views1 answer
Change verify email template laravel
PHP
6 votes180 views3 answers
Laravel ide helper
PHP Laravel
2 votes134 views1 answer
Codeigniter row count returns 1 always
PHP CodeIgniter
1 vote164 views1 answer
Laravel Validation check array size min and max
PHP Laravel
25 votes167 views4 answers
Carbon now
PHP
3 votes167 views2 answers
Validate phone number with dial code laravel 8
PHP Laravel
0 vote178 views1 answer
Stripe laravel usage-based metered billing
PHP Laravel