<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>
如何使用资格从数据库中检索表格格式?
<?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>
做这个
<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>