Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Define your host here.
- $servername = "sql111.epizy.com";
- //Define your database username here.
- $username = "epiz_21267382";
- //Define your database password here.
- $password = "*******";
- //Define your database name here.
- $dbname = "epiz_21267382_alidb";
- ?>
- <?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);
- ?>
- 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);
Add Comment
Please, Sign In to add comment