SitePoint Sponsor

User Tag List

Results 1 to 13 of 13

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Jul 2010
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem in Subtraction

    Good day!

    I need to automatically subtract the input qty and output qty and the result should be appear in the text area of qty.

    the input qty and output qty depend on the operation name.

    i try this code:

    PHP Code:
    <?php
      
    include("config.php");
      
      
    $query "SELECT operation_name FROM clt_traceability WHERE operation_name = '01. Spreading'";
      
      
    $inqty $_POST['input_qty'];
      
    $outqty $_POST['output_qty'];
      
    $qty $_POST['variance_qty'];
      
      
    $qty $inqty $outqty;

      
    ?>
    <html>
    <body>
    Input<input type = 'text' name='inqty' id='inqty' />
    Output<input type = 'text' name='outqty' id='outqty' />
    Qty<input type = 'text' name='qty' id='qty' />
    </body>
    </hmtl>
    in this code when i enter input = 100 output= 50 and when I enter or I used tab no output in qty.

    Thank you..

  2. #2
    rajug.replace('Raju Gautam'); bronze trophy Raju Gautam's Avatar
    Join Date
    Oct 2006
    Location
    Kathmandu, Nepal
    Posts
    4,013
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think it should be something like this:
    PHP Code:
    <?php 
        
    //include("config.php"); 
        
    if($_SERVER['REQUEST_METHOD'] == 'POST'){
            
    //$query = "SELECT operation_name FROM clt_traceability WHERE operation_name = '01. Spreading'"; 
            
    $inqty $_POST['inqty']; 
            
    $outqty $_POST['outqty']; 
            
    $qty $inqty $outqty;
        }
    ?> 
    <html> 
        <body> 
            <form method="post" name="frm1" id="frm1" action="">
            Input : <input type="text" name='inqty' id='inqty' value="<?php echo isset($inqty) ? $inqty ''?>" /> 
            Output : <input type="text" name='outqty' id='outqty' value="<?php echo isset($outqty) ? $outqty ''?>" /> 
            Qty : <input type="text" name='qty' id='qty' value="<?php echo isset($qty) ? $qty ''?>" />
            <input name="btnsubmit" id="btnsubmit" value="Calculate" type="submit" />
            </form> 
        </body> 
    </html>
    Mistakes are proof that you are trying.....
    ------------------------------------------------------------------------
    PSD to HTML - SlicingArt.com | Personal Blog | ZCE - PHP 5

  3. #3
    Non-Member Kalon's Avatar
    Join Date
    Aug 2010
    Location
    At my computer
    Posts
    2,012
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by rhodarose View Post
    [PHP]
    <?php
    include("config.php");

    $query = "SELECT operation_name FROM clt_traceability WHERE operation_name = '01. Spreading'";

    $inqty = $_POST['input_qty'];
    $outqty = $_POST['output_qty'];
    $qty = $_POST['variance_qty'];

    $qty = $inqty - $outqty;


    ?>
    ..
    you are overwriting the $qty sent in $_POST['variance_qty'] with the value of $qty calculated in $qty = $inqty - $outqty.

    are you sure you really want to do this?

    and what is the purpose of the sql query in your code? I don't see it used anywhere.

  4. #4
    SitePoint Addict
    Join Date
    Jul 2010
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As I've on my first thread, that code is for testing purposes only. Now I will post the real code of my webpage which I need to add code for subtracting input qty and output qty and the result is automatically display in qty text field.

    PHP Code:
    <?php
    include("config.php");
    $rexist 0;
    if(
    $_POST["no"])
        {
        
    $clt_date $_POST["date"];
        
    $query "INSERT INTO clt (no, ac2l, b3, type, roll, t_date, date) VALUES ('" $_POST["no"] . "', '" $_POST["ac2l"] . "', '" $_POST["b3"] . "', '" $_POST["type"] . "', '" $_POST["roll"] . "', now(), '" $date "')";
        
    $result mysql_query($query);
        
    $transact_id mysql_insert_id();
        
        
    $opname $_POST["opname"];
        
    $timein $_POST["timein"];
        
    $timeout $_POST["timeout"];
        
    $inqty $_POST["inqty"];
        
    $iun $_POST["iun"];
        
    $outqty $_POST["outqty"];
        
    $oun $_POST["oun"];
        
    $idno $_POST["idno"];
        
    $mcno $_POST["mcno"];
        
    $varqty $_POST["varqty"];
        
    $varsublot $_POST["varsublot"];
        
    $dateshift $_POST["dateshift"];
        
    $shift $_POST["shift"];
        
        
    $totalarr count($opname) - 1;
        for(
    $ctr=0$ctr $totalarr$ctr++)
            {
            
    $inqty[$ctr] = (float) $inqty[$ctr];
            
    $varqty[$ctr] = (float) $varqty[$ctr];
            
    $outqty[$ctr] = (float) $outqty[$ctr];
            
    $query "INSERT INTO traceability (operation_name, time_in, time_out, input_qty, input_unit, output_qty, output_unit, id_no, mc_no, variance_qty, variance_sublot, date, shift, transact_id) VALUES ('" $opname[$ctr] . "', '" $timein[$ctr] . "', '" $timeout[$ctr] . "', '" $inqty[$ctr] . "' , '" $iun[$ctr] . "' ,'" $outqty[$ctr] . "', '" $oun[$ctr] . "' , '" $idno[$ctr] . "', '" $mcno[$ctr] . "', '" $varqty[$ctr] . "', '" $varsublot[$ctr] . "', '" $dateshift[$ctr] . "', '" $shift[$ctr] . "', '" $transact_id "')";
            
    $result mysql_query($query);
            
            }   
        }
    $rexist 0;
    ?>
    <html>
    <head>
        <script language="javascript">
        function handleEnter(e, nextfield)
            {
            var characterCode = (e && e.which)? e.which: e.keyCode;
            if(characterCode == 13)
                {
                document.getElementById(nextfield).focus();
                return false;
                } 
            else
                {
                return true;
                }
            }
        </script>
    </head>
    <body onLoad="document.type.no.focus();">
    <!--<p><a href="definition.php">Types</a><a href="query.php">Query</a></p>-->
    <?php
    include("menu.php");
    ?>
    <form action="main.php" method="post" name="type">
    <?php
        $rexist 
    1;
        echo 
    "<p>No:<input type='text' name='_no' onkeypress='return handleEnter(event,\"date\");' /><br />";
        echo 
    "Date:;<input type='text' name='date' onkeypress='return handleEnter(event,\"ac2l\");' /></p>";
        
        echo 
    "<table>";
        echo 
    "<tr><th class='myclass'>TRACEABILITY</th><th class='myclass'>LOT #</th></tr>";
        echo 
    "<tr><td>AC2L</td><td><input type='text' name='ac2l' id='ac2l' onkeypress='return handleEnter(event,\"b3\");' /></td></tr>";
        echo 
    "<tr><td>B3</td><td><input type='text' name='b3' id='b3' onkeypress='return handleEnter(event,\"type\");' /></td></tr>";
        echo 
    "<tr><td>Type</td><td><input type='text' name='type' id='type' onkeypress='return handleEnter(event,\"roll\");' /></td></tr>";
        echo 
    "<tr><td>Roll</td><td><input type='text' name='roll' id='roll' onkeypress='return handleEnter(event,\"timein0\");' /></td></tr>";
        echo 
    "</table>";
        echo 
    "<p>&nbsp;</p>";
        
        
    $query "SELECT * FROM trace_operations ORDER BY operation_name";
        
    $last_operation_name "";
        
    $result mysql_query($query);
        if(
    $result)
            {
            
    $rexist 1;
            echo 
    "<p><center><b>TRACEABILITY</center></b></p>";
            echo 
    "<table>";
            echo 
    "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>Time IN</th><th class='myclass'>Time OUT</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>UNIT</th><th class='myclass'>OUTPUT QTY</th><th class='myclass'>UNIT</th><th class='myclass'>NAME & ID #</th><th class='myclass'>MC #</th><th class='myclass'>VARIANCE Qty</th><th class='myclass'>VARIANCE Sub Lot</th><th class='myclass'>DATE</th><th class='myclass'>SHIFT</th></tr>";
            
    $totalrows mysql_num_rows($result);
            
    $trows $totalrows 1;
            for(
    $ctr 0$ctr $trows$ctr++)
                {
                
    $row mysql_fetch_array($result);
                
    $tctr $ctr 1;
                echo 
    "\n\t<tr>";
                echo 
    "\n\t\t<td>";
                if (
    $last_operation_name != $row["operation_name"]) echo $row["operation_name"];
                
    $last_operation_name $row["operation_name"];
                echo 
    "<input type='hidden' name='opname[]' value='" $row["operation_name"] . "' /></td>";   
                echo 
    "\n\t\t<td><input type='text' name='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='inqty[]' id='inqty" $ctr "' onkeypress='return handleEnter(event,\"outqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["input_unit"];
                echo 
    "<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["output_unit"];
                echo 
    "<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                echo 
    "\n\t\t<td><input type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='varsublot[]' id='varsublot" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift" $ctr "\");' /></td>";
               echo 
    "\n\t\t<td><input type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"timein" $tctr "\");' /></td>";
                echo 
    "\n\t</tr>";
                }
            if(
    $totalrows 1);
                {
                
    $row mysql_fetch_array($result);
                echo 
    "\n\t<tr>";
                echo 
    "\n\t\t<td>";
                if (
    $last_operation_name != $row["operation_name"]) echo $row["operation_name"];
                
    $last_operation_name $row["operation_name"];
                echo 
    "<input type='hidden'  name='opname[]' value='" $row["operation_name"] . "' /></td>";   
                echo 
    "<input type='hidden' name='opname[]' value='" $row["operation_name"] . "' /></td>";
                echo 
    "\n\t\t<td><input  type='text' name='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input  type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input  type='text' name='inqty[]' id='inqty" $ctr "' onkeypress='return handleEnter(event,\"outqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["input_unit"];
                echo 
    "<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                echo 
    "\n\t\t<td><input  type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td>" $row["output_unit"];
                echo 
    "<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                echo 
    "\n\t\t<td><input  type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='varqty[]' id='varqty" $ctr "' onkeypress='return handleEnter(event,\"varsublot" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='varsublot[]' id='varsublot" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift" $ctr "\");' /></td>";
                echo 
    "\n\t\t<td><input type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"saveform\");' /></td>";
                echo 
    "\n\t</tr>";
                }
            echo 
    "</table>";
            }
        echo 
    "<p><input type='submit' value='  Save  ' id='saveform' /></p>";
        echo 
    "<input type='hidden' name='typeno' value='" $_POST["typeno"] . "' />";
    ?>
    </form>
    </body>
    </html>
    I need to subtract input qty to output qty then the result is automatically display in qty text field, I want it to happen in the operation is 03. Spread and 03. Pack

  5. #5
    Non-Member Kalon's Avatar
    Join Date
    Aug 2010
    Location
    At my computer
    Posts
    2,012
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by rhodarose View Post
    As I've on my first thread, that code is for testing purposes only. Now I will post the real code of my webpage which I need to add code for subtracting input qty and output qty and the result is automatically display in qty text field.
    in your 1st post you don't mention the code there was for testing purposes only so I don't know for sure if this is your "real" code or not.

  6. #6
    SitePoint Addict
    Join Date
    Jul 2010
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Kalon View Post
    in your 1st post you don't mention the code there was for testing purposes only so I don't know for sure if this is your "real" code or not.
    Sorry, the new code that I post is the real code

  7. #7
    Non-Member Kalon's Avatar
    Join Date
    Aug 2010
    Location
    At my computer
    Posts
    2,012
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok if you say so, but I'm not so sure so I'll pass on this one.


Bookmarks

Posting Permissions

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