HTML5 geolocation, pass lat/long to PHP variable when page load

Question

in this code i need to assign lat and long as a php variable .. pls help me

<!DOCTYPE html><html><body><p id="demo"></p><script>
    var x=document.getElementById("demo");
    function getLocation()
     {
    if (navigator.geolocation)
    {
    navigator.geolocation.getCurrentPosition(showPosition);
    }
    else{x.innerHTML="Geolocation is not supported by this browser.";}
    }
    function showPosition(position)
    {
    x.innerHTML="Latitude: " + position.coords.latitude + 
    "<br>Longitude: " + position.coords.longitude;  
    }
    getLocation()
    </script>

Possible duplicate of [How to pass JavaScript variables to PHP?](https://stackoverflow.com/questions/1917576/how-to-pass-javascript-variables-to-php) — MackProgramsAlot, Jun 23 '17 at 17:21
but I am new to this. I really couldn't find the solution yet — Adarsh v s, Jun 23 '17 at 17:46
then how can i store visitor's location in my db using html5 geolocation? — Adarsh v s, Jun 23 '17 at 18:37
ok i will code something up and post it below. Give me 10 minutes. — MackProgramsAlot, Jun 23 '17 at 18:41

score 1 · Accepted Answer · answered Jun 23 '17 at 18:54

1

This assumes that you have a 'users' table with long and lat columns.

somescript.php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$stmt = $conn->prepare("INSERT INTO users (long, lat) VALUES (:long, :lat)");
$stmt->bindParam(':long', $long);
$stmt->bindParam(':lat', $lat);
$long = $_REQUEST['long'];
$lat = $_REQUEST['lat'];
$stmt->execute();

Your javascript:

function getLocation()
{
    if (navigator.geolocation)
    {
        navigator.geolocation.getCurrentPosition(showPosition);
    }
}
function showPosition(position)
{
    var lat = position.coords.latitude;
    var long = position.coords.longitude;
    var xmlhttp = new XMLHttpRequest();
    xmlhttp.onreadystatechange = function () {
        if (this.readyState == 4 && this.status == 200) {
            alert("Success");
        }
    };
    xmlhttp.open("GET", "somescript.php?lat=" + lat + "&long=" + long, true);
    xmlhttp.send();
}
getLocation();

similarly you would do the same for an UPDATE statement.

answered Jun 23 '17 at 18:54

MackProgramsAlot

583
1
3
16

if my answer was helpful id appreciate you voting up or accepting the answer. – MackProgramsAlot Jun 23 '17 at 19:05
and no problem! – MackProgramsAlot Jun 23 '17 at 19:05
actually it doesnt store any value in my db – Adarsh v s Jun 23 '17 at 19:26
make sure the following are set correctly: servername, username, password, dbname – MackProgramsAlot Jun 23 '17 at 19:29
then alter the sql to match your table. For example, what's your table name, if it differs from users then you should change it – MackProgramsAlot Jun 23 '17 at 19:30
what are the table columns? – MackProgramsAlot Jun 23 '17 at 19:39
`long` varchar(75) NOT NULL, `lat` varchar(75) NOT NULL, `sl` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`sl`) – Adarsh v s Jun 23 '17 at 19:41
if u were to visit the url via the browser. that is: /somescript.php?lat=12.2&lng=56.8 what happens? – MackProgramsAlot Jun 23 '17 at 20:06
found the solution – Adarsh v s Jun 29 '17 at 07:45

HTML5 geolocation, pass lat/long to PHP variable when page load

1 Answers1