我有列表的列表:id和name.我想将它们显示在下拉菜单中.它们存储在以下$categoriesArray中:
array (size=6)
0 =>
array (size=2)
'id' => string '1' (length=1)
'name' => string 'Name 1' (length=12)
1 =>
array (size=2)
'id' => string '2' (length=1)
'name' => string 'Name 2' (length=14)
2 =>
array (size=2)
'id' => string '3' (length=1)
'name' => string 'Name 3' (length=10)
3 =>
array (size=2)
'id' => string '4' (length=1)
'name' => string 'Name 4' (length=14)
4 =>
array (size=2)
'id' => string '5' (length=1)
'name' => string 'Name 5' (length=20)
5 =>
array (size=2)
'id' => string '6' (length=1)
'name' => string 'Name 6' (length=14)
我想显示带有选项值的下拉列表ID和选项名称.
我尝试过以下方式:
$sql = "SELECT * FROM categories";
$result = $conn->query($sql);
$categoriesArray = array();
if ($result->num_rows > 0) {
echo "";
// output data of each row
while($row = $result->fetch_assoc()) {
array_push($categoriesArray, $row);
echo "$categoriesArray[0]['name']";
}
echo "";
}
但不知道如何打印所有元素.有任何想法吗 ?
解决方法:
您需要正确连接并相应地使用id和name.
echo "$categoriesArray[0]['name']";
应该改为
$i=0;
while($row = $result->fetch_assoc()) {
echo "".$row[i]['name']."";
i++; // traverse next array
}
标签:php,mysql,sql,html,dropdown
来源: https://codeday.me/bug/20190527/1163230.html