我在用正确的数组值填充我的下拉框时遇到了问题,这导致了另一个问题:用适当的选定父值的子项动态填充第二个下拉框。
我有一个函数文件执行此操作:
$getDisplays = "
SELECT *
FROM locations l
inner join displays d
ON d.location_id = l.id;";
$displayResult = $mysqlConn->query($getDisplays);
$displayNames = array();
foreach($displayResult as $subArray) {
if(!array_key_exists($subArray['location_name'], $displayNames)) {
$displayNames[$subArray['location_name']] = array();
}
$displayNames[$subArray['location_name']][] = $subArray['display_name'];
}在我的html文件中,我这样做:
<label for="plantSelect">Select A Location</label>
<select class="form-control" id="plantSelect">
<?php foreach($displayNames as $displayName):?>
<option><?php echo key($displayName)?></option>
<?php endforeach;?>
</select>第一个下拉列表包含正确的元素数量,但它们都只有一个零。
这是转储时的数组:
Array
(
[Office 1] => Array
(
[0] => lobby
[1] => break room
)
[Office 2] => Array
(
[0] => lobby
[1] => break room
)
[Office 3] => Array
(
[0] => Main Conference Room
[1] => Common Area
)
[Office 4] => Array
(
[0] => Break Room
[1] => Lobby
[2] => Line 2
)
[Office 5] => Array
(
[0] => Break Room
[1] => Lobby
[2] => Line 1
)
)所以我的第一个dropdown应该是Office1到Office5,当被选中时,第二个dropdown应该填充子元素。
任何帮助我们都将不胜感激
https://stackoverflow.com/questions/51389751
复制相似问题