Laravel - Get data based on date range using eloquent

Question

Heei, I want to show data according to daterange. Specifically data on this day and 6 days to go. Here's my code now.

Controller

$hari = [];

for ($i=0; $i < 6; $i++) 
{
   $hari[] = date("Y M d") + $i;
}

$booking_room = jadwal_meeting::whereBetween('tanggal', [$hari, $hari + 6])->get();
return view('homepage')->with($booking_room);

Note: 'tanggal' is a field on table.

But I just get error like this

Unsupported operand types : $booking_room = jadwal_meeting::whereBetween('tanggal', [$hari, $hari + 6])->get();

What's wrong with my code, anyone can help me please :)

Is $hari a string or a Carbon instance?

Jonas Staudenmeir
– Jonas Staudenmeir

2018-04-27 19:41:10 +00:00
Commented Apr 27, 2018 at 19:41 — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Apr 27, 2018 at 19:41
Please check my answer below.

Pratik Mehta
– Pratik Mehta

2018-04-28 12:31:04 +00:00
Commented Apr 28, 2018 at 12:31 — Pratik Mehta
– Pratik Mehta, Commented Apr 28, 2018 at 12:31
@JonasStaudenmeir the result of $hari should be a string

Bariq Dharmawan
– Bariq Dharmawan

2018-04-30 03:05:53 +00:00
Commented Apr 30, 2018 at 3:05 — Bariq Dharmawan
– Bariq Dharmawan, Commented Apr 30, 2018 at 3:05

Jonas Staudenmeir · Accepted Answer · 2018-04-30 11:58:01Z

1

Since $hari is an array, you have to use something like this:

$booking_room = jadwal_meeting::whereBetween('tanggal', [$hari[0], $hari[5]])->get();

Or more general:

$booking_room = jadwal_meeting::whereBetween('tanggal', [$hari[0], end($hari)])->get();

answered Apr 30, 2018 at 11:58

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bariq Dharmawan Over a year ago

Thank you, you save my time :)

Pratik Mehta · Accepted Answer · 2018-04-28 12:30:50Z

1

Try this code it will help you.

$from = '2018-04-12'; 
$to = date('Y-m-d', strtotime($from. ' + 6 days'));

$reservations = Reservation::whereBetween('tanggal', [$from, $to])
->get();

Thanks,

edited Apr 28, 2018 at 12:30

answered Apr 28, 2018 at 12:22

Pratik Mehta

7158 silver badges27 bronze badges

Collectives™ on Stack Overflow

Laravel - Get data based on date range using eloquent

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related