addition of integers

javascript calculation

[Myrnalyn]

Hi all,
I'm creating a form for a Real Property Taxation and I need to have a calculation performed on some of the form inputs (a numerical value).

Basically, the user will enter a value into the fields (MARKET_VALUE)and(MARKET_VALUE2),and it will add directly as the MARKET_VALUE2 will be click and place the result on the MARKET_VALUE3 field. this is my code which does not add but just resulted to display the value of the two fields :
<script>
function calculate(form)
{
c = form.MARKET_VALUE.value + form.MARKET_VALUE2.value;

form.MARKET_VALUE3.value = c;
}
</script>

Is anyone able to help or point me in the right direction? please....i am glad to accept your valuable ideas

[sned]

I think you might have to convert those fields to integer values. I believe javascript just sees them as strings, and then concatenates, rather than adding them together.

I believe the command is parseInt:

parseInt(form.MARKET_VALUE.value)

-sned

[coopster]

This seems more of a JavaScript function than PHP here, so I moved this to the WebmasterWorld JavaScript Forum. And Welcome to WebmasterWorld, Myrnalyn!

[gergoe]

Do c = 0 + form.MARKET_VALUE.value + form.MARKET_VALUE2.value; to force javascript o convert the string values into an integer, or use one of the parseInt or parseFloat functions to convert the values into a number. However, both parseInt and parseFloat will return the javascript value NaN (Not A Number), so you can't just enclose them in such a way, you will need to check the numbers first (to make sure they are valid numbers, otherwise don't do the addition). The isNaN(parseFloat(string)) will do the validation to start with.

[mehh]

Take note:

parseInt("0xA") = 10

and

parseInt("0777")= 511

in some browsers
Always specify the base, most likely 10 in your case

parseInt("0xA",10) =0
parseInt("0777",10)=777

[Myrnalyn]

thanks a lot for all of your great ideas...its working i can add now..

[Myrnalyn]

in my form i have the Land Sketch area in which it contains the location of the certain land.what should i do in order to place the sketch map at the text area of Land sketch.

please help me i need your valuable ideas.thank you

[Myrnalyn]

Hi all,
i am creating an update form wherein i can view my data from the database and can perform to delete and edit data too. what should i do in order that i can edit my data and as well as save the edited data in the database.
this my code in the update form in which if i will click the save button to save the edited the data, the data will be deleted from the database it will just perform likely to my delete button.
<?php
$link=@mysql_connect("localhost","root","");
mysql_select_db("nn");

$r=$_REQUEST['r'];
if ($_REQUEST['r']!=''){

$query = "SELECT * FROM land_table where ARP_No = " . $r ;
$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result) or die(mysql_error());

}
if($_REQUEST['delete']!= 'delete'){

$query="delete from land_table where ARP_No = " .$r;
mysql_query($query);

}

