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

3 votes206 views2 answers
Laravel where condition on relationship
PHP
0 vote207 views1 answer
Laravel maintenance mode custom class
PHP
3 votes188 views1 answer
Count array laravel
PHP Laravel
0 vote210 views1 answer
Preg_split
PHP
0 vote203 views1 answer
Laravel eloquent get x number of results
PHP
0 vote207 views1 answer
Php regex replace all non alphanumeric characters
PHP
0 vote209 views1 answer
FindOneBy
PHP
1 vote192 views1 answer
Twig json_encode
PHP
5 votes208 views2 answers
How to remove first element in array php
PHP
0 vote216 views1 answer
'php' is not recognized as an internal or external command, operable program or batch file.
PHP