dongxing8766
2017-02-13 23:28 阅读 103

输出JSON数组追加附加元素PHP

I'm pretty sure I'm quite close so hopefully quick answer.

I'm able to generate this JSON:

apps: [
    {
        0: {
            PublisherCount: "7"
    },
        Id: "87",
        AppName: "Productivity, Focus, Habits & Life Success by Audiojoy",
        AppBundle: "productivitymind"
    }
]

But I'm trying to get to:

apps: [
    {
        Id: "87",
        AppName: "Productivity, Focus, Habits & Life Success by Audiojoy",
        AppBundle: "productivitymind",
        PublisherCount: "7"
    }
]

Here is my output loop (I think the issue is in the 5th row where I array_push the new value for PublisherCount. It creates an additional node instead of adding it to the end.

$temp_array = array();
$i = 0;
while ($row = mysqli_fetch_assoc($publisher_apps)) {
$temp_array[] = $row;
$temp_array[$i][] = fetch_all(get_publisher_count_by_app_id($row['Id']))[0];
$i++;
}

$publisher_apps = $temp_array;

$result = array("apps"=>$publisher_apps);

output_json($result);

Thanks.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    drazvzi741287 drazvzi741287 2017-02-13 23:49

    You have rows like this:

    ['Id' => "87",
     'AppName' => "Productivity, Focus, Habits & Life Success by Audiojoy",
     'AppBundle' => "productivitymind"]
    

    and fetch_all(get_publisher_count_by_app_id($row['Id']))[0] returns an array like this:

    ['PublisherCount' => 7]
    

    so when you append it with $temp_array[$i][], the entire array gets assigned to the 0 key of $temp_array[$i].

    There are various different ways you could get just the PublisherCount value. One way is to use array_merge to combine the result of get_publisher_count_by_app_id with $row, and then add the modified $row to your main array.

    while ($row = mysqli_fetch_assoc($publisher_apps)) {
        $count = fetch_all(get_publisher_count_by_app_id($row['Id']))[0];
        $temp_array[] = array_merge($row, $count);
    }
    

    If you do it this way, $i should become unneccessary.

    点赞 评论 复制链接分享
  • douying2243 douying2243 2017-02-13 23:33

    Change it to this:

    $temp_array = array();
    
    while ($row = mysqli_fetch_assoc($publisher_apps)) {
      $row['PublisherCount'] = fetch_all(get_publisher_count_by_app_id($row['Id']))[0]['Pub‌​lisherCount'];
      $temp_array[] = $row;
    }
    
    $publisher_apps = $temp_array;
    
    $result = array("apps"=>$publisher_apps);
    
    output_json($result);
    
    点赞 评论 复制链接分享

相关推荐