首页 > 解决方案 > 从数据库检索的每行数据的单选按钮

问题描述

<tbody>
    <?php
    $query = "SELECT sm01.SM01_01, sm01.SM01_03, sm13.SM13_02 = sm13.SM13_03 FROM "
    . "sm13 INNER JOIN sm01 on sm01.SM01_01 = sm13.SM13_03 WHERE sm13.SM13_02 = $id";
    $sql_run = mysqli_query($link, $query);
    $j = 0;
    $count = mysqli_num_rows($sql_run);
    if (mysqli_num_rows($sql_run) > 0) {
        while ($row = mysqli_fetch_array($sql_run)) {
    ?>
      <tr>
        <th scope="row"><?php echo $j = $j + 1; ?></th>
        <td class="text-left"><input type="hidden" class="form-control-plaintext" name="id_ahli[]" value="<?php echo $row['SM01_01']; ?>">
          <?php echo $row['SM01_03']; ?></td>
        <td><div class="form-check-inline">
            <input type="radio" checked="" name="status"id="radio1<?php echo $row['SM01_03']; ?>" class="form-check-input">
            <label class="form-check-label" for="radio1<?php echo $row['SM01_03']; ?>">Tidak</label>
          </div>
          <div class="form-check-inline">
            <input type="radio" name="status" id="radio2<?php echo $row['SM01_03']; ?>" class="form-check-input">
            <label class="form-check-label" for="radio2<?php echo $row['SM01_03']; ?>">Hadir</label>
          </div></td>
      </tr>
    <?php
        }
    }
    ?>
</tbody>

我成功检索了数据,但是我遇到了单选按钮的问题,我希望每行单选按钮都检查 Tidak 标签

问题的图像在这里

标签: phphtml

解决方案


在您当前的代码name中,单选按钮的属性是相同的,因此只有一个单选会被设置为选中。而是更改您的代码,如下所示:

<tr>
    //other html code  //added here name_rowno 
     <td><div class="form-check-inline">
            <input type="radio" checked="" name="status_<?php echo $row['SM01_03']; ?>"id="radio1<?php echo $row['SM01_03']; ?>" class="form-check-input">
            <label class="form-check-label" for="radio1<?php echo $row['SM01_03']; ?>">Tidak</label>
          </div>
          <div class="form-check-inline">
            <input type="radio" name="status_<?php echo $row['SM01_03']; ?>" id="radio2<?php echo $row['SM01_03']; ?>" class="form-check-input">
            <label class="form-check-label" for="radio2<?php echo $row['SM01_03']; ?>">Hadir</label>
          </div></td>
  </tr>

推荐阅读