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 votes253 views2 answers
How get query from url in laravel
PHP
3 votes217 views2 answers
Destroy php variable
PHP
0 vote233 views1 answer
WordPress oEmbed Funktion abschalten
PHP
0 vote220 views1 answer
Laravel request file empty
PHP
1 vote216 views1 answer
Php check whether the url is http or https
PHP
0 vote221 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP
8 votes262 views1 answer
If any error in blade laravel
PHP Laravel
0 vote207 views1 answer
Gate::before not working laravel 8
PHP
1 vote217 views1 answer
Wp_redirect to home page
PHP
0 vote245 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel