I am trying to get json Array from url in android using volley but it is showing following error
com.android.volley.ParseError: org.json.JSONException: Value of type java.lang.String cannot be converted to JSONArray
that means i am receiving html from url.
how can i receive data in json format from url so that i can parse using jsonObject or jsonArray in android
My android code is
RequestQueue queue = Volley.newRequestQueue(getContext()); JsonArrayRequest request = new JsonArrayRequest(Method.GET, URL,null, new Response.Listener<JSONArray>() { @Override public void onResponse(JSONArray response ) { Toast.makeText(getContext(), response, Toast.LENGTH_SHORT).show(); Log.i("My success",""+response.toString()); try { for (int i = 0; i <= response.length(); i++) { JSONObject silver_rate_values = response.getJSONObject(i); String Silver_Rate = silver_rate_values.getString("silver_rate"); Log.v("SilverRate", "silverRate value is" + Silver_Rate); } }catch (JSONException e) { e.printStackTrace(); Log.e("Silver rate", "Json parsing error: " + e.getMessage()); } } }, new Response.ErrorListener() { @Override public void onErrorResponse(VolleyError error) { Toast.makeText(getContext(), "my error :"+error, Toast.LENGTH_LONG).show(); Log.i("My error",""+error); } }){ }; My php code is
$sql = "SELECT * FROM `user_info` \n" . "ORDER BY `customer_info`.`updatedTime` DESC LIMIT 1"; $result = mysqli_query( $con,$sql ); if(! $result ) { die('Could not get data: ' . mysql_error()); } //print values to screen $data = array(); while ($row = mysqli_fetch_assoc($result)) { $a = $row['a']; $b = $row['b']; $c = $row['c']; $data[] = $row; } header('Content-type: application/json'); $json=json_encode(array("Values" => $data)); echo $json; ?> </body> <html> <head> <meta charset="UTF-8"> <title></title> </head> <body> {"Values":[{"a":"8888","b":"9999","c"7777"}]} </body> </html> If I remove header from php code then the output is {"Values":[{"a":"8888","b":"9999","c"7777"}]}
Then also I am getting same error from Android side
https://stackoverflow.com/questions/65930175/how-to-get-json-array-not-html-from-url-in-android January 28, 2021 at 10:24AM
没有评论:
发表评论