Already a member?

shabbir

My Code works for you or not? If it works use that code and change the events when you want the result to appear.

newphpcoder

Quote:

Originally Posted by shabbir
My Code works for you or not? If it works use that code and change the events when you want the result to appear.

In the code:

Code:

<html>
<head>
<script type="text/javascript">
var subtract = function(c, b, output){
  output.value = c.value-b.value;
  
}
</script>
<input type="text" id="c" value="0"/>-<input type="text" id="b" value="0"/>=<input type="text" id="a" value="0"/><br/>
<input type="text" id="d" value="0" />
<script type="text/javascript">
document.getElementById('c').onmousedown = function(){
subtract(document.getElementById('c'), document.getElementById('b'), document.getElementById('a'), document.getElementById('d'));
}
document.getElementById('b').onmousedown = function(){
subtract(document.getElementById('c'), document.getElementById('b'), document.getElementById('a'), document.getElementById('d'));
}
</script>
</head>
</html>

how can i used it in php and also the onkeyenter because in my real webpage my code for input type is like this:

PHP Code:


			
echo "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"idno" . $ctr . "\");' /></td>";
echo "\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' onkeypress='return handleEnter(event,\"varsublot" . $ctr . "\");' /></td>";
and i have this code:
</style>
    <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>

I'm sorry, because I'm not good in codeing and analyzing..I really need to fix this problem..
Thank you

shabbir

This is not the problem of coding. This is the problem with what PHP can do and cannot do and when.

PHP is server side programming and if you want an answer in the user screen with some field calculation you don't need any PHP.

See my code and that should do the job for you. All you have to do is make sure you make that code appear in the right event handler.

newphpcoder

Quote:

Originally Posted by shabbir
This is not the problem of coding. This is the problem with what PHP can do and cannot do and when.

PHP is server side programming and if you want an answer in the user screen with some field calculation you don't need any PHP.

See my code and that should do the job for you. All you have to do is make sure you make that code appear in the right event handler.

but my real code is almost pure php code:

here it is:

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>

Honestly, I don't know where i can put the code you suggeted. I really need to fix this problem, i don't know why, I'm sorry I'm not good in coding and analyzing.

I only want is the input and output should be subtract and the result would appear in varqty text field. when they press enter key.
Thank you

shabbir

Now my code does exactly the same. Would you mind running my code.

newphpcoder

Quote:

Originally Posted by shabbir
Now my code does exactly the same. Would you mind running my code.

Where i can put that 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">

newphpcoder

this code is for subtraction of input and output

Code:

<html>
<head>
<script type= "text/javascript">
function startCalc(){
  interval = setInterval("calc()",1);
 }
function calc(){
 var qty = new Array(2);
 qty[0] = parseFloat(document.myform.inqty.value);
  qty[1] = parseFloat(document.myform.outqty.value);
  
myqtyval = qty[0]-qty[1];
document.myform.myqty.value = myqtyval; 
}
function stopCalc(){
  clearInterval(interval);
}
</script>
</head>
<body>
<form name='myform' action='test.php' method='post'>
Input<input type='text' name='inqty'  onFocus='startCalc();' onBlur='stopCalc();' />
Output<input type='text' name='outqty'  onFocus='startCalc();' onBlur='stopCalc();' /><br/>
myqty<input type='text' name='myqty' value=''  />
<input type='submit' name='submit' value='save' />

</form>
</body>
</html>

My problem is how can I insert this code in my real codes where i need to have to subtract automatic the input and output of operation name 01 Spreading and 03 Setting. I'm sorry because I'm not good in mixing codes.

Code:

<?php
include("config.php");
$rexist = 0;
if($_POST["clt_no"])
    {
    $clt_date = $_POST["clt_date"];
    $query = "INSERT INTO clt_transact (clt_no, ac2l, b3, cloth_type, roll_no, transact_date, clt_date, pack_setting) VALUES ('" . $_POST["clt_no"] . "', '" . $_POST["ac2l"] . "', '" . $_POST["b3"] . "', '" . $_POST["cloth_type"] . "', '" . $_POST["roll_no"] . "', now(), '" . $clt_date . "', '" . $_POST["pack"] . "')";
    $result = mysql_query($query);
    $clt_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 clt_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, clt_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] . "', '" . $clt_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.clttype.clt_no.focus();">
