网页的动态下拉列表不是从我的数据库填充的

kyxcudwk 于 2021-06-25 发布在 Mysql

关注(0)|答案(1)|浏览(263)

我不明白为什么动态下拉列表不能从我的数据库中填充：

<!doctype html>
<html>
<body>
<h2>Insert Album</h2>
<form action="insertalbum.php" method="POST">
Title: <input type="text" name="atitle" maxlength='50' required><br>
Band: <select name='bands'>
<?php
$conn = mysqli_connect("Server","database","password","username"); //i put in these placeholder for my actual credentials
// Check connection
if(mysqli_connect_errno()){
        echo nl2br("Failed to connect to MySQL: " . mysqli_connect_error() . "\n "); 
        }
   $query = "SELECT DISTINCT name FROM band";
   $result = mysqli_query($conn, $query);
    while ($row = mysqli_fetch_assoc($result)) {
                  unset($name);
        $name = $row['name']; 
                  echo '<option value="name"> $name </option>';

}
?> 
 </select>
<br>

Published Year: <input type="number" name="pyear" min='1900' max='2020' required><br>
Publisher: <input type="text" name="pname" maxlength='50' required><br>
Format:<select> <option value="record"> Record </option>
        <option value="cd"> CD </option>
        <option value="casette"> Casette </option>

</select> <br>
Price: <input type="number" name="price" min='0' max='9999.99'><br>
<input type="submit" value="Insert">
</form>
</body>
</html>

mysql php dynamic

来源：https://stackoverflow.com/questions/49907809/dynamic-dropdown-for-a-webpage-is-not-populating-from-my-database

1条答案

按热度按时间

kxe2p93d1#

这是一个例子：

<select id="employee">
<option value="" selected="selected">Select Employee Name</option>
<?php
/* connection */
$conn = mysqli_connect("Server","database","password","username");
/* query */
$sql = "SELECT id, employee_name, employee_salary, employee_age FROM employee LIMIT 10";
/* get data from db */
$resultset = mysqli_query($conn, $sql) or die("database error:". mysqli_error($conn));
/* build your dropdown*/
while( $rows = mysqli_fetch_assoc($resultset) ) {
?>
<option value="<?php echo $rows["id"]; ?>"><?php echo $rows["employee_name"]; ?></option>
<?php } ?>
</select>

赞(0）回复(0）举报 2021-06-26

我来回答

网页的动态下拉列表不是从我的数据库填充的

1条答案

相关问题

热门标签

最新问答