Sum the value

**hsriat** · May 20 '09, 10:55 PM

Originally posted by ddtpmyra

There's two text box that has to enter the the numbers from the user and below I want to display the total value the user inputed. How can I sum it up and have it displayed every they enter a number?

Or should I use a java script?
Can somebody show me how its done on JAVA technically no knowlege at all.

It will need JavaScript (not Java) dear.

Code:

Quantity #1 <Input type = 'text' Value ='0' Name ='qty1' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty2.value.match(/^[0-9]+$/)))  this.form.Total.value = this.value + this.form.dty2.value; else this.form.Total.value = "";'>
Quantity #2 <Input type = 'text' Value ='0' Name ='qty2' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty1.value.match(/^[0-9]+$/)))  this.form.Total.value = this.value + this.form.dty1.value; else this.form.Total.value = "";'>
Grand Total <input type = 'text' value ='' name ='Total' >

**dlite922** · May 20 '09, 11:14 PM

Hey ddtpmyra,

First you need to understand what PHP, Java, and JavaScript are. Besides languages, they have nothing else in common.

PHP is non-compiled script that is executed and run on the server. The output is plain text (or HTML).

Java is a compiled programming language that stands alone and runs on the computer it is executed on.

JavaScript is a scripting language in a web page that is executed within the user's web browser.

My recommendation for you is to read tutorials. One site that helps you with all of this and much more (and is a site we all basically started with) is www.w3schools.com Start there.

As to your problem, I would do this in JavaScript because it's trivial, quicker (no refresh), and pretty easy.

To get you interested, here's some code:

Code:

<html>
<head><title>Calculator</title></head>
<script language="JavaScript" type="text/JavaScript">
function calSum()
{
	var num1 = parseInt(document.getElementById('firstNum').value); 
	var num2 = parseInt(document.getElementById('secNum').value); 
	document.getElementById('result').innerHTML = (num1 + num2);
	return;
}
</script>
<body>
First Number: <input type="text" value="" name="firstNum" id="firstNum" /><br/>
Second Number: <input type="text" value="" name="secNum" id="secNum" /><br/>
<input type="button" value="Calculate Sum" onclick="calSum();" /><br/>
Answer: <span id="result"></span>
</body>
<html>

put that in a file, name it calculator.html and open it with your web browser.

to change and mess around with it, open it in notepad, change then save it. Refresh your browser to see your changes.

Good Luck!

Dan

**dlite922** · May 20 '09, 11:24 PM

If you had trouble getting hsriat's code to work because it concatenated the values instead of summing this, he made the same mistake I did, and you will make by not calling the "parseInt() " function first:

here's the updated, working code:

Code:

<form name="myForm" >
Quantity #1 <Input type = 'text' Value ='0' Name ='qty1' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty2.value.match(/^[0-9]+$/)))  this.form.Total.value = parseInt(this.value) + parseInt(this.form.qty2.value); else this.form.Total.value = "";'> 
Quantity #2 <Input type = 'text' Value ='0' Name ='qty2' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty1.value.match(/^[0-9]+$/)))  this.form.Total.value = parseInt(this.value) + parseInt(this.form.qty1.value); else this.form.Total.value = "";'> 
Grand Total <input type = 'text' value ='' name ='Total' > 
</form>

**hsriat** · May 20 '09, 11:46 PM

Originally posted by dlite922

If you had trouble getting hsriat's code to work because it concatenated the values instead of summing this, he made the same mistake I did, and you will make by not calling the "parseInt() " function first:

That usually happens when you think only "." (dot) can be used for concatenation.
Thanks for the rectification. :)

Cheers

[EDIT: And I have the right for making this excuse as we are in PHP forum ;)]

**ddtpmyra** · May 22 '09, 05:17 PM

dlite922,
First thanks for the code it works perfecty fine but I have <form> already on top it all and my button didn't work after adding it? Is this true you cannot have sub <form> inside PHP please correct me if I'm wrong. Or is there a another way to do the automatic computation without using <form>?

thanks!

Originally posted by dlite922

If you had trouble getting hsriat's code to work because it concatenated the values instead of summing this, he made the same mistake I did, and you will make by not calling the "parseInt() " function first:

here's the updated, working code:

Code:

<form name="myForm" >
Quantity #1 <Input type = 'text' Value ='0' Name ='qty1' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty2.value.match(/^[0-9]+$/)))  this.form.Total.value = parseInt(this.value) + parseInt(this.form.qty2.value); else this.form.Total.value = "";'> 
Quantity #2 <Input type = 'text' Value ='0' Name ='qty2' onkeyup='if ((this.value.match(/^[0-9]+$/) && this.form.qty1.value.match(/^[0-9]+$/)))  this.form.Total.value = parseInt(this.value) + parseInt(this.form.qty1.value); else this.form.Total.value = "";'> 
Grand Total <input type = 'text' value ='' name ='Total' > 
</form>

**dlite922** · May 25 '09, 10:01 PM

Originally posted by ddtpmyra

dlite922,
First thanks for the code it works perfecty fine but I have <form> already on top it all and my button didn't work after adding it? Is this true you cannot have sub <form> inside PHP please correct me if I'm wrong. Or is there a another way to do the automatic computation without using <form>?

thanks!

you don't have to use form. Instead of using "this.form" make sure the element has an "id" attribute and refer to it with "document.getEl ementById("theI Dhere").value"

