当页面从数据库加载时,将选项加载到HTML中的下拉列表中


load options to an drop down list in html from when the page loads from database

我想在html表单加载时加载下拉列表的选项。我已经知道如何做,当我选择第一个下拉和加载第二个。但是当页面加载时,怎么做呢?非常感谢您对此事的关照。

您可以尝试下面的操作从数据库中加载deopdownlist选项

<?php
 $con=mysqli_connect("localhost","user","password","db_name");
 if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 $result = mysqli_query($con,"SELECT * FROM table_name");
 echo '<select id="select_1">';
 while($row = mysqli_fetch_array($result)) {
    echo '<option value="'.$row['column_name'].'">'.$row['column_name'].'</option>';
 }
 echo '</select>';
 mysqli_close($con);
?>