我一直在尝试使用MySQL数据库中的数据创建PHP下拉列表。
我在下面附上了我的代码,没有得到下载列表。有人能帮助吗
<?php
$conn = mysql_connect('localhost','root','');
mysql_select_db('qsearch',$conn);
$query = "select Category from information";
$result = mysqli_query($query);
echo '<select id="info" name="info">';
echo '<option value="">-select-</option>';
while ($row = mysqli_fetch_assoc($result)){
?>
<option value="<?php echo $row['Category']; ?>"><?php echo $row['Category']; ?> </option>
<?php
}
echo "</select>";
?>
因为一半的函数来自mysql
,另一半来自mysqli
$conn = mysql_connect('localhost','root','');
mysql_select_db('qsearch',$conn);
$query = "select Category from information";
$result = mysqli_query($query);
while ($row = mysqli_fetch_assoc($result)){
你需要仔细阅读文档第一
http://www.php.net/mysqli&http://www.php.net/mysqli_connect