How to Get Last Month Data in Laravel?

By Hardik Savani October 11, 2021 Category : Laravel

Hi,

This article will give you example of how to get last month data in laravel. This article will give you simple example of how to get previous month in laravel. In this article, we will implement a how to get last month record in laravel. Here you will learn laravel get last month records.

we can get last month records in laravel 6, laravel 7 and laravel 8 application.

Here, i will give you very simple example of how to get last month data in laravel. we will use whereBetween() and Carbon 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;

class ITSController extends Controller

{

/**

* Write code on Method

*

* @return response()

*/

public function index()

{

$items = Item::select('*')

->whereBetween('created_at',

[Carbon::now()->subMonth()->startOfMonth(), Carbon::now()->subMonth()->endOfMonth()]

)

->get()

->toArray();

dd($items);

}

}

Output:

Array

(

[0] => Array

(

[id] => 9

[title] => Dr.

[body] => Body 4

[created_at] => 2021-09-14T18:13:40.000000Z

[updated_at] => 2021-08-12T13:46:08.000000Z

)

[1] => Array

(

[id] => 10

[title] => Dr.

[body] => Body 3

[created_at] => 2021-09-30T09:27:53.000000Z

[updated_at] => 2021-08-12T13:46:08.000000Z

)

[2] => Array

(

[id] => 12

[title] => Dr.

[body] => Body 2

[created_at] => 2021-09-07T13:46:43.000000Z

[updated_at] => 2021-08-12T13:46:43.000000Z

)

[3] => Array

(

[id] => 13

[title] => Mrs.

[body] => Body 1

[created_at] => 2021-09-01T13:46:43.000000Z

[updated_at] => 2021-08-12T13:46:43.000000Z

)

)

I hope it can help you...

Tags :