JSON回复PHP在循环从MySQL - JSON reply with PHP in loop from MySQL

JSON reply with PHP in loop from MySQL

本文关键字：MySQL 循环回复 PHP JSON | 更新日期: 2023-09-26

尝试与一些外部API通信，但我得到的只是示例回复:

 {"SUCCESS":[{"Hello msg":"Successfull list","LIST":{"Group 1":{"GROUPNAME":"Group 1","Persons":{"1":{"ID":2588,"NAME":"John Doe"}}}}}],"apiversion":"0.1"}

当我回显它时，它是好的，但是这个数组对我来说有点混乱，特别是如何不获得[]，我从mysql中获得数组，并在"SUCCESS"answers"Hello msg"之间获得它们

这是我目前得到的最好的:

$someArray=array();
$result=mysqli_query($con, "SELECT * from tbl_Persons");
while ($row=mysqli_fetch_array($result)) {
    array_push($someArray,[
                'ID'=>$row['id'],
                'NAME'=>$row['name']
]);}

$response=array();
$response['SUCCESS']=array();
$resposne['SUCCESS']=array('Hello msg'=>'Successfull list');
$response['SUCCESS']['List']['Group 1']=array('GROUPNAME'=>'Group 1');
$response['SUCCESS']['List']['Group 1']['Persons']=$someArray;
echo json_encode($response);

创建一个计数器变量，并将其用作数组中的字符串键:

$someArray=array();
$result=mysqli_query($con, "SELECT * from tbl_Persons");
$i=1;
while ($row=mysqli_fetch_array($result)) {
    $someArray[(string)$i++]=['ID'=>$row['id'],'NAME'=>$row['name']];
}