Good Day house, I'm currently building an online hotel booking application in php but I'm having small challenges. This is where the problem is, I want the booking cancelled and the room available for booking if payment isn't made 48hours after the time the booking was made. How do I achieve this?

If your app is using Mysql, just create a timestamp variable alongside the booking Information or in a new table. Also create a status variable for (Paid,unpaid) on the same database.

Then poll the database for changes.

Cheers!

fsho:
If your app is using Mysql, just create a timestamp variable alongside the booking Information or in a new table. Also create a status variable for (Paid,unpaid) on the same database.

Then use javascript to poll the database for changes.

If this is not clear:

Search for "date programming in php"

You'll get different alternatives and ideas.

Cheers!

i have a column for status and booking_date already. The Javascript part is what I don't really get. can u please explain further

ace1:
Good Day house, I'm currently building an online hotel booking application in php but I'm having small challenges. This is where the problem is, I want the booking cancelled and the room available for booking if payment isn't made 48hours after the time the booking was made. How do I achieve this?

On each Booking create a Timestamp in a column on your database table and Mark the Payment Status as PENDING.

Create a Cron Job that runs lets say every 5 mins. The cron script will go to the database table and select records where Payment Status is Pending. The script will now compare the current time and the time on the Timestamp column, if it is more than 48Hours, Booking will be cancelled.

mj:


On each Booking create a Timestamp in a column on your database table and Mark the Payment Status as PENDING.

Create a Cron Job that runs lets say every 5 mins. The cron script will go to the database table and select records where Payment Status is Pending. The script will now compare the current time and the time on the Timestamp column, if it is more than 48Hours, Booking will be cancelled.

Thanks you very much. Let me do that