Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 23rd, 2010, 02:34 AM
Registered User
 
Join Date: Dec 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sum of numbers that was insert will automatic compute and appear in total text field

Good day!

I have a problem in adding codes in my php codes, but I have the concept of codes that I want to add in my php codes, but I don't know if it is right. Kindly check my codes thank you.


And here is the code I want to add:
Code:
<?php
include 'config.php';
$rexist = 0;
if($_POST["clt_no"])
{
   $opname = $_POST["opname"];
   $inqty = $_POST["inqty"];
   $outqty = $_POST["outqty"];
   
   $totalarr = count($opname) - 1;
    for($ctr=0; $ctr < $totalarr; $ctr++)
        {
        $inqty[$ctr] = (float) $inqty[$ctr];
        $outqtyqty[$ctr] = (float) $outqty[$ctr];
        
         $query = "INSERT INTO clt_traceability (operation_name, input_qty, clt_transact_id) VALUES ('" . $opname[$ctr] . "',  '" . $inqty[$ctr] . "', '" . $outqty[$ctr] . "', '" . $clt_transact_id . "')";
        $result = mysql_query($query);
        }   
        
    $query = "SELECT * FROM clt_transact WHERE  clt_no = '" . $_POST["clt_no"] . "'";
    $result_no = mysql_query($query);
        if($result_no)
            {
            if(mysql_num_rows($result_no) > 0 )
            {
            $operation1_input = 0;
            $operation1_inputtotal = 0;
            
            $query = "SELECT SUM(t.input_qty) AS operation1_input FROM clt_traceability t, p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name 'Operation1' AND p.clt_no='" . $_POST["clt_no"] . "'";
            $resultyield = mysql_query($query);
            if($resultyield)
                {
                    if(mysql_num_rows($resultyield) > 0)$operation1_input =mysql_result($resultyield,0,"operation1_input");
                }
          
            $query = "SELECT operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name = 'Operation1_total' AND t.clt_transact_id = c.clt_transact_id";
            $result = mysql_query($query);
            if($result > 0)
            {           
            $operation1_inputtotal = $operation1_input;
          
            }
            }
            
            if(mysql_num_rows($result_no) > 0 )
            {
            $operation1_output = 0;
            $operation1_outputtotal = 0;
            
            $query = "SELECT SUM(t.output_qty) AS operation1_output FROM clt_traceability t, p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name 'Operation1' AND p.clt_no='" . $_POST["clt_no"] . "'";
            $resultyield = mysql_query($query);
            if($resultyield)
                {
                    if(mysql_num_rows($resultyield) > 0)$operation1_output =mysql_result($resultyield,0,"operation1_output");
                }
          
            $query = "SELECT operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name = 'Operation1_total' AND t.clt_transact_id = c.clt_transact_id";
            $result = mysql_query($query);
            if($result > 0)
            {           
            $operation1_outputtotal = $operation1_output;
          
            }
            }
            
            if(mysql_num_rows($result_no) > 0 )
            {
            $operation2_input = 0;
            $operation2_inputtotal = 0;
            
            $query = "SELECT SUM(t.input_qty) AS operation2_input FROM clt_traceability t, p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name 'Operation2' AND p.clt_no='" . $_POST["clt_no"] . "'";
            $resultyield = mysql_query($query);
            if($resultyield)
                {
                    if(mysql_num_rows($resultyield) > 0)$operation2_input =mysql_result($resultyield,0,"operation2_input");
                }
        
            $query = "SELECT operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name = 'Operation2 _total' AND t.clt_transact_id = c.clt_transact_id";
            $result = mysql_query($query);
            if($result > 0)
            {           
            $operation2_total = $operation2_input;
          
            }
            }
            
             if(mysql_num_rows($result_no) > 0 )
            {
            $operation2_output = 0;
            $operation2_ouputtotal = 0;
            
            $query = "SELECT SUM(t.output_qty) AS operation2_output FROM clt_traceability t, p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name 'Operation2' AND p.clt_no='" . $_POST["clt_no"] . "'";
            $resultyield = mysql_query($query);
            if($resultyield)
                {
                    if(mysql_num_rows($resultyield) > 0)$operation2_output =mysql_result($resultyield,0,"operation2_output");
                }
        
            $query = "SELECT operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name = 'Operation2 _total' AND t.clt_transact_id = c.clt_transact_id";
            $result = mysql_query($query);
            if($result > 0)
            {           
            $operation2_outputtotal = $operation2_output;
          
            }
            }
    }
}
$rexist = 0;
?>

