www.webdeveloper.com
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Oct 2011
    Posts
    349

    problem in document.getElementById where value is from array

    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($Items123);
        
    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
    Attached Images Attached Images

  2. #2
    Join Date
    Feb 2012
    Location
    Bokaro Steel City (Jharkhand), India!
    Posts
    194
    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>
    Last edited by TheAliveWinner; 04-29-2012 at 08:49 PM. Reason: I am crazy! :)
    "It will never rain roses: when we want to have more roses, we must plant more roses." - George Eliot

  3. #3
    Join Date
    Oct 2011
    Posts
    349
    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
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles