dongyue4964 2015-10-02 11:59
浏览 20
已采纳

将数据库中的两个值推送到一个数组

On line 6 I am pushing a value from the database to the array called $products. I would now like to give another value from the database ($row->image) to the same array which matches with $row->name.

Maybe it could make sense to use a two dimensional array but I don't know how to do this in this case.

$products = array();
foreach($_POST['selected_checkboxes'] as $value) {
    if($result = $db->query("SELECT * FROM produkte WHERE $value = 1")){
        while($row = $result->fetch_object()) {
            if (!in_array($row->name, $products)) {
                array_push($products, $row->name);
            }
        }
    }
    else {
        array_push($products, 'error');
    }
}

The result should show me the name and the image of both values which belong together.

  • 写回答

3条回答 默认 最新

  • dthp96899 2015-10-02 12:09
    关注

    You could do this, assuming you already have your $row->name and $row->image matching logic sorted:

    if (!in_array($row->name, $products)) {
       array_push( $products, array('name'=>$row->name, 'image'=>$row->image) );
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)