4

I'm struggling to come up with a solution for events ticket booking system. I need some idea how to lock a ticket once added to 'a cart' so it cannot be booked by other customer

How is this done on other ticket booking sites where the ticket is reserved for eg 10 minutes and then gets released after that time when transaction is not completed. Running cron job every minute wouldn't be viable, would it?

vault-boy
  • 523
  • 1
  • 6
  • 18
  • This is a perfect valid question. Don't understand the reason for the downvote. – Sid Sep 03 '14 at 07:34

1 Answers1

6

If you save the time when the ticket is to be unlocked and then when someone wants to book it you just have to see if that time has passed, it should work without any trouble or stress to the server.

So in your ticket table you add a datetime field named 'booked_until', store the time when the item is going to get unlocked and you are set!

Naryl
  • 1,878
  • 1
  • 10
  • 12
  • So you mean modifying DB query to check if current datetime is larger than 'booked_until' when the ticket is selected by a different customer. If current datetime value is smaller it means ticket is still locked. Sounds good actually – vault-boy Nov 20 '12 at 12:18