Advertisement
Guest User

PHP to pull coordinates

a guest
Aug 2nd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $username = "root";
  3. $password = "";
  4. $host = "localhost";
  5. $database="leafletdb";
  6.  
  7. $server = mysqli_connect($host, $username, $password);
  8. $connection = mysqli_select_db($database, $server);
  9.  
  10. $myquery = "
  11. SELECT `latitude`, `longitude` FROM `gpsdata`
  12. WHERE `lat` <> 0
  13. ";
  14. $query = mysqli_query($myquery);
  15.  
  16. if ( ! $query ) {
  17. echo mysqli_error();
  18. die;
  19. }
  20.  
  21. $data = array();
  22.  
  23. echo "var points = [";
  24.  
  25. for ($x = 0; $x < mysqi_num_rows($query); $x++) {
  26. $data[] = mysqli_fetch_assoc($query);
  27. echo "[",$data[$x]['lat'],",",$data[$x]['long'],"]";
  28. if ($x <= (mysqli_num_rows($query)-2) ) {
  29. echo ",";
  30. }
  31. }
  32.  
  33. echo "];";
  34.  
  35. mysql_close($server);
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement