Concurrency using PHP, Javascript, and MySQL

Question

I am new to web development and I've decided to implement concurrency in a Cinema ticketing website. So for example, when a customer selects a seat, I would like to lock the seat temporarily, rather than get interference from other customer, or avoid the scenario where two customers select the seat at the same time.

The scripting language and database I have chosen to develop this website are PHP, Javascript and MySQL.

Please give some suggestions or links about what technique I should use to fix it? Is that considered concurrency?

Ensure that your database engine of choice in MySQL supports transactions, and look at using MySQL EVENTS to release seat locks — Mark Baker
– Mark Baker, Commented Jan 26, 2012 at 11:55

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

This answer suggests a good way of doing this:

[...] create a column containting a timestamp. Whenever you want to lock the row you update it to the current time. To unlock update to a time at least x minutes in the past. Then to check if its locked check that the time stamp is at least x minutes old.

This way if the process crashes (or the user never completes their operation) the lock effectively expires after x minutes.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 26, 2012 at 12:55

Samuel Harmer

4,4305 gold badges37 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Concurrency using PHP, Javascript, and MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related