如何在php中使用下拉列表框中的选定值显示db中的特定字段

Question

   <select id="qualification" class="form-control"> 
     <option selected="selected">SELECT</option> 
     <option value="pick"</option>
     <?php $sql = mysqli_query($con, "SELECT DISTINCT qualification From
     enquire"); 
      $row = mysqli_num_rows($sql); 
     while ($row = mysqli_fetch_array($sql))
     { echo "<option value='". $row['qualification'] ."'>".$row['qualification']."</option>" ; } ?>
    </select>

如何使用限定从数据库中检索表格式的字段？

Answer 1

       <?php 
        $sql="SELECT Option1, option2 FROM yourTable";
        $result = mysqli_query($YourDBconnection,$sql);
      ?>

像一样你的选择

<select>
<?php
while ($row = mysql_fetch_assoc($result)){
echo'<option>'.$row['option1'].'<option>';
}
?>
</select>

Answer 2

执行此操作

<select id="qualification" class="form-control"> 
     <option selected="selected">SELECT</option> 
     <option value="pick"</option>
     <?php $sql = mysqli_query($con, "SELECT DISTINCT qualification From
     enquire"); 
      //$row = mysqli_num_rows($sql); 
     while ($row = mysql_fetch_assoc($sql)))
     { ?>
<option value="<?php echo $row['qualification']; ?>"> <?php echo $row['qualification']; ?> </option> 
<?php } ?>
    </select>

您可能希望重新考虑您的代码，并使用预准备语句来避免SQL注入。下面的代码是预准备语句

<select id="qualification" class="form-control"> 
     <option selected="selected">SELECT</option> 
     <option value="pick"</option>
     <?php $sql =$con->prepare("SELECT DISTINCT qualification From
     enquire");
      $sql->execute(); 
      $result = $sql->get_result(); 
     while ($row = $result->fetch_assoc())
     { ?>
<option value="<?php echo $row['qualification']; ?>"> <?php echo $row['qualification']; ?> </option> 
<?php } ?>
    </select>