Dynamic form? how to do?

Question

I have the following question, I have one while in PHP, and in this while have a form and a button of Submit who sends this form, but as there are several records he repeats this form and the system detects only the first form on the list, the others he does not do the Submit, for example, I have 20 records, 20 are generated Forms, no matter how much I change the form nº 18, it will save the 01.

To be clear, each registration brings me a status of the product in a select, and I want to leave this choice option to the user, and when he chooses a status in that select (who is in the form), the system do the update at the bank.

this is the code while repeats how many results it finds:

<?php  
 while ($dados = $produtos->fetch_array()) {
 ?>
 <tbody> <tr>
    <td align="center"><?php echo $dados['id_oc']; ?></td>
    <td align="center"><?php echo date('d/m/Y', strtotime($dados['data']));  ?></td>
    <td align="center"><?php echo (number_format($dados['total'],0,",",".")); ?></td>
    <td align="center"><?php if(!empty($dados['faccao'])) echo $dados['faccao']; else     echo "-";  ?></td>
    <td align="center">
        <form action="" method="post" name="teste">
          <select name="status" id="status_">
          <option value="<?php echo $dados['status']; ?>"><?php echo $dados['status']; ?></option>
              <?php
              foreach ($arrEdital as $value => $name) {
                echo "<option value='{$name}'>{$name}</option>";
              }
              ?>
         </select>
         <td align="center"><input type="submit" name="status2" id="ok" value="ok" />    </td>
         </form>
    </td>    
  </tr></tbody>
<?php
} 
?>

the problem is that it repeats this 20 times (for example), but when I change the select of the number 18 (for example), it takes the values of the first form (number 1 in this example)

Answer 1

If you have 20 selects or inputs or whatever, you do not need 20 Forms. Create only 1 form and place the fields inside it. When the user submits the form, all values will be sent to the server.

Another thing, you’re repeating the name between the selects. You need a name different for each select or put it in array form adding [].

Your loop could look something like this.

<form action="" method="post">
    <?php while (...) { ?>
        <select name="teste[]">
            <option value="<?= $valorVindoBd ?>"><?= $valorVindoBd ?></option>
        </select>
    <?php } ?>
    <input typo"submit" value"ok" name="ok" />    
</form>

This way, when submitting the form, your server will receive something like this.

$_POST["teste"] = array(
   0 => "opção selecionada no primeiro select",
   2 => "opção selecionada no segundo select",
   ...
   20 => "opção selecionada no último select",
);

I believe that using a name different for each select would be the best choice to give a meaning to the field.

Answer 2

Denis, Oeslei is right. You don’t need (and shouldn’t) create 1 form for each product. What you should do is create 1 SELECT status for each product within the same form and use an array notation [] in the name or you can compose the field name with the product code, for example:

<select name="produto_<?php echo $dados[id_produto]; ?>">
...
</select>

For this just put the form tag before your product while:

    <?php
<form action="" method="post" name="teste">
     while ($dados = $produtos->fetch_array()) {
     ?>
     <tbody> <tr>
        <td align="center"><?php echo $dados['id_oc']; ?></td>
        <td align="center"><?php echo date('d/m/Y', strtotime($dados['data']));  ?></td>
        <td align="center"><?php echo (number_format($dados['total'],0,",",".")); ?></td>
        <td align="center"><?php if(!empty($dados['faccao'])) echo $dados['faccao']; else     echo "-";  ?></td>
        <td align="center">

              <select name="status[]" id="status_">
              <option value="<?php echo $dados['status']; ?>"><?php echo $dados['status']; ?></option>
                  <?php
                  foreach ($arrEdital as $value => $name) {
                    echo "<option value='{$name}'>{$name}</option>";
                  }
                  ?>
             </select>
             <td align="center"><input type="submit" name="status2" id="ok" value="ok" />    </td>

        </td>    
      </tr></tbody>
    <?php
    }
</form>
    ?>

I hope I’ve helped =)