Need to Apply a formula for a text box in my form! not working

saravanataee · January 4, 2013

Hi there,

Following is the code of mine where i want the textbox named t8 to be loaded based on the value of combo named 'subcat3' , textbox name 'MRP', and textbox named 't7'.

The real formula is as applied in the form

this.t8.value=this.t8.value*subcat3*MRP-(MRP*t8/100)

i tried to apply the above formula but it doesnot load anything.!!

Dont know what prob..

Can anyone help me!!

Thanks


<?php

mysql_connect('localhost', 'root', '');
mysql_select_db('inventorydb');
?>

<?php

require "config.php"; 
?>

<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>Purchase Order Form</title>
<meta name="GENERATOR" content="Arachnophilia 4.0">
<meta name="FORMATTER" content="Arachnophilia 4.0">
<SCRIPT language="javascript">
function reload(form)
{
var val=form.cat.options[form.cat.options.selectedIndex].value; 
self.location='po.php?cat=' + val ;
}
function reload3(form)
{
var val=form.cat.options[form.cat.options.selectedIndex].value; 
var val2=form.subcat.options[form.subcat.options.selectedIndex].value; 

self.location='po.php?cat=' + val + '&cat3=' + val2 ;
}

</script>
</head>

<body>
<h1>Place an Order</h1>
<?php


///////// Getting the data from Mysql table for first list box//////////
$quer2=mysql_query("SELECT DISTINCT itemname,item_id FROM item order by itemname"); 
///////////// End of query for first list box////////////

/////// for second drop down list we will check if category is selected else we will display all the subcategory///// 
if(isset($_GET['cat'])) {
$cat=$_GET['cat']; // This line is added to take care if your global variable is off
}
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT DISTINCT packingname,packing_id FROM packing where item_id=$cat order by packingname"); 
}else{$quer=mysql_query("SELECT DISTINCT packingname,packing_id FROM packing order by packingname"); } 
////////// end of query for second subcategory drop down list box ///////////////////////////


/////// for Third drop down list we will check if sub category is selected else we will display all the subcategory3///// 
if(isset($_GET['cat3'])) {
$cat3=$_GET['cat3']; // This line is added to take care if your global variable is off
}
else
{
$cat3 = "";
}
if(isset($cat3) and strlen($cat3) > 0){
$quer3=mysql_query("SELECT DISTINCT sizename FROM size where packing_id=$cat3 order by sizename"); 
}else{$quer3=mysql_query("SELECT DISTINCT sizename FROM size order by sizename"); } 
////////// end of query for third subcategory drop down list box ///////////////////////////


?>
<form method=post name=f1 action=''>

<table border='1' >

               <tr>
                       <td><label for="t1">Item</label></td>
                       <td><label for="t2">Quantity</label></td>
<td><label for="t2">Packing</label></td>
                       <td><label for="t2">Quantity in NO</label></td>
                       <td><label for="t2">MRP/RATE</label></td>
                       <td><label for="t2">Discount</label></td>
                       <td><label for="t2">Amount</label></td>





               </tr>
               <tr> <td> 
<?php
//////////        Starting of first drop downlist /////////
echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while($noticia2 = mysql_fetch_array($quer2)) { 
if($noticia2['item_id']==@$cat){echo "<option selected value='$noticia2[item_id]'>$noticia2[itemname]</option>"."<BR>";}
else{echo  "<option value='$noticia2[item_id]'>$noticia2[itemname]</option>";}
}
echo "</select>";

?>
</td>

<td><input name="t3" id="t3" size="10" value=""></td>
<td>
<?php
//////////////////  This will end the first drop down list ///////////

//////////        Starting of second drop downlist /////////
echo "<select name='subcat' onchange=\"reload3(this.form)\"><option value=''>Select one</option>";
while($noticia = mysql_fetch_array($quer)) { 
if($noticia['packing_id']==@$cat3){echo "<option selected value='$noticia[packing_id]'>$noticia[packingname]</option>"."<BR>";}
else{echo  "<option value='$noticia[packing_id]'>$noticia[packingname]</option>";}
}
echo "</select>";
//////////////////  This will end the second drop down list ///////////
?>
</td>

<td>
<?php


//////////        Starting of third drop downlist /////////
echo "<select name='subcat3' ><option value=''>Select one</option>";
while($noticia = mysql_fetch_array($quer3)) { 
echo  "<option value='$noticia[sizename]'>$noticia[sizename]</option>";

//echo  "<input type='text' name='' value='$noticia[sizename]'/>";
}
echo "</select>";
//////////////////  This will end the third drop down list ///////////

?>
</td>
<td><input name="MRP" id="t7" size="10"  value=""></td>
<td><input name="t7" id="t8" size="10" placeholder="40%" value=""></td>
<td><input name="t8" id="t8" size="10" onchange="this.t8.value=this.t8.value*subcat3*MRP-(MRP*t8/100)" value=""></td>



</tr>
<tr>
<td></td><td></td><td></td><td></td>     
<td><input type="submit" name="submit" value="Place Order"></td>
                       <td><input type="reset" name="submit1" value="Reset"></td>
<td></td> </tr>

</body>

</html>

<?php
if(isset($_POST['submit']))
     {          


                                       $item=$_POST['cat'] ;
                                       $qty= $_POST['t3'] ; 
                                       $pack= $_POST['subcat'] ; 
                                       $qtyno= $_POST['subcat3'] ; 
                                       $mrp= $_POST['MRP'] ; 
                                       $dis= $_POST['t7'] ; 
                                       $amt= $_POST['t8'] ; 






              $query=  mysql_query("INSERT INTO `po`(Item,Quantity,Packing, QuantityNO, MRP, Discount, Amount) VALUES ('$item','$qty','$pack','$qtyno','$mrp','$dis','$amt')"); 
                if(!$query)
{
die('Query Failed with exception'.mysql_error());
}
}
?>

cpd · January 4, 2013

I'd love to know what debugging steps you've taken so far?

That said you need to learn how to correctly select a form.

form = document.forms["TheNameOfMyForm"];

Why have you got an HTML 3.2 DOCTYPE as well? Out of curiosity.

Sign In

Need to Apply a formula for a text box in my form! not working

Recommended Posts

saravanataee

Link to comment

Share on other sites

cpd

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information