Reservation System

[Tumult]

Hi,

 

I hope i posted this in the right forum, didn't know where else to put it.

I'm pretty new to all this, so bear with me...

 

 

I'm making a website with a reservation system on it. Visitors on the website get a layout which shows where they can sit, each seat being a checkbox. Now here's where i don't know how to move on but i'll discribe what i'm trying to reach.

 

Visitors can select multiple seats, then click on a button that will confirm their selection. This needs to be updated in the database, like giving a value of 1 to each seat that was selected. That reservation needs to be given an unique 5 digit number, that will be given to the visitor. After the database is updated, the website should check the value of the seats in the database and if they have a value of 1 the checkboxes need to be greyed out so visitors can't select those seats anymore.

 

Visitors must also be able to enter the unique 5 digit number in order to cancel their reservation, resetting the value of the seats linked to the 5 digit number to 0 and thus making those seats available for selection again.

 

Last but not least, the database needs to reset on a weekly bases (every week exactly the same day and time), so all reservations will be removed.

 

 

Now i'm not asking anyone to completely work this out for me, you have better things to do. But some pointers and/or examples on how to achieve each part would be much appreciated!

And yeah i know this post doesn't really follows the guidlines, but i'm asking for advice here, not for help with errors or things not working.

 

 

[ZulfadlyAshBurn]

Visitors can select multiple seats, then click on a button that will confirm their selection. This needs to be updated in the database, like giving a value of 1 to each seat that was selected. That reservation needs to be given an unique 5 digit number, that will be given to the visitor. After the database is updated, the website should check the value of the seats in the database and if they have a value of 1 the checkboxes need to be greyed out so visitors can't select those seats anymore.

 

Visitors must also be able to enter the unique 5 digit number in order to cancel their reservation, resetting the value of the seats linked to the 5 digit number to 0 and thus making those seats available for selection again.

 

good idea. use PHP & MYSQL~

 

Last but not least, the database needs to reset on a weekly bases (every week exactly the same day and time), so all reservations will be removed.

 

use cron jobs on your server to run a script which clears the db.