使用PHP下拉菜单调用函数

Question

我有这个代码从index.php。我的数据库连接设置在index.php &SQL查询也可以。

<?php
$connect = new PDO('mysql:host=localhost;dbname=test', 'root', '');
?>
<?php
include('function.php');
?>
<form class="form-horizontal" name="myform" action="index.php" method="POST">
<div class="form-group">
<label class="col-lg-2 control-label">Institute</label>
<div class="col-lg-6">
<select class="form-control" name="institute"  id="institute">
<option class="col-lg-6" value="" selected="selected" >- Select Institute -</option>
<?php 
echo fill_institute_list($connect);   
?>
</select>

</div>
</div>
</form>

---

然后调用function.php

function fill_institute_list($connect)
{
$query = "
SELECT * FROM cadre_institute
ORDER BY institute ASC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output = '';
foreach($result as $row)
{
$output .= '<option value="'.$row["id"].'">'.$row["institute"].'</option>';
}
return $output;
}

---

然后在浏览器中不显示后下拉字段..

Answer 1

try change these

$output .= '<option value="'.$row["id"].'">'.$row["institute"].'</option>';

$output .= '<option value="'.$row[id].'">'.$row[institute].'</option>';