<!--<p><a href="clt_definition.php">Clt Types</a>&nbsp;&nbsp;&nbsp;<a href="clt_query.php">Query</a></p>-->
<?php
include("menu.php");
?>
<form action="clt_main.php" method="post" name="clttype">
<?php
    $rexist = 1;
    
    echo "Clt No:<input type='text' name='clt_no' onkeypress='return handleEnter(event,\"clt_date\");' />";
    echo "<input type='radio' name='pack' id='mother' value='Mother Lot'  /> Mother Lot<br />";   
    echo "CLT Date:<input type='text' name='clt_date' onkeypress='return handleEnter(event,\"ac2l\");' />";
    echo "<input type='radio' name='pack' id='child' value='Child Lot' /> Child Lot";
      
    echo "<table>";
    echo "<tr><th class='myclass'>PARTS</th><th class='myclass'>LOT/BATCH #</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,\"cloth_type\");' /></td></tr>";
    echo "<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' onkeypress='return handleEnter(event,\"roll_no\");' /></td></tr>";
    echo "<tr><td>Roll No</td><td><input type='text' name='roll_no' id='roll_no' onkeypress='return handleEnter(event,\"timein0\");' /></td></tr>";
    echo "</table>";
    echo "<p>&nbsp;</p>";
    
    $query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
    $last_operation_name = "";
    $result = mysql_query($query);
    if($result)
        {
        $rexist = 1;
        echo "<p><center><b>OPERATOR AND MACHINE 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'>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' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";   
            echo "\n\t<td><input  type='text' name='timein[]' id='timein" . $ctr . "' onkeypress='return handleEnter(event,\"timeout" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='timeout[]' id='timeout" . $ctr . "' onkeypress='return handleEnter(event,\"inqty" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>";
            echo "\n\t<td>" . $row["input_unit"];
            echo "<input type='hidden' name='iun[]' value='" . $row["input_unit"] . "' /></td>";
            echo "\n\t<td><input  type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"idno" . $ctr . "\");' /></td>";
            echo "\n\t<td>" . $row["output_unit"];
            echo "<input type='hidden' name='oun[]' value='" . $row["output_unit"] . "'></td>";
            echo "\n\t<td><input  type='text' name='idno[]' id='idno" . $ctr . "' onkeypress='return handleEnter(event,\"mcno" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='mcno[]' id='mcno" . $ctr . "' onkeypress='return handleEnter(event,\"varqty" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='varqty[]' id='varqty" . $ctr . "' onkeypress='return handleEnter(event,\"varsublot" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='varsublot[]' id='varsublot" . $ctr . "' onkeypress='return handleEnter(event,\"dateshift" . $ctr . "\");' /></td>";
            echo "\n\t<td><input ' type='text' name='dateshift[]' id='dateshift" . $ctr . "' onkeypress='return handleEnter(event,\"shift" . $ctr . "\");' /></td>";
           echo "\n\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<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<td><input  type='text' name='timein[]' id='timein" . $ctr . "' onkeypress='return handleEnter(event,\"timeout" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='timeout[]' id='timeout" . $ctr . "' onkeypress='return handleEnter(event,\"inqty" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>";
            echo "\n\t<td>" . $row["input_unit"];
            echo "<input type='hidden' name='iun[]' value='" . $row["input_unit"] . "' /></td>";
            echo "\n\t<td><input  type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"idno" . $ctr . "\");' /></td>";
            echo "\n\t<td>" . $row["output_unit"];
            echo "<input type='hidden' name='oun[]' value='" . $row["output_unit"] . "'></td>";
            echo "\n\t<td><input  type='text' name='idno[]' id='idno" . $ctr . "' onkeypress='return handleEnter(event,\"mcno" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='mcno[]' id='mcno" . $ctr . "' onkeypress='return handleEnter(event,\"varqty" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='varqty[]' id='varqty" . $ctr . "' onkeypress='return handleEnter(event,\"varsublot" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='varsublot[]' id='varsublot" . $ctr . "' onkeypress='return handleEnter(event,\"dateshift" . $ctr . "\");' /></td>";
            echo "\n\t<td><input  type='text' name='dateshift[]' id='dateshift" . $ctr . "' onkeypress='return handleEnter(event,\"shift" . $ctr . "\");' /></td>";
            echo "\n\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='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>
</form>
</body>
</html>

shabbir

Why you want to mix them is not at all what I can understand. It can be a separate HTML bunch as well in the file.

newphpcoder

Quote:

Originally Posted by shabbir
Why you want to mix them is not at all what I can understand. It can be a separate HTML bunch as well in the file.

Actually, not all operation name will subtract the input and output only in oper1,oper3,oper4,and oper5.

my idea is select those operation then do the condition to subtract the input and output but i don't where in my codes I can do that.

I attach my wholecode

newphpcoder

I have the select statement code where only those operation name could subtract the input and output

Code:

SELECT t.operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name in ('operation_name1', 'operation_name3', 'operation_name4', 'operation_name5') AND t.clt_transact_id = c.clt_transact_id

my problem is where i can put this code in my php file and how thus the input and output subtract nad automatic the varqty was appear as the result of subtration of input and output.

Thank you...

shabbir Go4Expert Founder
10Dec2010,08:31	#11
	My Code works for you or not? If it works use that code and change the events when you want the result to appear.

newphpcoder Ambitious contributor
10Dec2010,08:39	#12
	Quote: Originally Posted by shabbir My Code works for you or not? If it works use that code and change the events when you want the result to appear. In the code: Code: <html> <head> <script type="text/javascript"> var subtract = function(c, b, output){ output.value = c.value-b.value; } </script> <input type="text" id="c" value="0"/>-<input type="text" id="b" value="0"/>=<input type="text" id="a" value="0"/><br/> <input type="text" id="d" value="0" /> <script type="text/javascript"> document.getElementById('c').onmousedown = function(){ subtract(document.getElementById('c'), document.getElementById('b'), document.getElementById('a'), document.getElementById('d')); } document.getElementById('b').onmousedown = function(){ subtract(document.getElementById('c'), document.getElementById('b'), document.getElementById('a'), document.getElementById('d')); } </script> </head> </html> how can i used it in php and also the onkeyenter because in my real webpage my code for input type is like this: PHP Code: echo "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>"; echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"idno" . $ctr . "\");' /></td>"; echo "\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' onkeypress='return handleEnter(event,\"varsublot" . $ctr . "\");' /></td>"; and i have this code: </style> <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> I'm sorry, because I'm not good in codeing and analyzing..I really need to fix this problem.. Thank you

shabbir Go4Expert Founder
10Dec2010,08:53	#13
	This is not the problem of coding. This is the problem with what PHP can do and cannot do and when. PHP is server side programming and if you want an answer in the user screen with some field calculation you don't need any PHP. See my code and that should do the job for you. All you have to do is make sure you make that code appear in the right event handler.

newphpcoder Ambitious contributor
10Dec2010,09:04	#14
	Quote: Originally Posted by shabbir This is not the problem of coding. This is the problem with what PHP can do and cannot do and when. PHP is server side programming and if you want an answer in the user screen with some field calculation you don't need any PHP. See my code and that should do the job for you. All you have to do is make sure you make that code appear in the right event handler. but my real code is almost pure php code: here it is: 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> </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> Honestly, I don't know where i can put the code you suggeted. I really need to fix this problem, i don't know why, I'm sorry I'm not good in coding and analyzing. I only want is the input and output should be subtract and the result would appear in varqty text field. when they press enter key. Thank you

shabbir Go4Expert Founder
10Dec2010,12:09	#15
	Now my code does exactly the same. Would you mind running my code.

Already a member?

Not a member yet?

Search Go4Expert

Latest Forum Topics

Find Us On Facebook

Latest Articles

newphpcoder Ambitious contributor
10Dec2010,12:24	#16
	Quote: Originally Posted by shabbir Now my code does exactly the same. Would you mind running my code. Where i can put that 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">

shabbir Go4Expert Founder
11Dec2010,09:13	#18
	Why you want to mix them is not at all what I can understand. It can be a separate HTML bunch as well in the file.

newphpcoder Ambitious contributor
13Dec2010,09:05	#20
	I have the select statement code where only those operation name could subtract the input and output Code: SELECT t.operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name in ('operation_name1', 'operation_name3', 'operation_name4', 'operation_name5') AND t.clt_transact_id = c.clt_transact_id my problem is where i can put this code in my php file and how thus the input and output subtract nad automatic the varqty was appear as the result of subtration of input and output. Thank you...

User Name:		Save
Password