make sure you spell "getElementById " <-- exactly like that. JavaScript is case sensitive.

Then you're not dependent on <form>

Cheers,

Dan

**ddtpmyra** · May 26 '09, 10:44 PM

Dan,

Thanks for all the help. It works!

DM

**ddtpmyra** · Sep 24 '09, 11:47 PM

please disregard this post

**Dormilich** · Sep 25 '09, 05:42 AM

Originally posted by ddtpmyra

Is this true you cannot have sub <form> inside PHP please correct me if I'm wrong.

this is not a matter of PHP. the HTML standard does not allow <form> inside another <form>.

**ddtpmyra** · Nov 5 '09, 11:31 PM

Okay now its getting complicated when I put it inside my PHP. Please tell me what did i wrong and why its not computing?

Code:

	<?PHP					
									$result = mysql_query("select Total from tblEvent_Entity where Cal_ID='{$id}' and Entity ='Organizations' ");
									$row = mysql_fetch_assoc($result);
									$TotalOrganizations =  $row['Total'];
									echo "<tr><td width='50%'>Organizations</td><td width='67%'><Input type = 'text' Name ='totalOrganizations'  id ='totalOrganizations' value='$row[Total]'
									onkeyup='if ((document.getElementById('totalOrganizations').match(/^[0-9]+$/) && document.getElementById('totalAgencies').value.match(/^[0-9]+$/)))  
									document.getElementById('Total').value =  parseInt(document.getElementById('totalOrganizations').value)) + parseInt(document.getElementById('TotalAgencies').value); 
									else document.getElementById('Total').value = '';>  
									</td></tr>";
									

									$result = mysql_query("select Total from tblEvent_Entity where Cal_ID='{$id}' and Entity ='Agencies' ");
									$row = mysql_fetch_assoc($result);
									$TotalAgencies=  $row['Total'];
									echo "<tr><td>Agencies</td><td width='67%'><Input type = 'text' Name ='totalAgencies' id='totalAgencies' value='$row[Total]'
									onkeyup='if ((document.getElementById('totalAgencies').match(/^[0-9]+$/) && document.getElementById('totalOrganizations').value.match(/^[0-9]+$/)))  
									document.getElementById('Total').value =(document.getElementById('totalOrganizations').value) + parseInt(document.getElementById('totalAgencies').value); 
									else document.getElementById('Total').value = '';>  
									</td></tr>";	

	 								echo "Grand Total <input type = 'text' value ='' name ='Total' id='Total' >  ";?>

**Markus** · Nov 6 '09, 05:55 PM

Originally posted by hsriat

[EDIT: And I have the right for making this excuse as we are in PHP forum ;)]

What's your excuse now? ;)

**ddtpmyra** · Nov 6 '09, 07:30 PM

Sum not calculating

I have two input box that I wanted to calculate the Total while the user inputing thier numbers on the text box. On my HTML format its works perfectly but when I applied it inside my PHP code it doesn't work anymore. I appreciate your time looking at this.

Code:

    <?PHP                     
                                    $result = mysql_query("select Total from tblEvent_Entity where Cal_ID='{$id}' and Entity ='Organizations' "); 
                                    $row = mysql_fetch_assoc($result); 
                                    $TotalOrganizations =  $row['Total']; 
                                    echo "<tr><td width='50%'>Organizations</td><td width='67%'><Input type = 'text' Name ='totalOrganizations'  id ='totalOrganizations' value='$row[Total]' 
                                    onkeyup='if ((document.getElementById('totalOrganizations').match(/^[0-9]+$/) && document.getElementById('totalAgencies').value.match(/^[0-9]+$/)))   
                                    document.getElementById('Total').value =  parseInt(document.getElementById('totalOrganizations').value)) + parseInt(document.getElementById('TotalAgencies').value);  
                                    else document.getElementById('Total').value = '';>   
                                    </td></tr>"; 
  
  
                                    $result = mysql_query("select Total from tblEvent_Entity where Cal_ID='{$id}' and Entity ='Agencies' "); 
                                    $row = mysql_fetch_assoc($result); 
                                    $TotalAgencies=  $row['Total']; 
                                    echo "<tr><td>Agencies</td><td width='67%'><Input type = 'text' Name ='totalAgencies' id='totalAgencies' value='$row[Total]' 
                                    onkeyup='if ((document.getElementById('totalAgencies').match(/^[0-9]+$/) && document.getElementById('totalOrganizations').value.match(/^[0-9]+$/)))   
                                    document.getElementById('Total').value =(document.getElementById('totalOrganizations').value) + parseInt(document.getElementById('totalAgencies').value);  
                                    else document.getElementById('Total').value = '';>   
                                    </td></tr>";     
  
                                     echo "Grand Total <input type = 'text' value ='' name ='Total' id='Total' >  ";?>

**acoder** · Nov 9 '09, 08:57 AM

Post the client-side generated (HTML) code. Also, remove the unnecessary indents to make the code easier to follow.

Do you get any JavaScript errors?

**ddtpmyra** · Nov 10 '09, 10:43 PM

Can you show me from my sample code what do you mean? Thanks for your help

Originally posted by acoder

Post the client-side generated (HTML) code. Also, remove the unnecessary indents to make the code easier to follow.

Do you get any JavaScript errors?

Sum the value

Sum the value

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment