Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
I'm creating a hotel room reservation system. Room availability is based on the date range from bookings table. How to remove the rows in the bookings table if the user doesn't confirm the room registration (Rooms with unconfirmed status).
How to check availability of rooms for simultaneous users
you can run a corn job or scheduler. keep the status to the booking as pending or not confirmed and run the suggested to check which row is in the given state after x time.
x = time after which you want system to cancel the booking.
then delete such records.
thank you prince. Any other workflow can be adopted, can you suggest
Please or to participate in this conversation.