Laravel Get Data From Last 7 Days

laravel get data from last 7 days using Carbon::now()->subDays(7) and ->whereRaw(‘DATE(join_date) = DATE_SUB(CURDATE(), INTERVAL 7 DAY)’) Examples.

Contents

i can easily get last 7 days records in laravel 6, laravel 7 and laravel 8 version. it should be last N days records.

Controller File:

Example


subDays(7);
  
        $Members = Member::where('join_at', '>=', $date)->get();
    
        dd($Members);
    }
}

You can use whereDate for that :

->whereDate('join_at', Carbon::now()->subDays(7))
->get();

Example 2

 ->whereRaw('DATE(join_date) = DATE_SUB(CURDATE(), INTERVAL 7 DAY)')

Don’t Miss : Laravel Get Last 7 Days Month Year Record From MySQL?

I hope you get an idea about laravel get data from last 7 days.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.