Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Problem in Subtraction (http://www.go4expert.com/forums/problem-in-subtraction-t24126/)

newphpcoder 9Dec2010 07:51

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..

shabbir 9Dec2010 08:50

Re: Problem in Subtraction
 
First you have to understand the difference between PHP and HTML.

PHP is server side and HTML is client side.

You are calculating when you post in server side but in your HTML you missed the submit button and so that calculation is never executed.

Again you are calculating in variables which are never displayed in HTML and so again if calculation happens then also your values will not show in the output field.

newphpcoder 9Dec2010 08:59

Re: Problem in Subtraction
 
Quote:

Originally Posted by shabbir (Post 75681)
First you have to understand the difference between PHP and HTML.

PHP is server side and HTML is client side.

You are calculating when you post in server side but in your HTML you missed the submit button and so that calculation is never executed.

Again you are calculating in variables which are never displayed in HTML and so again if calculation happens then also your values will not show in the output field.


I revised my code:
PHP Code:

<?php
  
include("config.php");
  
  
$query "SELECT operation_name FROM clt_traceability WHERE operation_name = '01. Spreading'";
  
$result mysql_query($query);
  
  if (
mysql_fetch_row($result))
  {     
  
$inqty $_POST['input_qty'];
  
$outqty $_POST['output_qty'];
  
$qty $_POST['variance_qty'];
  
  
$qty $inqty $outqty;
  }
  
?>
<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>
<form action="qty.php" method="post" name="qty">
<?php
echo "Input:<input type='text' name='inqty' id='inqty'onkeypress='return handleEnter(event,\"outqty\");' /><br />";
echo 
"Output:<input type='text' name='outqty' id='outqty'onkeypress='return handleEnter(event,\"qty\");' /><br />";
echo 
"Qty:<input type='text' name='qty' id='qty'onkeypress='return handleEnter(event,\"saveform0\");' /><br />";
echo 
"<p><input type='submit' value='  Save  ' id='saveform' /></p>";
?>
</form>
</body>
</hmtl>

Stil the qty was not appear.

shabbir 9Dec2010 09:48

Re: Problem in Subtraction
 
Still you are not submitting the form buddy.

newphpcoder 9Dec2010 10:30

Re: Problem in Subtraction
 
Quote:

Originally Posted by shabbir (Post 75686)
Still you are not submitting the form buddy.

How can I submit?

newphpcoder 9Dec2010 11:06

Re: Problem in Subtraction
 
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

shabbir 9Dec2010 15:38

Re: Problem in Subtraction
 
You are trying to subtract two numbers in PHP but this can simply be done in plain and simple HTML

See

Code:

<INPUT TYPE="text" NAME="qty1" Value="">
<INPUT TYPE="text" NAME="qty2" value="">
<INPUT TYPE="text" NAME="res" value="">
<INPUT TYPE="submit" onClick="res.value=qty1.value-qty2.value">

Now I understand that you have some added things to be done in PHP and for that you have to use the POST to get the value, do the calc and then show again.

newphpcoder 10Dec2010 05:25

Re: Problem in Subtraction
 
Quote:

Originally Posted by shabbir (Post 75694)
You are trying to subtract two numbers in PHP but this can simply be done in plain and simple HTML

See

Code:

<INPUT TYPE="text" NAME="qty1" Value="">
<INPUT TYPE="text" NAME="qty2" value="">
<INPUT TYPE="text" NAME="res" value="">
<INPUT TYPE="submit" onClick="res.value=qty1.value-qty2.value">

Now I understand that you have some added things to be done in PHP and for that you have to use the POST to get the value, do the calc and then show again.


this is the new test code:
PHP Code:

PHP Code:
<?php
    
include("config.php");
    
$qty 0;
if(
$_POST['submit']){
$inqty $_POST['inqty'];
$outqty $_POST['outqty'];
}  
$qty $inqty $outqty;
?>
<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>
<form action="qty.php" method="post" name="testqty">
Input:<input type='text' name='inqty' id='inqty' />
Output:<input type='text' name='outqty' id='outqty'/> <br>
Qty:<input type='text' name='qty' id='qty' value = '<?php echo $qty?>' /><br>
<input type='submit' value='save' name='submit' id='submit'>
</form>
</body>
</hmtl>

In this code the qty was appear after I click the save button.
I want to happen is After I input numbers in input qty I press the enter key then the cursor will be in the output qty then after i input numbers in output text filed and I press the enter key the result should be appear automatically without pressing the button.
I try this code:
PHP Code:

PHP Code:
<?php
    
include("config.php");
    
$qty 0;
if(
$_POST['qty']){
$inqty $_POST['inqty'];
$outqty $_POST['outqty'];
}  
$qty $inqty $outqty;
?>
<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>
<form action="qty.php" method="post" name="testqty">
<?php
echo"Input:<input type='text' name='inqty' id='inqty' onkeypress='return handleEnter(event,\"outqty\");' />";
echo
"Output:<input type='text' name='outqty' id='outqty' onkeypress='return handleEnter(event,\"qty\");' /> <br>";
echo 
"Qty:<input type='text' name='qty' id='qty' value = '<?php echo $qty; ?>' onkeypress='return handleEnter(event,\"inqty\");' />";
?>
</form>
</body>
</hmtl>

The output of this code is the value of the text field of qty was the <?php echo $qty; ?>
Thank you

newphpcoder 10Dec2010 05:29

Re: Problem in Subtraction
 
Quote:

Originally Posted by shabbir (Post 75694)
You are trying to subtract two numbers in PHP but this can simply be done in plain and simple HTML

See

Code:

<INPUT TYPE="text" NAME="qty1" Value="">
<INPUT TYPE="text" NAME="qty2" value="">
<INPUT TYPE="text" NAME="res" value="">
<INPUT TYPE="submit" onClick="res.value=qty1.value-qty2.value">

Now I understand that you have some added things to be done in PHP and for that you have to use the POST to get the value, do the calc and then show again.

i want to happen is after I enter numbers in input and output and I press enter the result would be show in qty eventhough the next to output is id#

newphpcoder 10Dec2010 06:11

Re: Problem in Subtraction
 
I revised my code:
PHP Code:

PHP Code:
include(
"config.php");
?>
<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>
        -->
        
<script language="javascript" >
var inqty = document.getElementById('inqty')
var outqty = document.getElementById('outqty')
myqty = inqty - outqty 
document.form-name.myqty.value = myqty 
</script>
</head>
<body>
<form action="qty.php" method="post" name="form-name">
Input:<input type='text' name='inqty' id='inqty' />
Output:<input type='text' name='outqty' id='outqty'/> <br>
Qty:<input type='text' name='myqty' id='myqty' /><br>
</form>
</body>
</html> 

And it did not work


All times are GMT +5.5. The time now is 09:08.