Thread: Group Bookings?

Hi,

I have a form that creates a serious of click-able query-strings, when i click on one it populates a form then the user clicks submit and a booking is made.

However, how would i create a multiple booking process so that they can click on many?

or would i just have a different form, which consists of a drop down, asking for the number of bookings needed and then check if they are available.. then insert the records in the DB?

suggestions please?

Thanks

I thought about have check boxes which correspond to the seats. So if 5 are checked then insert 5 records in the DB. No sure what the best option is?

Originally Posted by BLaaaaaaaaaarche

Yes, you can then loop through your checkboxes and insert whatever information it is that needs to be inserted. For instance:

Code:

<input type="checkbox" name="seat_1">
<input type="checkbox" name="seat_2">
<input type="checkbox" name="seat_3">
<input type="checkbox" name="seat_4">
<input type="checkbox" name="seat_5">


For Each Item In Request.Form
	If Left(Item, 4) = "seat" Then
		intSeat = Split(Item, "_")(1)
		strSQL = "INSERT INTO MyTable (seat) VALUES (" & intSeat & ")"
		siteConn.Execute(strSQL)
	End If
Next

Thank you for your advice.. Sorry i didnt reply back sooner!

I understand that based on the checkbox (checked) the code will insert. But how do i assign the show information to the check boxes? As currently i am querying the database for what is available and then displaying clickable hyperlinks where the user can click to make a booking for that seat.

The code below displays the recordset values horizontally but im a bit puzzled to how i would assign the values to the check box?

Code:

'displays the records horizontally in a clickable hyperlink querystring
DIM recCount2
IF Not RS.EOF THEN
Response.Write "<table width='4%'>"

recCount2 = 0
DO UNTIL RS.EOF 
	
	IF recCount2 Mod 5 = 0 THEN
	Response.Write "<tr>"
	END IF
	
'Response.Write "<td>"&"["&"<a target=""_self"" href=""book_show.asp?performanceID=" & rs("performanceID") & "&showName=" & Request.QueryString("showName") &"&performance_time=" & rs("performance_time") &"&price=" & rs("price") & """>" & ("x") & "</a>"&"]"&"</td>"

Response.Write "<td>"&"["&"<input name="" type=""checkbox"" value="" />"&"]"&"</td>"


recCount2 = recCount2 + 1

	IF recCount2 Mod 5 = 0 THEN
	Response.Write "</tr>"
	END IF
	
RS.MoveNext
LOOP

IF recCount2 Mod 5 <0 THEN
	Response.Write"</tr>"
END IF
	Response.Write"</table>"
ELSE
	Response.Write "Sorry, this show is fully booked!"
END IF

Originally Posted by Wolffy

Put the necessary show information into the value attribute on the checkbox input. Probably just use the PerformanceID in this case. The necessary text to be presented to the user would be between the <input> and </input> tags.

For example

Code:

<input name="checkbox1" value="123" type="checkbox">Show123, Thursday 23 March 2010 20:00</input>

f

the code should create the checkboxes based on how many seats are left. Each checkbox is equal to a seat.

I have assigned the show information like you said and now my code seems to build the 'seats/checkboxes' and holds the query string value.

Just need to build the insert page where it will check for the value from all the checked boxes.

Call me crazy? but if i check 5 boxes, i will send this data over x 5 (obviously different values for different seats):

Code:

performanceID=184&showName=Tom&performance_time=02:00:00&price=5

So how would i use the pseudo code BLaaaaaaaaaarche provided?
Wouldn't i need to name each check-box with a number? and then have 30 insert statements to read each check-box value?????

Originally Posted by Wolffy

Yes, name each checkbox with a number -- makes them easier to find that way.

Rather than do 30 (or whatever) insert statements, you can build a query string using a SELECT ...UNION statement and do it as 1 statement:

Code:

Insert Into myTable
  (field1, field2, field3)
Select 'ValueA1', 123, 'ValueA2'
Union
Select 'ValueB1', 456, 'ValueB2'
Union
Select 'ValueC1, 789, 'Value C2'
--etc.

Or a stored procedure would help, if the DBMS supports it.

[edit]
And I can't see a good reason to include anything but the PerformanceID in the value tag -- all the other information should be contained in the database already, so no need to send it again.[/edit]

Do you think what i am doing is a bit long winded? Should i not just have a simple drop down asking how many tickets the user wants and then just query the database to check if the amount is available and then insert the co-responding number of records?

Originally Posted by Wolffy

Or create the dropdown with the lesser of (a) the number of seats available or (b) the maximum number of seat sa user can buy at once. It would be necessary to then check again that the number of seats requested are still available when the user submits the request in case those available seats went to another user. You would probably do this anyway when you accept payment from the user (assuming the application does this).

Then there is the Ticketmaster model, which actually reserves the seats for a period of time (like 3 minutes) until payment is confirmed -- otherwise, the seats are returned to the pool. However, this is more complicated application.

hmmmmm the first suggestion sounds good to me.

I have 3 price ranges so im guessing i would need the user to select if they want to sit, (front, middle or back row) then select how many tickets they want.

I asume i would validate what is "available" with a price range the user selected. If all is ok, then insert the records?