www.webdeveloper.com
Results 1 to 1 of 1

Thread: Need help in saving data from textboxes inside foreach loop

Threaded View

  1. #1
    Join Date
    Oct 2011
    Posts
    350

    Need help in saving data from textboxes inside foreach loop

    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:

    PHP 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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles