Need help in saving data from textboxes inside foreach loop

newphpcoder · July 16, 2013

Hi,

It's my first time to used foreach loop to display data from database and also used foreach loop to display textboxes

Now, I felt difficulties in saving data from the textboxes displayed by foreach.

Here is my code:

<html>
<head>
</head>
<body>
<form name="operator_report" action="" method="post" autocomplete="off">
<?php
ob_start();
include "connection.php";

$save = isset($_POST['save']);

//insert data to database
if($save)
{
    $compound_type     = $_POST['compound_type'];
    $op_output         = $_POST['output'];   
    $c_output         = $_POST['output'];  
    $reject_type[]       = $_POST['reject_type'];
    $reject[]            = $_POST['reject'];  
    
    
    for($s = 0; $s < count($compound_type) ; $s++)
    {  
            //---save operators output to op_output, in this part i don't have problem in saving the data saved correctly
            if ($op_output[$s] !="")
            {
                $sql = "INSERT INTO op_output
                (op_number, process_id, shift_id, shift_date, shift_type, compound_type, compound_output)
                VALUES
                ('001', '4', '1','2013-07-16', '1', '$compound_type[$s]', '$op_output[$s]')";
               $result = mysql_query($sql, $con);
            }
 
 
            //---this part I need help in saving reject.
            //---I guess i have the problem here in looping ...
            //---this code did not work..
            for($i = 0; $i < count($reject_type[$s]) ; $i++)
            {
               
             if($reject[$i] != "")
                  {
                       $sql_re = "INSERT INTO op_reject
                                (op_number, compound_type, reject_type, reject)
                                VALUES
                                ('001','$compound_type[$s]', '$reject_type[$i]', '$reject[$i]')";
                                $result_re = mysql_query($sql_re, $con);
                  }     
            }  
   }
}

$id = 'Final Mix';
if($id == 'Final Mix')
{  
            echo "<fieldset>";
            echo "<legend><H1> Operator's Output and Reject</H1></legend>";

            echo "<table>";
            echo "<tr>";
            echo "<th>Compound</th>";
            echo "<th>Output</th>";
//query to select reject acronym  
$sql = "select r.reject_acro, r.reject_id from process_list AS p LEFT JOIN reject_list AS r ON
p.reject_id = r.reject_process_id
 where p.process_name LIKE '" .$id. "%'";
 $rsd = mysql_query($sql);
        while($rs = mysql_fetch_assoc($rsd)) {
            $reject[] = $rs['reject_acro'];
            $reject_id[] = $rs['reject_id'];
        
        }   

            if(empty($reject))
            {
                echo"";
            }
            else
            {   
                    //display reject acronym as header               
                    foreach ($reject as $reject)
                    {   
                      echo "<th style='border:none;'><input type='text' name='reject_type[]' id='reject_type' value='$reject' style='border:none; font-weight: bold; ' size='5'></th>";
                    }
             
            echo "</tr>";  
            }
            
            //query select compound_type
            $sql_comp = "SELECT compound_id, compound_type FROM compound_list ORDER BY compound_type ASC";
            $res = mysql_query($sql_comp);
            echo "<tr>";
            while($comp = mysql_fetch_assoc($res)){
                $compound_type = $comp['compound_type'];
                
                //---display compound_type
                echo "<td style='border:none;'><input type='text' name='compound_type[]' id='compound_type' value='$compound_type' style='border:none;' size='10'readonly='readonly'></td>";
                //---input box for output
                echo "<td style='border:none;'><input type='text' name='output[]' id='output' value='' size='7'></td>";
                
                //----i used foreach to loop textbox in every reject acronym.
                foreach($reject_id AS $reject)
                {
                echo "<td style='border:none;'><input type='text' name='reject[]' id='reject' value='' size='7'></td>";   
                }
                
                echo "</tr>";
          }  
            echo "</table>";
            echo "</fieldset>";

 }
?>
<input type="submit" name="save" id="save" value="Save">
</form>
</body>
</html>

I also attached my sample output screenshots and the database.

Here is the sample scenario.
Compound Type---Output---SC---SP---SH---
P28--------------10-------------1-----2
P32--------------20--------5---------------
P32NW--------------------------3----------

I need to save data on op_reject like this:

op_number---compound_type----reject_type---reject
001----------P28---------------SP------------1
001----------P28---------------SH------------2
001----------P32---------------SC------------5
001----------P32NW------------SP------------3

Sad to say in my code in saving using forloop it did not work.

I post it because i am hoping somebody can help me, but I also tried my best to fixed this.

Any help is highly appreciated.

Thank you so much.

sample.zip

Yohanne · July 16, 2013

check your loop. and try to get out the "$reject_type" in the loop under "$compound_type".

for($compound_type)
{
 if(..)
    {
      true;
    }
    else
    {
      false;
    }
}
for($reject_typ)
{
 if(..)
    {
      true;
    }
   else
   {
    false;
   }
}

Sign In

Need help in saving data from textboxes inside foreach loop

Recommended Posts

newphpcoder

Link to comment

Share on other sites

Yohanne

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information