Design question

shanebanks

I have an MySQL database that has data similar to this:

Item1 10.95
Item2 11.00
Item3 8.32

I want to display an HTML page that lists all the items and prices in the database with a check box next to each item. If the user selects multiple items on the page I want it to calculate the total price of the selected items and display the total on the same page so that the total can change as the user selects different combinations. I am aware that PHP is server side so it may not be possible using only PHP to do the calculation without refreshing the whole page. I am very new to PHP and MySQL, but I have been able to get pieces of it to work. At this point I would be interested in how someone who knows what they are doing would begin to design this application. Thanks.

chads2k2

Hey if you have gotten that far that is excellent! Way to go. Personally I would look into using Javascript or DHTML for this. That might suit your needs. I am almost 100% sure that Javascript can do this easily. You could also have a button to "update" the "cart" ... Then have PHP do the work. It's up to you. Sorry I can't provide you links to examples.

Chad

shanebanks

Here is my code so far:

<?php require_once('Connections/MySQL.php'); ?>
<?php
mysql_select_db($database_MySQL, $MySQL);
$query_Recordset1 = "SELECT * FROM rates";
$Recordset1 = mysql_query($query_Recordset1, $MySQL) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p>&nbsp;</p>

<table border="1">
  <tr>
    <td>RateID</td>
    <td>RateDesc</td>
    <td>RatePrice</td>
    <td>Select</td>
  </tr>
  <?php do { ?>
  <tr>
    <td><?php echo $row_Recordset1['RateID']; ?></td>
    <td><?php echo $row_Recordset1['RateDesc']; ?></td>
    <td><?php echo $row_Recordset1['RatePrice']; ?></td>
    <td><form name="select" method="post" action="">
      <input type="checkbox" name="checkbox" value="checkbox">
    </form></td>
  </tr>
  <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

This displays all the data in the table and a checkbox next to each. I think what I need is when the checkbox is checked the value becomes the value of the RatePrice for that row and then puts it in some sort of variable so it can calculate the sum of all the checked boxes and then display it. It would be okay to have to submit it to calculate for now and then I could work on a javascript later to do it without submit. Any ideas?