Search by Queries/Bugs/Errors

How to get last year records count with month wise in Laravel

Created at 18-Nov-2021 , By samar

With this article, we will examine several different instances of how to solve the "How to get last year records count with month wise in Laravel".

You can get last year records count with month name in Laravel. You can use DB::raw with Laravel eloquent to get the records count created in specific month with month name.

Fetch month wise last year data

$users = App\Models\User::select(DB::raw("(COUNT(*)) as count"),DB::raw("MONTHNAME(created_at) as monthname"))
 ->whereYear('created_at', date('Y', strtotime('-1 year')))
 ->groupBy('monthname')
 ->get();

This code snippet will help you to get the last year data with month wise.

Back to code snippet queries related laravel

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.

Bootstrap C C++ Cmd CodeIgniter Css Drupal Git Html Java Javascript Jquery Laravel Mongodb Nodejs Php Python React Sql Typescript Wordpress

How to get last year records count with month wise in Laravel

Fetch month wise last year data

Random Code Snippet Queries: Laravel

Latest Code Snippets