从数组中的数据库获取多行

Jakob 发表于 Dev

雅各布

使用下面的代码，我得到类别的ID和该类别中的产品名称。将显示类别ID，并在其下显示带有该类别产品名称的select。现在看起来像这样：

<label>37</label> <!--category id-->
<select>
<option>product one</option>
<option>product two</option>
</select>

但是我需要它来显示类别名称和选项值产品ID。像这样：

<label>category name</label>
<select>
<option value="1">product one</option>
<option value="2">product two</option>
</select>

如何在下面的代码中实现？

    $categories = array();
    $sql= "
SELECT a.id
     , a.name
     , a.active
     , b.id product_id
     , b.name product_name
     , b.flag_active
     , c.product_id
     , c.group_id 
  FROM products_groupnames a 
  JOIN products_group c 
    ON a.id = c.group_id 
  JOIN products_name b 
    ON b.id = c.product_id
 WHERE a.active=1 
   AND b.flag_active = 1
";
    $result = $mysqli->query($sql);
    echo "<h4>Select products by groups</h4>";
    while($row = $result->fetch_assoc()) {
        $categories[$row['id']][] = $row['product_name'];
    }

    foreach($categories as $key => $category){
        echo '<label>'.$key.'</label><br/>';
        echo '<select>';
        foreach($category as $item){
            echo "<option>".$item."</option>";
        }
        echo "</select><br/>";
    }

巴尔玛

使您的$categories数组二维：

while ($row = $result->fetch_assoc()) {
    $cat = $row['id'];
    if (isset($categories[$cat])) {
        $categories[$cat]['products'][] = $row;
    } else {
        $categories[$cat] = array('name' => $row['name'], products => array($row));
    }
}

然后可以使用嵌套循环显示它：

foreach ($categories as $category) {
    echo '<label>'.$category['name'].'</label>';
    echo '<select>';
    foreach ($category['products'] as $prod) {
        echo '<option value="'.$prod['product_id'].'">'.$prod['product_name'].'</option>';
    }
    echo '</select><br/>';
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。