How to get last week, last two weeks, and last three weeks data in Laravel

Hi! am developing an app to keep records of lotto results, and i want example last week results to be in green color, and last two weeks in yellow and last three weeks in red.

Am having challenges with the date and help please: This is my sample controller code.

    $now = Carbon::now();
    $start = $now->startOfWeek(Carbon::SATURDAY);
    $end = $now->endOfWeek(Carbon::MONDAY);

    $last_week = GameResult::where('game_id', $id)->whereBetween('date', [$start, $end])->first();

Snapey

3 years ago

Level 122

your code is selecting to this week

Sinnbeck

3 years ago

Level 102

Be sure to copy your carbon dates, as they are mutable

   $now = Carbon::now();
   $start = $now->copy()->startOfWeek(Carbon::SATURDAY);
   $end = $now->copy()->endOfWeek(Carbon::MONDAY);

Please or to participate in this conversation.