java - 无法从 JSONArray 获取 JSONObject

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 7 年前。

Improve this question

我的PHP:

 <?php

 $con=mysqli_connect("localhost","xxx","xxx","xxx");

 $result = mysqli_query($con, "SELECT username, x,y FROM user");

 $jsonData = array();
while($array = mysqli_fetch_assoc($result)){
$jsonData[] = $array;
}

echo json_encode($jsonData);


mysqli_close($con);
?>

我将数据提取到 JSONArray:[{"username":"one","x":"22.","y":"55"},{"username":"two","x":2,"y":5}]

Android 代码:

        //Connect to mysql.
        HttpClient httpClient = new DefaultHttpClient();
        HttpPost httpPost = new HttpPost("http:example.com/fetchCoordinates.php");

        //Getting response
        HttpResponse response = httpClient.execute(httpPost);
        String responseBody = EntityUtils.toString(response.getEntity());

        //Trying to get fetch from array.
        JSONArray array = new JSONArray(responseBody);
        JSONObject jsonObject = array.getJSONObject(0);
        double x = jsonObject.getDouble("x");

错误:

org.json.JSONArray cannot be converted to JSONObject

这不起作用。我被困住了。

Answer 1

要从数组创建 json 对象，该数组必须是关联的，以便您可以将代码更改为此来实现它。

  while($array = mysqli_fetch_assoc($result)){
       $jsonData[] = $array;
  }