Guest User

Untitled

a guest
Mar 20th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. <?php
  2.  
  3. require 'connect-mysql.php';
  4.  
  5. $json = '[{"run_id":"1","timeS":"00:00:00","lng":"53.408709","lat":"-2.996161"},{"run_id":"1","timeS":"00:00:00","lng":"53.408709","lat":"-2.996161"},{"run_id":"1","timeS":"00:00:00","lng":"53.408709","lat":"-2.996161"},{"run_id":"1","timeS":"00:00:00","lng":"53.408709","lat":"-2.996161"}]';
  6.  
  7. $array = json_decode($json); // decode json
  8.  
  9. $size = count($array);
  10.  
  11. for ($x = 0; $x <= $size - 1; $x++)
  12. {
  13. $run = $array[$x]->run_id;
  14. $timeStamp = $array[$x]->timeS;
  15. $lng = $array[$x]->lng;
  16. $lat = $array[$x]->lat;
  17.  
  18. //echo $array[$x]->exercise_name;
  19. $mysql_qry = "INSERT INTO run_gps (run_id, time, decimal_degrees_lng, decimal_degrees_lat) VALUES ('$run', '$timeStamp', '$lng', '$lat');";
  20. $result = mysqli_query($dbcon ,$mysql_qry);
  21. echo $mysql_qry;
  22. }
  23. ?>
Add Comment
Please, Sign In to add comment