problem in document.getElementById where value is from array

**newphpcoder** · 04-29-2012 07:36 PM

Hi..

I have problem on how can I automatically display the output from the computation (Demanded Qty * Quantity), after or while I input Demanded Qty.

I mean I input Demanded Qty, on below it will display the output also beside the SubItems.

Sorry, if i post again my problem, because I have no idea on how can I solve this problem.

here is my code:

PHP Code:


<?php                                                                          

   error_reporting(0);

   date_default_timezone_set("Asia/Singapore"); //set the time zone  

$con = mysql_connect('localhost', 'root','');



if (!$con) {

    echo 'failed';

    die();

}

mysql_select_db("mes", $con);

?>

<html>

<title>Stock Requisition</title>

<head>

<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">

function compute_quantity(){

    var DemandedQty = document.getElementById('DemandedQty').value;

    var SubQty = document.getElementById('SubQty').value;

    var Quantity = document.getElementById('Quantity').value;

    

     SubQty = (DemandedQty * Quantity);

}

</script>

</head>

<body>

<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<div>

<table>

<thead>

<th>Items</th>

<th>Sub Items</th>

<th>Item Code</th>

<th>Demanded Qty</th>

<th>UoM</th>

<th>Class</th>

<th>Description</th>

<th>BIN Location</th>

</thead>

<?php



$DemandedQty = $_POST['DemandedQty'];



$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";

$res_bom = mysql_query($sql, $con);



while($row = mysql_fetch_assoc($res_bom)){

    

    $Items = $row['Items'];

    $Items_ = substr($Items, 12, 3);

    

echo "<tr>

        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items_' name='Items_[]' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>

        <td style='border:none;'>&nbsp;</td>

        <td style='border:none;'>&nbsp;</td> 

        <td style='border: none;'><center><input type='text' name='DemandedQty[]' id='DemandedQty' value='' size='12' onkeyup = compute_quantity()></center></td>     

        </tr>"; 

             

$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation, Quantity FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());



$res_sub = mysql_query($sql, $con);  

 

 while($row_sub = mysql_fetch_assoc($res_sub)){



     $Items1 = $row_sub['Items'];

     $SubItems = $row_sub['SubItems'];

     $ItemCode = $row_sub['ItemCode'];

     $UoM = $row_sub['UoM'];

     $Class = $row_sub['Class'];

     $Description = $row_sub['Description'];

     $BINLocation = $row_sub['BINLocation'];

     $Quantity = $row_sub['Quantity']; 

      

    echo "<input type='hidden' name='Quantity' id='Quantity' value='$Quantity'>";

    echo "<tr>

        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1' id='Items1' name='Items1[]'></td>

        <td style='border: none;'>&nbsp;<input type='text' name='SubItems[]' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>

        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode[]' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>

        <td style='border: none;'><center><input type='text' name='SubQty[]' id='SubQty' value='' size='12' style></center></td>

        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM[]' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>

        <td style='border: none;'>&nbsp;<input type='text' name='Class[]' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>

        <td style='border: none;'>&nbsp;<input type='text' name='Description[]' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size= '30'></td>

        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation[]' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>     

        </tr>";    

        

}

}               

?>

</table>

</div>

</form>

</body>

</html>

If you don't understand my issue feel free to ask me for further understanding.

I'm sorry again I really need to solve this and i tried to google but I can't find the solution.

Thank you so much

**TheAliveWinner** · 04-29-2012 08:46 PM

May be this would help or may be I do not understand your issue!

HTML Code:

<input placeholder="0" onkeyup="do_cal()" /> x 3 = <output>0</output>
    
<script>
    var do_cal = function () {
        var input = document.getElementsByTagName('input')[0].value;
        var output = document.getElementsByTagName('output')[0];
        output.innerHTML = input*3;
    }
</script>

**newphpcoder** · 04-29-2012 09:19 PM

Hi...

yes, your right it's an javascript issue:

I tried this:

Code:

<script language="JavaScript">
<!--
function CheckTextbox() {

var Items_;    
var DemandedQty;
var SubQty;
var Quantity;
// first set a reference to the textbox 
Items_ = document.getElementById('Items_');
DemandedQty = document.getElementById('DemandedQty');
SubQty = document.getElementById('SubQty');
Quantity = document.getElementById('Quantity');

//while(Items_.value == Items_.value){
// check if the textbox is NOT blank

if (DemandedQty.value != "" && Items_.value == Items_.value) {
SubQty.value = DemandedQty.value * Quantity.value;
//alert(SubQty.value);
//alert(Items_.value);
} else {

alert('nope');
}
}
//}
//-->
</script>

and now when I type on the DemandedQty it display the output on below, but only the first row of SubItems has display data. When I input data in Items P30 it did not work, only on the first Items which is P28.

I think I need loop?
But I don't know how can I code it in javascript to make it solve.

Thank you so much

Thread: problem in document.getElementById where value is from array

Thread Tools

Display

problem in document.getElementById where value is from array

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions