I have created a booking system to book out employees time within our existing custom CMS system that is connected to our site.
I’m having difficulty in preventing double bookings.
Bookings are defined by
day of week,
end time - n my SQL table these are all seperate column values.
My booking form is a single page and posts all of this data to the database at once. There is no ajax or background scripts checking availability against the table - I’d be interested in that route but I’m happy to just go with the user getting a message saying not available for the time being.
I’d appreciate any help with this.