if ($_REQUEST['save']!= 'save'){
$ARP_No=$_REQUEST['ARP_No'];
$PIN=$_REQUEST['PIN'];
$OTC_TCT_No=$_REQUEST['OTC_TCT_No'];
$SURVEY_No=$_REQUEST['SURVEY_No'];
$OWNER=$_REQUEST['OWNER'];
$ADDRESS=$_REQUEST['ADDRESS'];
$ADMIN_OCCUPANT=$_REQUEST['ADMIN_OCCUPANT'];
$ADD=$_REQUEST['ADD'];
$No_STREET=$_REQUEST['No_STREET'];
$BRGY=$_REQUEST['BRGY'];
$MUNICIPALITY=$_REQUEST['MUNICIPALITY'];
$PROVINCE=$_REQUEST['PROVINCE'];
$NORTH=$_REQUEST['NORTH'];
$EAST=$_REQUEST['EAST'];
$SOUTH=$_REQUEST['SOUTH'];
$WEST=$_REQUEST['WEST'];
$CLASSIFICATION=$_REQUEST['CLASSIFICATION'];
$SUB_CLASS=$_REQUEST['SUB_CLASS'];
$AREA=$_REQUEST['AREA'];
$ACTUAL_USE=$_REQUEST['ACTUAL_USE'];
$UNIT_VALUE=$_REQUEST['UNIT_VALUE'];
$MARKET_VALUE=$_REQUEST['MARKET_VALUE'];
$TOTAL=$_REQUEST['TOTAL'];
$PRODUCT_CLASS=$_REQUEST['PRODUCT_CLASS'];
$AREA_PLANTED=$_REQUEST['AREA_PLANTED'];
$TOTAL_NUMBER=$_REQUEST['TOTAL_NUMBER'];
$NON_FRUIT_BEARING=$_REQUEST['NON_FRUIT_BEARING'];
$FRUIT_BEARING=$_REQUEST['FRUIT_BEARING'];
$AGE=$_REQUEST['AGE'];
$UNIT_PRICE=$_REQUEST['UNIT_PRICE'];
$MARKET_VALUE2=$_REQUEST['MARKET_VALUE2'];
$TOTAL2=$_REQUEST['TOTAL2'];
$MARKET_VALUE3=$_REQUEST['MARKET_VALUE3'];
$ADJUSTMENT_FACTOR=$_REQUEST['ADJUSTMENT_FACTOR'];
$ADJ=$_REQUEST['ADJ'];
$VALUE_ADJUSTMENT=$_REQUEST['VALUE_ADJUSTMENT'];
$ADJUSTMENT_MARKET_VALUE=$_REQUEST['ADJUSTMENT_MARKET_VALUE'];
$KIND=$_REQUEST['KIND'];
$ACTUAL_USE2=$_REQUEST['ACTUAL_USE2'];
$ADJUSTMENT_MARKET_VALUE2=$_REQUEST['ADJUSTMENT_MARKET_VALUE'];
$ASSESSMENT_LEVEL=$_REQUEST['ASSESSMENT_LEVEL'];
$ASSESSED_VALUE=$_REQUEST['ASSESSED_VALUE'];
$PREVIOUS_OWNER=$_REQUEST['PREVIOUS_OWNER'];
$TAXABILITY=$_REQUEST['TAXABILITY'];
$PREVIOUS_ASSESSED_VALUE=$_REQUEST['PREVIOUS_ASSESSED_VALUE'];
$EFFECTIVITY=$_REQUEST['EFFECTIVITY'];
$PIN_PREVIOUS=$_REQUEST['PIN_PREVIOUS'];
$PIN_PRESENT=$_REQUEST['PIN_PRESENT'];
$PIN_POSTING=$_REQUEST['PIN_POSTING'];
$TDN_PREVIOUS=$_REQUEST['TDN_PREVIOUS'];
$TDN_PRESENT=$_REQUEST['TDN_PRESENT'];
$TDN_POSTING=$_REQUEST['TDN_POSTING'];
$ROLL_PAGE_PREVIOUS=$_REQUEST['ROLL_PAGE_PREVIOUS'];
$ROLL_PAGE_PRESENT=$_REQUEST['ROLL_PAGE_PRESENT'];
$ROLL_PAGE_POSTING=$_REQUEST['ROLL_PAGE_POSTING'];

$query="UPDATE land_table SET ARP_No = '$ARP_No', PIN='$PIN', 0TC_TCT_No='$OTC_TCT_No', SURVEY_No='$SURVEY_No', OWNER='$OWNER', ADDRESS='$ADDRESS',
ADMIN_OCCUPANT='$ADMIN_OCCUPANT', ADD='$ADD', No_STREET='$No_STREET',BRGY='$BRGY', MUNICIPALITY='$MUNICIPALITY', PROVINCE='$PROVINCE', NORTH='$NORTH', EAST='$EAST', SOUTH='$SOUTH',
WEST='$WEST', CLASSIFICATION='$CLASSIFICATION', SUB_CLASS'$SUB_CLASS', AREA='$AREA', ACTUAL_USE='$ACTUAL_USE', UNIT_VALUE='$UNIT_VALUE', MARKET_VALUE='$MARKET_VALUE', TOTAL='$TOTAL', PRODUCT_CLASS='$PRODUCT_CLASS',
AREA_PLANTED='$AREA_PLANTED', TOTAL_NUMBER='$TOTAL_NUMBER', NON_FRUIT_BEARING='$NON_FRUIT_BEARING', FRUIT_BEARING='$FRUIT_BEARING', 'AGE=$AGE', UNIT_PRICE='$UNIT_PRICE', MARKET_VALUE2='$MARKET_VALUE2', MARKET_VALUE3='$MARKET_VALUE3', ADJUSTMENT_FACTOR='$ADJUSTMENT_FACTOR',
ADJ.='$ADJ.', VALUE_ADJUSTMENT='$VALUE_ADJUSTMENT', ADJUSTED_MARKET_VALUE='$ADJUSTED_MARKET_VALUE', KIND='$KIND', ACTUAL_USE='$ACTUAL_USE2', ADJUSTED_MARKET_VALUE2='$ADJUSTED_MARKET_VALUE2', ASSESSMENT_LEVEL='$ASSESSMENT_LEVEL',ASSESSED_VALUE='$ASSESSED_VALUE',
PREVIOUS_OWNER='$PREVIOUS_OWNER', TAXABILITY='$TAXABILITY', PREVIOUS_ASSESSED_VALUE='$PREVIOUS_ASSESSED_VALUE', EFFECTIVITY='$EFFECTIVITY', PIN_PREVIOUS='$PIN_PREVIOUS', PIN_PRESENT='$PIN_PRESENT', PIN_POSTING='$PIN_POSTING', TDN_PREVIOUS='$TDN_PREVIOUS', TDN_PRESENT='$TDN_PRESENT', TDN_POSTING='$TDN_POSTING',
ROLL_PAGE_PREVIOUS='$ROLL_PAGE_PREVIOUS', ROLL_PAGE_PRESENT='$ROLL_PAGE_PRESENT', ROLL_PAGE_POSTING='$ROLL_PAGE_POSTING'";

mysql_query($query);

}

?>

please help me..

[edited by: jatar_k at 3:37 pm (utc) on Mar. 12, 2008]
[edit reason] fixed sidescroll [/edit]

[jatar_k]

[webmasterworld.com...]