Using images with PHP and MYSQL

[webAmeteur]

I have this current code

<?php
do {

?>

<table>
<tr>
<td width='15'><img src="../Images/circle1.gif" name="<?php echo $row_rstAvailSeats['seat_number'];?>"></td>
<td width='15'><div align="right"><?php echo $row_rstAvailSeats['seat_number']?></div></td>
<td width='20'><?php echo $row_rstAvailSeats['row_num']; ?></td>
<td width='20'><?php echo $row_rstAvailSeats['block_id']; ?></td>
</tr>
</table>

<?php
} while ($row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats));
$rows = mysql_num_rows($rstAvailSeats);
if($rows > 0) {
mysql_data_seek($rstAvailSeats, 0);
$row_rstAvailSeats = mysql_fetch_assoc($rstAvailSeats);
}
?>

I am trying to use a set of images to book seats in a venue. When the user clicks on say 3 of the images(representing seats) they can then click a submit button, and the relevent details in the database will be updated.

Any suggestions

Karl

[AstroTeg]

Sounds like a case of client-side JavaScript. Setup the JavaScript to record which seats the user clicks (maybe keep track of them in a hidden field). When the user submits the form, the hidden data makes it over to PHP. Then it'll be your job to parse it and update the data.

Beyond that, where are you stuck at?

[webAmeteur]

Thanks, Ill give that a go. Im pretty new to coding and even newer to PHP and Javascript, so Ill see how I get on.

Regards

[webAmeteur]

Ok, i gave ot a go but keep getting errors. I am trying to use the onClick event so when the user clicks, the value of that seat is passed to a textbox. Cant seem to work it out.

Any ideas??

Regards

[dewen]

try this, hope it give you some idea

<?php
echo '<PRE>';
print_r($_POST);
echo '</PRE>';
?>
<form name="fp" action="<?PHP echo basename(__FILE__)?>" method="post" onsubmit="">
<PRE>
<img src="checkmark.gif" onclick="javascript:fp.myimage1.value='checked';">
<input type="hidden" name="myimage1">

<img src="checkmark.gif" onclick="javascript:fp.myimage2.value='checked';">
<input type="hidden" name="myimage2">

<img src="checkmark.gif" onclick="javascript:fp.myimage3.value='checked';">
<input type="hidden" name="myimage3">

<input type="button" name="send" value="show checked images" onclick="javascript:fp.submit();">
<PRE>
</form>