Advertisement
Guest User

PHP HELP

a guest
Dec 26th, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. <?php
  2. $servername = "";
  3. $username = "";
  4. $password = "";
  5. $dbname = "";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. // Check connection
  10. if ($conn->connect_error) {
  11.     die("Connection failed: " . $conn->connect_error);
  12. }
  13.  
  14. $sql = "SELECT * FROM temp ORDER BY id DESC LIMIT 1";
  15. $result = $conn->query($sql);
  16.  
  17. if ($result->num_rows > 0) {
  18.     // output data of each row
  19.     while($row = $result->fetch_assoc()) {
  20.         $watertemp = $row["WaterTempC"];
  21.         $ambienttemp = $row["AmbientTempC"];
  22.             $temperature = $row["PIBoxT"];
  23.     }
  24. } else {
  25.  
  26. }
  27. $conn->close();
  28.  
  29. header("Content-type: text/json");
  30. // The x value is the current JavaScript time, which is the Unix time multiplied
  31. // by 1000.
  32. $x = time() * 1000;
  33. // The y value is a random number
  34.  
  35.  
  36. // Create a PHP array and echo it as JSON
  37. $ret = array("Time:" .$x, "Temp:" .$watertemp);
  38. $ret2 = array("Time:" .$x, "Temp:" .$ambienttemp);
  39. $ret3 = array("Time:" .$x, "Temp:" .$PIBoxT);
  40. //echo "[ ";
  41. //echo str_replace('"', '', json_encode($ret));
  42. //echo ", ";
  43. //echo str_replace('"', '', json_encode($ret2));
  44. //echo "]";
  45.  
  46. //echo json_encode($ret);
  47.  
  48. echo $watertemp . "/";
  49.  
  50. echo $ambienttemp . "/";
  51.  
  52. echo $temperature . "/";
  53.  
  54. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement