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

0 vote274 views1 answer
Curl_setopt_array php
PHP
6 votes228 views1 answer
In order to use the Auth::routes() method, please install the laravel/ui package.
PHP
1 vote223 views1 answer
How to save information on pdf file in laravel project
PHP
2 votes213 views2 answers
Laravel select query return array
PHP Laravel
3 votes182 views1 answer
Laravel go back
PHP
0 vote249 views2 answers
Php remove specific element from array
PHP
8 votes286 views6 answers
Define table name in model laravel
PHP Laravel
0 vote269 views1 answer
Read xml file in php wordpress
PHP Wordpress
62 votes251 views5 answers
Convert string to int php 7
PHP
0 vote240 views1 answer
Import separate graphql file laravel
PHP Laravel