/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

2 votes166 views2 answers
Confirm popup laravel
PHP Laravel
0 vote164 views1 answer
Php/Laravel check if date is passed
PHP Laravel
0 vote177 views1 answer
How to check if a url has a certain word in laravel
PHP Laravel
5 votes171 views3 answers
Laravel destroy session
PHP Laravel
0 vote159 views1 answer
How to check if query is successfully inserted laravel
PHP Laravel
0 vote159 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
14 votes167 views5 answers
Laravel eloquent get last record
PHP Laravel
3 votes190 views3 answers
Clear laravel.log
PHP Laravel
0 vote165 views1 answer
Laravel collection median
PHP Laravel
14 votes160 views3 answers
How to convert string to int in php laravel
PHP Laravel