Jump to content

Need help in saving data from textboxes inside foreach loop


Recommended Posts


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:

<form name="operator_report" action="" method="post" autocomplete="off">
include "connection.php";

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

//insert data to database
    $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)
                ('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)
                                ('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'];

                    //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">

I also attached my sample output screenshots and the database.

Here is the sample scenario.
Compound Type---Output---SC---SP---SH---

I  need to save data on op_reject like this:


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.


Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.