How to get the value in javascript into php to store in SQL?

Question

<script>
var x = document.getElementById("latitude");
var y = document.getElementById("longitude");
function getLocation() 
{
    if (navigator.geolocation) {
        navigator.geolocation.getCurrentPosition(showPosition);
        } else { 
        x.innerHTML = "Geolocation is not supported by this browser.";
        y.innerHTML = "Geolocation is not supported by this browser.";
        }
}

function showPosition(position) 
{
    x.innerHTML = "Latitude: " + position.coords.latitude;
    y.innerHTML = "Longitude: " + position.coords.longitude;
}

I need to store the X and Y value in variable in the data in SQL database and also display inside the php.

AJAX request or a simple hidden html element submitted through a form either through a get or a post method. Moreover, remember to sanitize that value before querying it inside your database. — briosheje, Jul 13 '15 at 07:55
can plz say how to do hidden html element for this@briosheje — Vignesh Sivakumar, Jul 13 '15 at 07:57
@SparkyBuddy: Show us the post and get attempts you did, I recommend you to include the relevant javascript part relative to that and, if possible, even the relevant php part. — briosheje, Jul 13 '15 at 08:02

Anna Gabrielyan · Answer 1 · 2015-07-13T08:06:43.903

1

Send an Ajax request to your php file.

var x = document.getElementById("latitude");
var y = document.getElementById("longitude");
jQuery.ajax({
        url:  "path/to/file/script.php",
        type:'POST',
        data:{
            lat:x,
            lng:y
        },
        success:function(data){

        },
        error: function(err){
            jQuery('.errorText').fadeIn();
        }
    });

Then handle values in php with $_POST['lat'] and $_POST['lng'], and query your php script to insert data to db , with mysql or mysqli.

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO locations(lat, lng)
VALUES (".$_POST['lat'].", ".$_POST['lng'].")";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

edited Jul 13 '15 at 08:06

answered Jul 13 '15 at 07:58

Anna Gabrielyan

2,120
3
28
48

url: "path/to/file/script.php", – Vignesh Sivakumar Jul 13 '15 at 08:03
this is a path to your php file, where do you save your php file. If it is in tha same directory as your jquery file, then just write a "script.php", if no, eg. it is located in /php/scripts.php u need to write that url – Anna Gabrielyan Jul 13 '15 at 08:05
U can do it separatly or in php, whatever u want, if you will add it separatly, u need to include the script into your html head or in php file. – Anna Gabrielyan Jul 13 '15 at 08:08
my doubt is were i need to put the this jQuery.ajax({ ... code – Vignesh Sivakumar Jul 13 '15 at 08:29
i want to add the Jquery code with PHP tag or inside the the script tag – Vignesh Sivakumar Jul 13 '15 at 08:34
no matter where you will add it, if u want to add it to php file, go ahead, the only thing you need to do right, is that you should give a path to your php file, jquery ajax should know where exactly send the request – Anna Gabrielyan Jul 13 '15 at 08:59

score 0 · Answer 2 · edited May 23 '17 at 12:06

0

Well, JavaScript lives in the browser of the user, and PHP/SQL on the backend (in your control I presume).

This means you need to somehow submit those values to the backend. Three most common ways of doing so:

Via an API (i.e. REST API) using AJAX (example)
Via a WebSocket connection (discussion on how to do that in PHP)
By submitting a form (PHP manual for handling a form)

Then, handle such a request in PHP code and store the values in the database.

edited May 23 '17 at 12:06

Community

1
1

answered Jul 13 '15 at 07:55

kamituel

34,606
6
81
98

@Daan - Actually the first bullet is an AJAX, I just updated an answer to make it clear – kamituel Jul 13 '15 at 07:58

Riken Shah · Answer 3 · 2015-07-13T10:37:07.563

You can use ajax to pass the value and insert in the database. If you don't want to use ajax then you can store the value of latitude and longitude in the hidden type using the javascript. and then onsubmit pass the value of the hidden type and insert the value in the database.

var latitude = document.getElementById("latitude").value;
var longitude = document.getElementById("longitude").value;
var datastring = 'latitude='+latitude+'&longitude='+longitude ; // get data in the form manual 
jQuery.ajax({
            type: "POST", // type
            url:"ajax.php", // request file the 'check_email.php'
            data: datastring, // post the data
            async: false,
            success: function(responseText) { // get the response

            } // end success
    }).responseText; // ajax end

In the ajax file you can get the value of the latitude and longitude by $_POST['latitude'] and $_POST['longitude'] and then use that value to insert it into the database.

You have to make a new file with the name ajax.php and then make a database call in that file and get the value which you want to store in the database. — Riken Shah, Jul 13 '15 at 11:11

How to get the value in javascript into php to store in SQL?

3 Answers3