Avoiding overbooking?
-
I am trying to implement a booking system on my site for courses with limited number of seats, using a CF7 form and CFDB. To reduce the risk of overbooking I implemented a validation check on a hidden field to inform the applicant of a possible reject. In this validation I use a CFDB shortcode to count the number of remaining seats. (If a course is already full the form will not open.)
So, if a course has one seat left and two applicants are starting to register for this course, it should be the one that hits the submit button first that is accepted, while the other is rejected and informed with a validation error.
Am I safe from overbooking, or is there a certain probability that both applicants above are accepted (=overbooking)?
Basically, I guess this has to do with how the PHP and SQL statements are executed on the site server in this kind of multiuser environment.
Can the risk of overbooking be further reduced (or removed?) using these plugins for this purpose?https://www.ads-software.com/plugins/contact-form-7-to-database-extension/
- The topic ‘Avoiding overbooking?’ is closed to new replies.