dongxing8766
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);
    点赞 评论 复制链接分享
提交

相关推荐