Advertisement
Guest User

Untitled

a guest
Mar 16th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. <?php
  2. header('Content-type: application/json');
  3. $servername = "192.168.1.3";
  4. $username = "userName";
  5. $password = "password";
  6. $dbname = "arduinoSensorData";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10. // Check connection
  11. if ($conn->connect_error) {
  12. die("Connection failed: " . $conn->connect_error);
  13. }
  14. $sql = "SELECT * FROM sensorLog ORDER BY timeStamp DESC LIMIT 1";
  15.  
  16. $result = $conn->query($sql);
  17.  
  18. $flush = "FLUSH HOSTS";
  19. query($flush);
  20.  
  21. named_array = $result->fetch_assoc();
  22. echo json_encode($named_array);
  23. $conn->close();
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement