[Resolved] Arrays?

chriswheat

Hello,

I am trying to set up online sales of game tickets.

page opentickets.php would display

section Seat# TicketPrice Ticket_id
f 123 20 1
g 133 22 2
f 124 20 3
f 125 20 4

their would be a check box next to each ticket for them to buy.

So lets say user checks ticket 1,3,4
How do I put them into and array?

then take items 1,3,4 and total the price?

Thanks
Chris

weekender

so you have your checkboxes for each ticket like so...

<INPUT TYPE="checkbox" NAME="ticketnum[]" VALUE=1>
<INPUT TYPE="checkbox" NAME="ticketnum[]" VALUE=2>
<INPUT TYPE="checkbox" NAME="ticketnum[]" VALUE=3>

notice how the name is an array (ie it has [] at the end). So the user comes along a ticks the boxes for values 2, 5, 6 + 7 and submits the form to page process.php

in page process.php...

$tickets = $_POST['ticketnum'];

then, your $tickets var will be an array containing the values of the ticked boxes like so...

print_r($tickets);
// output is...
// Array(2, 5, 6, 7);

nb for further info, if you want to use this in SQL, do like this

$sql = "SELECT * FROM tickets WHERE ticketnum IN (2,5,6,7)";

hope that helps

adam

chriswheat

It helps except for the sql

if I use

$sql = "SELECT * FROM tickets WHERE ticketnum IN ($ticketnum)";

It does not return any results?

chriswheat

So I think I need implode() ?

Here is my code:

$tkts = $_POST['tkts'];
if ($tkts){
$comma_separated = implode(",", $tkts);

$sql = mysql_query("SELECT * FROM tkts WHERE tkt_id IN ('$comma_separated') order BY section asc, row asc, seat asc");
if(mysql_num_rows($sql) > 0) {
echo "$comma_separated<table>";
while($row=mysql_fetch_array($sql)) {
echo "
<tr><td valign=\"middle\">Row: ".$row['row']." Price: $".$row['netprice']."
</td>
</tr>
";
}
echo "</table>";
} else {
print "Sorry an error occured please try agian";
}
}else{ print "You must select a ticket. Please use your browsers back button and try agian."; }

Lets say the user picks 3 tkts to buy. after the implode()
$comma_separated is equal to
86,87,88. Yet sql is only returning the info for tkt 86 how do I make it grab info for all 3 (in this case) and then go into a loop?

chriswheat

here is the fix I came up with:

$tkts = $_POST['tkts'];
$grandtotal = "0";
foreach ($tkts as $i => $value) {
$sql = mysql_query("SELECT * FROM tkts WHERE tkt_id='$tkts[$i]'");
$result = mysql_fetch_array($sql);
extract($result);
$grandtotal = $grandtotal + $netprice;
echo " $tkt_id $section $row $seat $netprice -------";
}

print " Total: $grandtotal";