[RESOLVED] Automatic Calculations in Jscript

beyers

Hi all, I still have this one problem with getting an automated calculation in Jscript and displaying and writing it to database. If anyone could please help it'll be greatly apprciated.
Thanks

heres the jscript code:

And heres the php code
<td class="header"><div align="center"><strong>R</strong>
<input type="text" name="stock_unitprice" id="stock_unitprice" >
</div></td>
<td class="header"><div align="center">

<input type="text" name="stock_markup" id="stock_markup" onChange="IsItReady(stockForm)">
<strong>%</strong></div></td>
<td class="header"><div align="center">
<strong>R</strong>

<input name="stock_ourprice" type="text" size="15" id="stock_ourprice">
</div></td>

And heres the database part.

if (isset($POST['form_complete']))
{
if (isset($POST['stock_code']))
{
$query = "UPDATE stock SET " .

				"stock_add = 0, " . 
				"stock_description = '" . $_POST['stock_description'] . "'," . 
				"stock_category = '" . $_POST['stock_category'] . "'," . 
				"stock_type_ID = '" . $_POST['stock_type_ID'] . "', " . 
				"stock_qty = '" . $_POST['stock_qty'] . "', " .
				"stock_serial = '" . $_POST['stock_serial'] . "'," . 
				"stock_date = NOW(), " . 
				"stock_unitprice = '" . $_POST['stock_unitprice'] . "'," .
				"stock_markup = '" . $_POST['stock_ourprice'] . "'," .
				"stock_ourprice = '" . $_POST['stock_ourprice'] . "'" .

				"WHERE stock_code = " . $_POST['stock_code'];

	if (!$result = mysql_query($query, $link)) 
		die("<p>Cannot save updated stock information!</p><p>" . mysql_error() . "</p><p>" . $query . "</p>");
}

Please please help

LoganK

A) This is a PHP forum, not a JavaScript forum.

😎 JavaScript cannot use a variable like this: form.stock_unitprice. It thinks you're trying to access a form named "form", not substitute the variable.

maxpup979

Something along these lines should do the trick for the JS.

LoganK

Did you test that?

maxpup979

ayup. in firefox and IE6--worked dandy. Although it really shouldnt.

should at least change the onChange to not be form, but rather test

LoganK

Did it work when you changed the form's name to test?

maxpup979

yeah. worked fine. Just should not have. Thats what threw me. no errors in the JS console, and it worked just like it was supposed to. figured the code was correct...🙂

LoganK

Something's not right with that...

maxpup979

I am figuring that since it is the only form, the DOM is just making assumptions. It is quite strange though. I did double check the JS console, and it isnt throwing a single error. very strange. I also was pretty unsure about passing the whole form in, rather than using the this syntax, but it worked just fine. very odd.....

LoganK

I agree...very odd...then again, whaddya gonna do about it??

😃

beyers

Thanks so much for your sollution. It is working as expected. I know it was mostly a Jscript issue but just thought you PHP people are much smarter than most on a jscriopt forum. Thanks again

LoganK

Glad it worked out for you!