Advertisement
Guest User

Untitled

a guest
Jan 5th, 2017
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. var data1 = <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "root";
  6.  
  7. // Create connection
  8. $conn = new mysqli($servername, $username, $password);
  9.  
  10. mysqli_select_db($conn,"garden_data");
  11. $sql="SELECT * FROM daily_temp";
  12. $result = mysqli_query($conn,$sql);
  13.  
  14. $a = 0;
  15. echo "["
  16. while($row = mysqli_fetch_array($result)) {
  17. if ($a != 0) {echo ","; }
  18. echo "{x: " . $a . ",";
  19. echo "y:" . $row['temp'] . "}";
  20. $a = $a + 1;
  21. }
  22. echo "]";
  23.  
  24.  
  25. mysqli_close($conn);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement