PHP - 将数据 $_POST 数组保存到数据库 mysql 中 - PHP - Save data $_POST array into database mysql

PHP - Save data $_POST array into database mysql

我正在尝试从多个单选按钮发送数据 name="answerswer<?php echo$data[id]?>" .有了这个$_POST[answer[]]我如何保存数据？

这是代码。谢谢。

`<form method="post" action="proses.php">`<tbody>
<?php
$no=1;
$getdata = mysql_query("SELECT * FROM pertanyaan where kategori='pekerjaan' order by kategori desc");
        while($data=mysql_fetch_array($getdata)){
        ?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $data[pertanyaan]?></td>
<td><input type="radio" name="answerswer<?php echo $data[id] ?>" value="ss"></td>
<td><input type="radio" name="answerswer<?php echo $data[id] ?>" value="s"></td>
<td><input type="radio" name="answerswer<?php echo $data[id] ?>" value="b"></td>
<td><input type="radio" name="answerswer<?php echo $data[id] ?>" value="ts"></td>
<td><input type="radio" name="answerswer<?php echo $data[id] ?>" value="sts"></td>
</tr>
</form>

您需要在无线电指挥棒的名称中放置方括号 []。

<form method="post" action="proses.php">`<tbody>
<?php
$no=1;
$getdata = mysql_query("SELECT * FROM pertanyaan where kategori='pekerjaan' order by kategori desc");
    while($data=mysql_fetch_array($getdata)){
    ?>
<tr>
<td><?php echo $no ?></td>
<td><?php echo $data[pertanyaan]?></td>
<td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="ss"></td>
<td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="s"></td>
<td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="b"></td>
<td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="ts"></td>
<td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="sts"></td>
</tr>
</form>

    <form method="post" action="proses.php">`<tbody>
    <?php
      $no=1;
      $getdata = mysql_query("SELECT * FROM pertanyaan where kategori='pekerjaan' order by kategori desc");
    while($data=mysql_fetch_array($getdata)){
    ?>
    <tr>
    <td><?php echo $no ?></td>
    <td><?php echo $data[pertanyaan]?></td>
    <td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="ss"></td>
   <td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="s"></td>
    <td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="b"></td>
    <td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="ts"></td>
    <td><input type="radio" name="answerswer[<?php echo $data[id] ?>]" value="sts"></td>
    </tr>
  </form>
   //process.php
    <?php 
     if(isset($_POST)) {
         $getRadio = $_POST['answer'];
            if(count($getRadio) > 0) {
             // While updating data
              foreach($getRadio as $key => $val) {
               $query = "Update  pertanyaan set kategori = $val  WHERE id = $key";
               mysql_query($query);
        }
       //Insert Data
       foreach($getRadio as $key => $val) {
         //$key Reference Id of Table
         // val get checked radio button value
         $query  = "insert into  TABLENAME values('NULL','$val','$key')"; 
         mysql_query($query);
      }
   }
 }?>