Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require 'connect-mysql.php';
- $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"}]';
- $array = json_decode($json); // decode json
- $size = count($array);
- for ($x = 0; $x <= $size - 1; $x++)
- {
- $run = $array[$x]->run_id;
- $timeStamp = $array[$x]->timeS;
- $lng = $array[$x]->lng;
- $lat = $array[$x]->lat;
- //echo $array[$x]->exercise_name;
- $mysql_qry = "INSERT INTO run_gps (run_id, time, decimal_degrees_lng, decimal_degrees_lat) VALUES ('$run', '$timeStamp', '$lng', '$lat');";
- $result = mysqli_query($dbcon ,$mysql_qry);
- echo $mysql_qry;
- }
- ?>
Add Comment
Please, Sign In to add comment