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 vote158 views1 answer
Artisan call migrate result
PHP
1 vote136 views1 answer
Php filter_var boolean
PHP
0 vote153 views1 answer
RequestCriteria laravel
PHP Laravel
1 vote127 views1 answer
How can set defult value for yield in laravel
PHP
0 vote145 views1 answer
Error correction in qr code php
PHP
0 vote187 views1 answer
How to pluck fullname database laravel
PHP
0 vote176 views1 answer
Laravel Validate unique column
PHP Laravel
0 vote170 views1 answer
Form validation nullable laravel
PHP Laravel
0 vote160 views1 answer
Menggunakan pengkondisian dalam string php
PHP
0 vote155 views1 answer
Laravel override eloquent all function
PHP Laravel