optgroup php,PHP：使用optgroup进行动态下拉

我正在开发一个下拉菜单,该菜单使用

HTML optgroups来处理员工所属的组名.这是

MySQL查询和输出：

mysql> SELECT employees.emp_id,employees.empname,employees.grp_id,groups.groupname FROM employees left join groups on employees.grp_id = groups.grp_id order by groupname asc;

+--------+------------+--------+-----------+

| emp_id | empname | grp_id | groupname |

+--------+------------+--------+-----------+

| 20 | Employee 2 | 13 | Group 1 |

| 19 | Employee 1 | 13 | Group 1 |

| 21 | Employee 3 | 14 | Group 2 |

+--------+------------+--------+-----------+

3 rows in set (0.00 sec)

唯一的问题是,我正在努力弄清楚如何让optgroup正常工作.我已经尝试了无数次,而且它真的开始让我感到沮丧.以下几乎是我希望输出为(示例)：

Employee 2

Employee 1

Employee 3

基本上,optgroup需要是“groupname”,选项“name”应该是“emp_id”,动作“option”(下拉项)是“empname”.

我希望这是可以做到的,但实际上并不确定.这是我的功能,但它不能很好地工作：

function getDynGrpList() {

global $db;

// $query = "SELECT * FROM employees ORDER BY grp_id desc;";

$query = "SELECT employees.emp_id,employees.empname,employees.grp_id,groups.groupname FROM employees left join groups on employees.grp_id = groups.grp_id order by groupname asc;";

$employees = $db->GetAll($query);

$groups = array();

while ($qa = $employees->GetRows()) {

$groups[$qa['groupname']][$qa['grp_id']] = $qa['empname'];

}

foreach ($groups as $label => $opt) { ?>

foreach ($groups[$label] as $id => $name) { ?>

getDynGrpList功能截至美国中部时间凌晨3:15(2/27)：

function getDynGrpList() {

global $db;

// $query = "SELECT * FROM employees ORDER BY grp_id desc;";

$query = "SELECT employees.emp_id,employees.empname,employees.grp_id,groups.groupname FROM employees left join groups on employees.grp_id = groups.grp_id order by groupname asc;";

$employees = $db->GetAll($query);

$groups = array();

while ($qa = $employees->GetRows()) {

$groups[$qa['groupname']][$qa['emp_id']] = $qa['empname'];

}

var_export($groups);

foreach($groups as $label => $opt): ?>

<?php foreach ($opt as $id => $name): ?>

}

最终解决方案(在Felix Kling的帮助下)

function getDynGrpList() {

global $db;

$query = "SELECT employees.emp_id,employees.empname,employees.grp_id,groups.groupname FROM employees left join groups on employees.grp_id = groups.grp_id order by groupname asc;";

$employees = $db->GetAll($query);

$groups = array();

foreach ($employees as $employee) {

$groups[$employee['groupname']][$employee['emp_id']] = $employee['empname'];

}

foreach($groups as $label => $opt): ?>

<?php foreach ($opt as $id => $name): ?>

}