Hi all,

Here's my first post. I have a problem which I've worked on for a while now. I'm new to php, html, scripts, but I'm a very quick learner and have worked in IT for years, so hopefully someone can point me towards what I need to do/learn to sort this problem.

I've a really simple insert in my PHP:

mysql_query('INSERT INTO markers (date, time, name, address, lat, lng, type, type_image_url, debt, activity, text, notes, source)' .
    " VALUES ('$date','$time','$name', '$address', '$lat', '$long', '$type', 'http://www.phoenker.com/images/male2.png', '$debt', '$activity', '$text', '$notes','$source')");

that works fine. now I want to use a function to set the gps coordinates, which works fine. here is a piece of it:

// Try W3C Geolocation method (Preferred)
  if(navigator.geolocation) {
    browserSupportFlag = true;
    navigator.geolocation.getCurrentPosition(function(position) {
      initialLocation = new google.maps.LatLng(position.coords.latitude,position.coords.longitude);
      contentString = "Location found using W3C standard" + position.coords.latitude;
      var teddylat = position.coords.latitude;
    }, function() {

I know it works because if I put the position.coords.latitude into an alert, it displays fine.

So, my question/problem is, how do I take the value of 'position.coords.latitude' and use it in the insert whilst using just one php page. As a noob, I'm not sure how to make the variable global. See I know I can call a second php and $_GET; but I want to know how to do it within the same php page. I'd hope there was a way I can set the position.coords.latitude and position.coords.longitude into 'something' that I can refer to in the insert.

Do I need to learn ajax, parsing, err...?!?


Edited by teddy99: spelling

8 Years
Discussion Span
Last Post by pzuurveen

You google funtion is in javascript that runs in the brouwser,
all php is done and over (serverside) by that time.
so you have to call an external scipt or do a refrech with the the latlng as a hidden form element

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.