<html>
<head>
    <style type="text/css">
    .myclass {
     font-size: 10pt; font-family:Arial, Helvetica, sans-serif;
    }
    </style>
    
    <script type="text/javascript">
document.onkeypress = function(e){
    e = e || event; e.returnValue = true;
    var t = e.target || e.srcElement, re = /^(inqty|outqty)(\d+)$/, f = arguments.callee, m, i;
    function next(){
        if(!f.els && (m = t.form) === document.forms.clttype){
            var ipts = m.getElementsByTagName('input'), els = []; i = ipts.length - 1;
            for (i; i > -1; --i){
                if(ipts[i].type && ipts[i].type.toLowerCase() === 'text'){
                    els.push(ipts[i]);
                }
            }
            f.els = els;
        }
        if(f.els){
            i = f.els.length - 1;
            for (i; i > -1; --i){
                if(f.els[i] === t && (m = f.els[i - 1])){
                    m.focus();
                }
            }
        }
    }
    if((m = re.exec(t.id)) && e.keyCode === 13){
        e.returnValue = false;
        t.form.elements['varqty' + m[2]].value = t.form.elements['inqty' + m[2]].value - t.form.elements['outqty' + m[2]].value;
    } else if (t.type && e.keyCode === 13 && t.type.toLowerCase() !== 'submit') {
        e.returnValue = false;
    }
    if(!e.returnValue){
        next();
        if(e.preventDefault){e.preventDefault();}
    }
    return e.returnValue;
}
</script>
</head>
<body>
<form action='frame.php' method="post" name="clttype">

<?php
    $rexist = 1;
    
    
    
    $query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
    $last_operation_name = "";
    $result = mysql_query($query);
    if($result)
        {
        $rexist = 1;
        echo "<table>";
        echo "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>OUTPUT <br/> QTY</th><th class='myclass'>VARIANCE Qty</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\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' /></td>";
            echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' ></td>";
            echo "\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" . $ctr . "' /></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' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";   
            echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
            echo "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty"  . $ctr . "' /></td>";
            echo "\n\t\t<td><input size='6' type='text' name='outqty[]'  id='outqty" . $ctr . "'  /></td>";
            echo "\n\t\t<td><input size='6' type='text' name='varqty[]' value=''  id='varqty" . $ctr . "' /></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>

I want to happen be in operation1 and operation 2 the input qty and output qty will automatically compute the sum and the result will appear in the total.
I don't know how thus the result should be appearing automatically in the total textfield. I mean is the sum of input qty of operation 1 will automatic appear in operation1_total and also with the output qty, same with the operation2.

I got this error:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\xampp\htdocs\sumtot.php on line 164

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\xampp\htdocs\sumtot.php on line 164
Kindly tell me what is missing or wrong.

Thank you
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Total Checkboxes on a Multipage Form saundap VB How-To 0 September 24th, 2009 07:02 PM
Compute sum(column name) statement in DTS Package praragon SQL Server DTS 1 March 27th, 2006 10:23 PM
Automatic Sum for Diff Objects in the same sheet sedolphi Excel VBA 0 May 21st, 2004 02:19 PM
generating automatic numbers laxmi_praveena Classic ASP Basics 1 April 5th, 2004 12:35 PM
INSERT With a Text field (C#) kwalda SQL Server 2000 1 January 10th, 2004 11:18 AM



All times are GMT -4. The time now is 08:21 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.