Adding value of a form element

[davieboy]

Hi folks

ok im using this code to fill in 3 values for each 'ticket'

in any page there could be multiple form elements (depends on how many have been selected)

How do i got about adding a total to the bottom, a running total if possible?

echo "<table width=\"50%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
    <td width=\"15%\">$ticket_full -> </td>
    <td>	<select name=\"[ seat id ]\" class=\"style1\">
				<option value=\"none\" selected>-- Please Choose Ticket Type --</option>
                <option value=\"$costadult\">Adult @ [ $costadult ]</option>
                <option value=\"costchild\">Child @ [ $costchild ]</option>
                <option value=\"costconcession\">Concession @ [ $costconcession ]</option>
              </select><br><br></td>
  </tr>
</table>";

the $cost variables are all chosen from a db

David

[mouloud2001]

if you want the total to be dynamique, I think you must use javascript :
<select name="[seat_id]" class="style1" onchange="updateTotal();">

and in the header :
<script language="javascript">
function updateTotal()
{
var Total = document.form["myform"].seat1.selectedIndex+document.form["myform"].seat2.selectedIndex... etc.
}
</script>

I don't know your level in js, so it's a very quick example, only to show the direction. It's not functional as is.

[davieboy]

the prob is the will not be a definative number of seats selected
all done by how many chosen in page b4 hand

[mouloud2001]

Sorry, I'm french, and I'm not pretty sure of what you mean. But If the problem is to let know to javascript the list of the seat so that it can make the total, it's very simple. You just have to generate a js array with php :

<script language="javascript">
<?php
for ($i=0; $i < count($seat_array); $i ++) {
  echo("var seat$i = '$seat_array';\n");
}
echo("var nb_seat=".count($seat_array));
?>
</script>

and then in your js function, you just have to go through this js list, and add all the value.
Again, this code is not usable as it. Hope this example is clear for you.

[davieboy]

for the js function do i presume i do not need to manually enter all the seat data in the coding and its all run from the js you posted above?

js is very new to me sadly i have been trying to find examples of it online to learn, the addition bits.

[davieboy]

i have found a script that works in theory

<script type='text/javascript'>
<!--
function get_total() {
x = document.forms.myform;
cost = x.cost.value;
x.total.value = cost;
}
-->
</script>

and the text boxes are:

<form name='mult'>
Qty: <input type='text' name='qty' onkeyup='get_total()' /><br />
Cost: <input type='txt' name='cost' onkeyup='get_total()' /><br />
Total: <input type='txt' name='total' value='0.00' disabled='disabled' />
</form>

have no idea how to edit it to my needs thouhg

[mouloud2001]

the basic coding with javascript is pretty the same than with php. There is just some "gramatical" difference.
With javascript (and DOM), you can access the value of any HTML element of the page, especialy the form elements.
To access the value of the selelected item of a select, you do this
var myValue = document.myForm.MySelect{document.myForm.MySelect.selectedIndex};
where myForm is the form name an MySelect the select name.
In your case, you don't know the name of the select, because it's dynamic, so you have to dynamcly get it.
So I suppose that you know the names of the select inside your php script. So with php, you can generate this js array :
var selectNames = Array("mySelect1", "mySelect2", "etc");
and then, in the js function which is called by the "onChange" event of the every select, you use the eval() function :

function updateTotal()
{
   total = 0;
   for (i = 0; i < selectNames.length; i++) {
     var MySelect = eval("document.myForm."+selectNames{i});
     total = total + MySelect{MySelect.selectedIndex};
  }
  document.MyForm.MyTotalField.value = total;
}

[davieboy]

how do i call the function in my html page?

[mouloud2001]

<select name="mySelect1" onChange="uploadTotal();">

[davieboy]

i mean to actually show the total of all the select boxes

David

[mouloud2001]

it depends. On the exemple i give you, it change the value of a :
<input type=text value=0 name="myTotalField">
But you can change the value of a div also
in the html :
<div class="total" id="myTotalDiv">0</div>
and in the script :
document.getElementById["myTotalDiv"].innerHTML=total;
Again, you can access all the html via javascript.

[davieboy]

