我正试图根据从数据库中获得的数据创建一个dropdownlist,但无法显示它们。有人能帮我一把吗?
include '../opdrachten/connectionPDO.php';
function Select()
{
$query =$db->prepare("SELECT naam FROM opdracht4");
$query->execute();
foreach ($query as $row)
{
echo '<option value="'.$row['naam'].'">"'.$row['naam'].'"</option>';
}
}
<select name="projectleider">
<?php Select(); ?>
</select>
将$db
传递到函数中以使其进入作用域。
include '../opdrachten/connectionPDO.php';
function Select($db)
{
$query =$db->prepare("SELECT naam FROM opdracht4");
$query->execute();
foreach ($query as $row)
{
echo '<option value="'.$row['naam'].'">"'.$row['naam'].'"</option>';
}
}
<select name="projectleider">
<?php Select(); ?>
</select>
您应该返回函数中的值。试试这个,
function Select()
{
$query =$db->prepare("SELECT naam FROM opdracht4");
$query->execute();
$str = '<option value="">Select anyone</option>';
foreach ($query as $row)
{
$str.= '<option value="'.$row['naam'].'">"'.$row['naam'].'"</option>';
}
return $str;
}
呼叫时尝试此操作,
<select name="projectleider">
<?php echo Select(); ?>
</select>