Booking system advice php and mysql tables
Posted on 2004-11-29
HI all i hope you can bear with me on this one,
I have some tables and scripts to add fairground rides to my databases at present.
I need to add some sort of booking system so that I can book rides using a html form and php scripts to process the information.
The nature of the booking system is that there are four rides that can be booked and the system should allow for certain criteria to be met too.
I have not really done something like this before so I would like to ask advice on the following setup, I do not have problems creating the myql tables or indeed I can try to work out the php scripting that would be suitable for the job.
Just a point I should make, i have a table with the ride information in it that has the following information.
Now i will be using the following fields and displaying it in table row format and adding some other checkboxes, and check boxes something like this:
checkbox(selectitem) | ridename(text) | duration(text) | quantity max 4(select box) | price(text) | total price (text field)
In addition to these I will be asking for some customer details on my form
There should also be a checkbox that when ticked should attempt to book seats together(near each other/same car/same seat or same row) running updates queries to my booking tables.
So what about these rides I have?
Ok the rides are as follows with price details how many seats and how many rows/cars and the duration of each ride:
Pirate Ship 20 - 5 rows of 4 seats 30 mins £1.00
Roller Coaster 16 - 4 rows of 4 seats 20 mins £3.00
Big Wheel 32 - 8 cars of 4 seats 30 mins £1.50
Log flume 10 boats 4 seats each 20 mins £2.00 (Boats leave every 2 mins)
These rides will be put into either a single or different tables with the correct ammount of seats/rows/boats to be booked and the customer should be able to schedule the rides so that they can select all four rides without them clashing with one another.
I have been asked to allow bookings to be made for a 3 hour period so that should give enough time to book rides without them clashing with one another.
I need some major advice on what would be the best ways to achieve something like this, i am sure that some of you guys have had to do something similar to this in the past but I must admit the complexity involved is probably far too much for just one question. Therefore my question is to what will be the best way to do this?