Auto Update

I want to automatically update a Boolean status every time i load/reload my app if the time value on the row is past from the current date.

For example, my value time was 16:00 and now in current time it is 16:30 i want that the Boolean value changes from false to true.

protected function freeRoom()
    {
        $time = date('H:i:s');
        $meetings = Meetings::where('etime','<', $date)->update(['available' => 1]);
        return $meetings;
    }

MohamedTammam

3 years ago

Level 51

Use whereTime

protected function freeRoom()
{
      $time = date('H:i:s');
      $meetings = Meetings::whereTime('etime', '<', $date)->update(['available' => 1]);
      return $meetings;
}

Please or to participate in this conversation.