I have this json
in my free host : http://alibhm.epizy.com/fetch_turbine2.php
As you seen fetching work correctly if run this in browser and fetch two parameter . But when put this url in my android app (with volley) don't fetch anything . In previous when I use this json in my localhost(xampp) everything work correctly but when going to free host this problem appeared
dbconfig.php
<?php
//Define your host here.
$servername = "xxx";
//Define your database username here.
$username = "xxx";
//Define your database password here.
$password = "*******";
//Define your database name here.
$dbname = "xxx";
?>
fetch_turbine2.php
<?php
include 'dbconfig.php';
$con = mysqli_connect($servername,$username,$password,$dbname);
//creating a query
$stmt = $con->prepare("SELECT POWER , ONE_THRUST_BEARING_METAL_TEMP
FROM turbine_table ORDER BY id DESC LIMIT 1;");
//executing the query
$stmt->execute();
//binding results to the query
$stmt->bind_result($t1,$t2);
$boiler = array();
//traversing through all the result
while($stmt->fetch()){
$temp = array();
$temp['t1'] = $t1;
$temp['t2'] = $t2;
array_push($boiler, $temp);
}
//displaying the result in json format
echo json_encode($boiler);
?>
java
StringRequest stringRequest1=new StringRequest(Request.Method.GET,"http://alibhm.epizy.com/fetch_turbine2.php",
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
try {
JSONArray array=new JSONArray(response);
for (int i=0; i < array.length(); i++) {
JSONObject product=array.getJSONObject(i);
String b1=product.getString("t1");
String b2=product.getString("t2");
final TextView a1=findViewById(R.id.pf1);
final TextView a2=findViewById(R.id.pf2);
a1.setText(b1);
a2.setText(b2);
}
} catch (JSONException e) {
e.printStackTrace();
}
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
}
});
Volley.newRequestQueue(this).add(stringRequest1);
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…