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

19 votes221 views2 answers
PHP auto refresh page
PHP
41 votes283 views6 answers
Capitalize php
PHP
0 vote237 views1 answer
Laravel validate form data unique array
PHP
7 votes247 views2 answers
Php one line if without else
PHP
1 vote213 views1 answer
Nested resources laravel
PHP
4 votes223 views2 answers
Numbric validate laravel
PHP Laravel
0 vote215 views1 answer
Php pass variable to anonymous function
PHP
1 vote209 views2 answers
How to make active color in menu laravel
PHP
0 vote249 views2 answers
Laravel migration change column order
PHP Laravel
0 vote226 views1 answer
Wc php get shipping address street
PHP