向数组中的每个元素添加数据->JSON - Add data to each element in array -> JSON

Add data to each element in array -> JSON

本文关键字：数据 JSON 添加元素数组 | 更新日期: 2023-09-27

我正在从MySQL数据库中提取数据到关联数组。

我需要向数组中的每个元素添加额外的数据行topicstring，然后转换为JSON。

但是由于某种原因，我只能让它将额外的行添加到数组中的第一个元素，或者作为数组中的新最后一个元素。

代码:

$sql_build_profile="SELECT SourceOperation, FC, Register, RegisterID FROM DeviceProfiles WHERE DeviceID = '".$q."' AND RegisterID IN (".$ParameterArray.") ORDER BY RegisterID ASC";
$result_build_profile = mysqli_query($con,$sql_build_profile);
$json_array = array();
//Time to build the output
while($row1 = mysqli_fetch_assoc($result_build_profile)) {
$topicString = $UniqueString."/".$row1['RegisterID'];
$json_array[] = $row1;
foreach ($result_build_profile as $key => $result_build_profile) {
    $result_build_profile[$key]['topic'] = $topicString;
}
echo json_encode($result_json);
}

这可能有帮助:

$sql_build_profile="SELECT SourceOperation, FC, Register, RegisterID FROM DeviceProfiles WHERE DeviceID = '".$q."' AND RegisterID IN (".$ParameterArray.") ORDER BY RegisterID ASC";
$result_build_profile = mysqli_query($con,$sql_build_profile);
$json_array = array();
//Time to build the output
while($row1 = mysqli_fetch_assoc($result_build_profile)) {
    $topicString = $UniqueString."/".$row1['RegisterID'];
    $row1['topic'] = $topicString;
    $json_array[] = $row1;
}
echo json_encode($json_array);