我正在尝试从数据库中检索数据并从中填充一个列表，我的代码中似乎没有错误，并且列表仍然没有填充，我的代码
<?php
$hostname = "localhost";
$username = "username";
$password = "password";
$dbase = "db";
$link = @ mysql_connect($hostname, $username, $password);
$db_selected = @ mysql_select_db($dbase);
?>
<?php
include("scripts/dbconnect.php");
$query="select class from school";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
echo '<option value="'.$row['class'].'">'.$row['class'].'</option>';
}
?>
非常感谢任何帮助，谢谢
选项必须用 select 标签包装：
echo "<select name='class'>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
echo '<option value="'.$row['class'].'">'.$row['class'].'</option>';
}
echo "</select>";
此外，还要：
if (!$link) {
die('Could not connect: ' . mysql_error());
break;
}
查看 mysql 连接是否有任何错误。
您需要回显select元素。
<?php
include("scripts/dbconnect.php");
$query="select class from school";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
echo "<select>"
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
echo '<option value="'.$row['class'].'">'.$row['class'].'</option>';
}
echo "</select>"
?>