php - 在选择标签中选择的SET

Question

<select class="form-control" name="Church" id="Church">
  <option>Church List</option>
    <?php 
         $select_church = mysql_query("SELECT * FROM tblchurchs");
         while($get_detail = mysql_fetch_array($select_church)){
          echo'<option value="'.$get_detail['AChurchID'].'">'.$get_detail['ChurchName']." - ".$get_detail['Address'].'</option>';
        }
    ?>
</select>

这是Edit.php

这是该代码的结果 但我想要的是。从数据库获取数据后。它会根据数据库数据自动选择该选项的值。

Answer 1

假设从tblchurchs返回的查询结果包含一个字段Selected，该字段设置为1或0 。如果它设置为 1，那么您必须在下拉列表中选择该选项，如果它设置为 0，则不会选择它。

<select class="form-control" name="Church" id="Church">
  <option>Church List</option>
    <?php 
         $select_church = mysql_query("SELECT * FROM tblchurchs");
         while($get_detail = mysql_fetch_array($select_church)){
          echo'<option value="'.$get_detail['AChurchID'].'"';
          if($get_detail['Selected'] == 1)
            {
                echo ' selected="selected"';
            }
          echo '>'.$get_detail['ChurchName']." - ".$get_detail['Address'].'</option>';
        }
    ?>
</select>