i am still totally lost.

what is the code for my javascript ? i believe to be the updateTotal and a php script

for my input tag to display the total i just use the bit you have above or does it need the document.get.... section?

David

[mouloud2001]

Well, it's difficult to learn you javascript from start to end in one message. And I can't give you the working code without having the full code of your page.
So, either you try to learn a little bit javascript (in my opinion, it's very very very usefull for any type of web page), either you send me your html page with the php script, and i'll make the code for you.

[Weedpacket]

Also, you'll probably find a larger pool of Javascript talent to drawn on if you direct Javascript questions to a Javascript forum.

[davieboy]

mouloud2001 wrote:

Well, it's difficult to learn you javascript from start to end in one message. And I can't give you the working code without having the full code of your page.
So, either you try to learn a little bit javascript (in my opinion, it's very very very usefull for any type of web page), either you send me your html page with the php script, and i'll make the code for you.

Code is below

cheers for the help.

i have asked in a few JS forums, but everyone seams to be at a blank

[davieboy]

<?php
session_start();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Seating test</title>
<style type="text/css">
<!--
.style1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 10px;
}
body {
	margin-left: 0px;
	margin-top: 5px;
}
img{
 border:0px;
  }
-->
</style>
<SCRIPT language=JavaScript> 
function confirmBooking() { 
if (confirm("The next page will take you to a payment page.\nBooking Fee of £1.50 applies to this transaction.\n\nProceed?")==false) 
return false; 
else 
return true; 
} 
function deleteBooking() { 
if (confirm("The next page will cancel the booking so far.\nYou will have to start again.\n\nProceed?")==false) 
return false; 
else 
return true; 
} 
</script>
</head>

<body>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="center" class="style1">
      <p>Tickets Stage 2 <br>
        (see subnote in code):</p>
      <p>&nbsp;</p>
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
		<?php 

	include 'config.php';
	$db= mysql_connect($db_host,$db_user,$db_pass) or die (mysql_error());

	mysql_select_db ($db_name) or die (mysql_error());
	$eventid = $_GET['eventid'];
	$datestamp = $_GET['datestamp'];
	$query = "SELECT * FROM events WHERE eventid = '$eventid'"; 
	$result=mysql_query($query) or die (mysql_error()); 
	while($r=mysql_fetch_array($result))
{
		$id=$r["id"];
		$datestamps=$r["datestamp"];
		$costadult=$r["costadult"];
		$costchild=$r["costchild"];
		$costconcession=$r["costconcession"];
}
        session_register('eventid'); 
        $_SESSION['eventid'] = $eventid; 
		session_register('costadult');
		$_SESSION['datestamp'] = $datestamp;
		session_register('datestamp');
		$_SESSION['costadulta'] = $costadult;
		session_register('costchild');
		$_SESSION['costchilda'] = $costchild;
		session_register('costconcession');
		$_SESSION['costconcessiona'] = $costconcession;

$eventsid2 = $_SESSION['eventid'];
$datestamp2 =$_SESSION['datestamp'];
// echo "$eventsid2 -> $datestamp2 -> $costadult/$costchild/$costconcession";
?>

      <td width="18%"><div align="left"></div></td>
      <td width="82%"><p align="left">Event Selected: <strong><?php
	  		mysql_select_db ($db_name) or die (mysql_error());
			$query = "SELECT * FROM eventdata WHERE event_id = '$eventid2'"; 
	$result=mysql_query($query) or die (mysql_error()); 
	while($r=mysql_fetch_array($result))
{
		$id=$r["id"];
		$event_id=$r["event_id"];
		$event_date=$r["event_date"];
		$event_name=$r["event_name"];
		$event_notes=$r["event_notes"];
}
		  echo "$event_name</strong>  [ Event ID : $eventid2 ]";?><br>
            Date: <strong><?php
$qt=mysql_query("select * from events");

while($nt=mysql_fetch_array($qt)){
echo "".date("d-m-Y",strtotime($nt[datestamp]))."$nt[datestamp] ";
}
?>        </strong>  <br>
			Block: <strong><?php $_GET['block']; echo $block;?></strong><br>
            Row: <strong><?php $_GET['row']; echo $row;?></strong><br>
            Seat(s): <strong><?php $_GET['seat']; echo $seat;?> - $seat</strong> (or $seat if singular) <br>
            <br>
          </p>
            </td>
        </tr>
        <tr height="1">
          <td></td>
          <td background="images/obgg.jpg"></td>
        </tr>
        <tr>
          <td><div align="left"></div></td>
          <td><p align="left"><br>
                <strong>Ticket BreakDown </strong>(<strong><a href="#" alt="Please chose the appropriate ticket type for each seat chosen.">?</a></strong>)</p>
            <p align="left">                <?php echo "$block$row$seat";?>
			  <?php foreach ($_SESSION['seats'] as $key=>$val) 
{ 
// get seat data

$query = "SELECT * FROM arena WHERE seat_id = '$val'"; 
		$result=mysql_query($query) or die (mysql_error()); 
		while($r=mysql_fetch_array($result))

{
		$id=$r["id"];
		$seat_id=$r["seat_id"];
		$ticket_block=$r["block"];
		$ticket_row=$r["row"];
		$ticket_seat=$r["seat"];
		$costadultb=$r["costadult"];
		$costchildb=$r["costchild"];
		$costconcessionb=$r["costconcession"];

}
echo "<form name=\"myform\">";
// re-defining ticket cost sessions
$ticket_full = "$ticket_block$ticket_row$ticket_seat";
echo "<table width=\"50%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
    <td width=\"15%\">$ticket_full -> </td>
    <td>	<select name=\"[ $seat_id ]\" class=\"style1\"> 
				<option value=\"none\" selected>-- Please Choose Ticket Type --</option>
                <option value=\"$costadultb\">Adult @ [ £$costadultb ]</option>
                <option value=\"costchildb\">Child @ [ £$costchildb ]</option>
                <option value=\"costconcessionb\">Concession @ [ £$costconcessionb ]</option>
              </select><br><br></td>
  </tr>
</table>";
// Select data from Database where seats_id = the id taken from the session is 0001 for block A row A seat 1        

} 

?>
 Ticket Total: <input type=text value=£0.00 name="myTotalField" class="style1" disabled='disabled'></form>                

          </p>
            <p align="left"><br>
              <br>
              Booking Fee:&pound;<?php echo $bfee = "1.50"; "$bfee";?></p>
			  <?php
			  function makeRandomPassword() { 
  $salt = "ABCDEFGHIJKLMNOPQRSTUVWXYZabchefghjkmnpqrstuvwxyz0123456789"; 
  srand((double)microtime()*1000000); 
      $i = 0; 
      while ($i <= 8) { 
            $num = rand() % 33; 
            $tmp = substr($salt, $num, 1); 
            $pass = $pass . $tmp; 
            $i++; 
      } 
      return $pass; 
} 

$random_id = makeRandomPassword(); 
?>
            <p align="left"><a href='booking.php?<?php echo "event=$event_id&id=$random_id";?>&confirmid=<?php echo session_id();?>' onclick='return confirmBooking()' class='style1'><strong>Proceed</strong></a> | <a href='start_over.php?start_over&confirmid=<?php echo session_id();?>' onclick='return deleteBooking()' class='style1'><strong>Cancel</strong></a></p></td>
        </tr>
      </table>
      <p>&nbsp; </p>
    </div></td>
  </tr>
</table>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="center">
        <?php include 'footer.php';?>
      </div>
        <div align="center"></div></td>
  </tr>
</table>
<p>&nbsp;</p>
<p align="center" class="style1">&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

[mouloud2001]

i can't see the code... where did you put it ?

[davieboy]

where should the code be, everytime i try i get nothing

[mouloud2001]

ok, it's on page 2 🙂
First, if I'm not wrong, you start your <form> mark inside the foreach statement, and the </form> is outside the foreach. So, in your html code, you should have a lot of <form> mark, with the same name, which could cause problem.
So, to make my code work, i have to put the <form> before the foreach (I suppose you need only one form, with all the select in it.)

[mouloud2001]

I can't test it, but it should work :
(be carefull, the copy/past process from a web page could break the code)

<?php 
session_start(); 
?> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
<title>Seating test</title> 
<style type="text/css"> 
<!-- 
.style1 { 
    font-family: Verdana, Arial, Helvetica, sans-serif; 
    font-size: 10px; 
} 
body { 
    margin-left: 0px; 
    margin-top: 5px; 
} 
img{ 
border:0px; 
  } 
--> 
</style> 
<SCRIPT language=JavaScript> 
	function confirmBooking() { 
		if (confirm("The next page will take you to a payment page.\nBooking Fee of £1.50 applies to this transaction.\n\nProceed?")==false) 
			return false; 
		else 
			return true; 
		} 
	function deleteBooking() { 
		if (confirm("The next page will cancel the booking so far.\nYou will have to start again.\n\nProceed?")==false) 
			return false; 
		else  

			return true; 
	} 
<?php
// I generate a javascript array with all the names of the html <SELECT>s
$jsArray =  ("var mySelects = Array(");
foreach ($_SESSION['seats'] as $key=>$val) {
	$jsArray .= ("'[ $val ]', ");
}
$jsArray = substr($jsArray, 0, -2); // to remove the last ", "
$jsArray .= ");\n";
echo ($jsArray);
?>
	function updateTotal()
	{
		var total = 0;
		for (var i = 0; i < mySelects.length; i ++) { // for each select
			var mySelect = eval("document.myform.".$mySelects{$i}); // i get the reference of the select
			total = total + mySelect{mySelect.selectedIndex}; // the select is an array, so I have to get the selected item
		}
		// now, i can put the calculated value in the field
		document.myform.myTotalField.value = total;
	}
</script> 
</head> 

<body> 
<table width="100%"  border="0" cellspacing="0" cellpadding="0"> 
  <tr> 
    <td><div align="center" class="style1"> 
      <p>Tickets Stage 2 <br> 
(see subnote in code):</p> 
      <p>&nbsp;</p> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<?php
include 'config.php';
$db= mysql_connect($db_host,$db_user,$db_pass) or die (mysql_error()); 

mysql_select_db ($db_name) or die (mysql_error()); 
$eventid = $_GET['eventid']; 
$datestamp = $_GET['datestamp']; 
$query = "SELECT * FROM events WHERE eventid = '$eventid'";  

$result=mysql_query($query) or die (mysql_error());  

while($r=mysql_fetch_array($result)) 
{ 
	$id=$r["id"]; 
	$datestamps=$r["datestamp"]; 
	$costadult=$r["costadult"]; 
	$costchild=$r["costchild"]; 
	$costconcession=$r["costconcession"]; 
} 
session_register('eventid');  

$_SESSION['eventid'] = $eventid;  

session_register('costadult'); 
$_SESSION['datestamp'] = $datestamp; 
session_register('datestamp'); 
$_SESSION['costadulta'] = $costadult; 
session_register('costchild'); 
$_SESSION['costchilda'] = $costchild; 
session_register('costconcession'); 
$_SESSION['costconcessiona'] = $costconcession; 

$eventsid2 = $_SESSION['eventid']; 
$datestamp2 =$_SESSION['datestamp']; 
// echo "$eventsid2 -> $datestamp2 -> $costadult/$costchild/$costconcession"; 
?> 

  <td width="18%"><div align="left"></div></td> 
  <td width="82%"><p align="left">Event Selected: <strong><?php 
  mysql_select_db ($db_name) or die (mysql_error()); 
$query = "SELECT * FROM eventdata WHERE event_id = '$eventid2'";  

$result=mysql_query($query) or die (mysql_error());  

while($r=mysql_fetch_array($result)) 
{ 
$id=$r["id"]; 
$event_id=$r["event_id"]; 
$event_date=$r["event_date"]; 
$event_name=$r["event_name"]; 
$event_notes=$r["event_notes"]; 
} 
  echo "$event_name</strong>  [ Event ID : $eventid2 ]";?><br> 
    Date: <strong><?php 
$qt=mysql_query("select * from events"); 

while($nt=mysql_fetch_array($qt)){ 
echo "".date("d-m-Y",strtotime($nt[datestamp]))."$nt[datestamp] "; 
} 
?></strong>  <br> 
    Block: <strong><?php $_GET['block']; echo $block;?></strong><br> 
    Row: <strong><?php $_GET['row']; echo $row;?></strong><br> 
    Seat(s): <strong><?php $_GET['seat']; echo $seat;?> - $seat</strong> (or $seat if singular) <br> 
    <br> 
  </p> 
    </td> 
</tr> 
<tr height="1"> 
  <td></td> 
  <td background="images/obgg.jpg"></td> 
</tr> 
<tr> 
  <td><div align="left"></div></td> 
  <td><p align="left"><br> 
<strong>Ticket BreakDown </strong>(<strong><a href="#" alt="Please chose the appropriate ticket type for each seat chosen.">?</a></strong>)</p> 
    <p align="left"><?php echo "$block$row$seat";?> 
      <?php
	echo "<form name=\"myform\">"; 
foreach ($_SESSION['seats'] as $key=>$val)  

{  

	// get seat data 

$query = "SELECT * FROM arena WHERE seat_id = '$val'";  
$result=mysql_query($query) or die (mysql_error());  
while($r=mysql_fetch_array($result)) { 
	$id=$r["id"]; 
	$seat_id=$r["seat_id"]; 
	$ticket_block=$r["block"]; 
	$ticket_row=$r["row"]; 
	$ticket_seat=$r["seat"]; 
	$costadultb=$r["costadult"]; 
	$costchildb=$r["costchild"]; 
	$costconcessionb=$r["costconcession"]; 
} 
// re-defining ticket cost sessions 
$ticket_full = "$ticket_block$ticket_row$ticket_seat"; 
echo "<table width=\"50%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> 
    <td width=\"15%\">$ticket_full -> </td> 
    <td>    <select name=\"[ $seat_id ]\" class=\"style1\" onchange='updateTotal();'> 
<option value=\"none\" selected>-- Please Choose Ticket Type --</option> 
<option value=\"$costadultb\">Adult @ [ £$costadultb ]</option> 
<option value=\"costchildb\">Child @ [ £$costchildb ]</option> 
<option value=\"costconcessionb\">Concession @ [ £$costconcessionb ]</option> 
      </select><br><br></td> 
  </tr> 
</table>"; 
// Select data from Database where seats_id = the id taken from the session is 0001 for block A row A seat 1 
}  

?> 
 Ticket Total: <input type=text value="£0.00" name="myTotalField" class="style1" disabled='disabled'></form> 
  </p> 
    <p align="left"><br> 
      <br> 
      Booking Fee:&pound;<?php echo $bfee = "1.50"; "$bfee";?></p> 
      <?php 
      function makeRandomPassword() {  

  $salt = "ABCDEFGHIJKLMNOPQRSTUVWXYZabchefghjkmnpqrstuvwxyz0123456789";  

  srand((double)microtime()*1000000);  

      $i = 0;  

      while ($i <= 8) {  

    $num = rand() % 33;  

    $tmp = substr($salt, $num, 1);  

    $pass = $pass . $tmp;  

    $i++;  

      }  

      return $pass;  

}  

$random_id = makeRandomPassword();  

?> 
    <p align="left"><a href='booking.php?<?php echo "event=$event_id&id=$random_id";?>&confirmid=<?php echo session_id();?>' onclick='return confirmBooking()' class='style1'><strong>Proceed</strong></a> | <a href='start_over.php?start_over&confirmid=<?php echo session_id();?>' onclick='return deleteBooking()' class='style1'><strong>Cancel</strong></a></p></td> 
</tr> 
      </table> 
      <p>&nbsp; </p> 
    </div></td> 
  </tr> 
</table> 
<table width="100%"  border="0" cellspacing="0" cellpadding="0"> 
  <tr> 
    <td><div align="center"> 
<?php include 'footer.php';?> 
      </div> 
<div align="center"></div></td> 
  </tr> 
</table> 
<p>&nbsp;</p> 
<p align="center" class="style1">&nbsp;</p> 
<p>&nbsp;</p> 
</body> 
</html>