How to Get Month Wise Data in Laravel?

Hi,

I am going to explain you example of how to get month wise data in laravel. you can see get month wise data in laravel. you can see how to get month wise record in laravel. This article goes in detailed on laravel get month wise data example. Here, Creating a basic example of laravel group by month and sum.

we can get month wise records in laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 application.

Here, i will give you very simple example of how to get month wise record in laravel. we will use MONTHNAME() and groupBy() in this example.

I have one created items table that structure as bellow you can see.

items table:

Controller Code:

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Support\Facades\Http;
use App\Models\Item;
use Carbon\Carbon;
use DB;
  
class ITSController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index()
    {
        $items = Item::select(
                            DB::raw("(COUNT(*)) as count"),
                            DB::raw("MONTHNAME(created_at) as month_name")
                        )
                        ->whereYear('created_at', date('Y'))
                        ->groupBy('month_name')
                        ->get()
                        ->toArray();
  
        dd($items);
    }
}

Output:

Array
(
    [0] => Array
        (
            [count] => 8
            [month_name] => August
        )
    [1] => Array
        (
            [count] => 4
            [month_name] => October
        )
)

I hope it can help you...