使用 PHP 从 MySQL 数据库中获取记录以填充下拉列表 [英] Fetching records from MySQL database with PHP to populate a drop down list
本文介绍了使用 PHP 从 MySQL 数据库中获取记录以填充下拉列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的代码有问题.我正在尝试从我的数据库中填充一个下拉列表,但该列表显示的是空白空间而不是数据库条目.如果有人能帮助我,我将不胜感激.
im having trouble with my code. I'm trying to populate a drop down list from my database but the list is showing empty space instead of database entries. I would be very grateful if anyone could help me.
<?php
include("db_config.php");
$sql="SELECT * FROM brojevi";
$result=mysqli_query($connection,$sql);
echo "<select name=\"id\" size=\"1\">";
echo "<option value=\"choose\">-choose-</option>";
while($row=mysqli_fetch_array($result)){
unset($id,$broj);
$id=$row['id'];
$broj=$row['brojevi'];
echo "<option value=\"$id\">$broj</option>";
}
echo "</select>";
?>
这是表格(这是一个简单的原因,我只是为了练习而做的)
Here is the table( its a simple one cause im just making this for practice )
CREATE TABLE `brojevi` (
`id` int(11) NOT NULL auto_increment,
`broj` int(11) NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO `brojevi` (`id`, `broj`) VALUES
(1, 1),
(2, 2);
推荐答案
你弄乱了单引号和双引号.试试这个:
You are messing up your single and double quotes. Try this:
<?php
include("db_config.php");
$sql="SELECT * FROM brojevi";
$result=mysqli_query($connection,$sql);
echo '<select name="dropdown" size="1">';
echo '<option value="choose">-choose-</option>';
while($row=mysqli_fetch_array($result)){
$id = $row['id'];
$broj = $row['brojevi'];
echo '<option value="' . $id . '">' . $broj . '</option>';
}
echo '</select>';
?>
在 echo 中使用 html 标签时,尝试对 echo 使用单引号,对值、id、classes 等 html 内容使用双引号.
When using html tags inside your echo, try to use single quotes for the echo and double quotes for html stuff like values,id's,classes etc.
这篇关于使用 PHP 从 MySQL 数据库中获取记录以填充下拉列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文