<script>
$(document).ready(function(){
$(’#buttonx’).click(function(){
navigator.geolocation.getCurrentPosition(function(pos){
var latitude = pos.coords.latitude;
var longitude = pos.coords.longitude;
var longitude1 = longitude;
var latitude1 = latitude;
var username = $(’#username’).val();
var password = $(’#password’).val();
var reportdetail = $(’#reportdetail’).val();
// alert(latitude);
// alert (latitude);
$.ajax({
type:‘POST’,
url:’http://192.168.1.6/pls/locationpg.php‘,
data:‘latitude=’+latitude+’&clongitude=’+longitude+’&username1=’+username+’&password1=’+password+’&reportdetail1=’+reportdetail,
success:function(msg){
if(msg){
$("#location").html(msg);
alert(longitude);
alert(latitude);
}else{
$("#location").html(‘Not Available’);
}
var username = $(’#username’).val(’’);
var password = $(’#password’).val(’’);
var reportdetail = $(’#reportdetail’).val(’’);
}
}).error(function(){
$('#feedback1').text("");
}).complete(function(){
$('#feedback2').text("");
}).success(function(){
$('#feedback3').text("");
});
});
});
});
</script>
and my php here:
<?php
$con = new mysqli(“localhost”, “root”, “”, “pls”);
if ($con){
echo “connection successful”;
}else {
echo “connection isn’t successful”;
}
if (isset ($_POST[‘longitude’]) && isset($_POST[‘latitude’])){
$longitude = filter_input(INPUT_POST, ‘longitude’);
$latitude = filter_input(INPUT_POST, ‘latitude’);
$insert = mysqli_query($con, “INSERT INTO geolocation VALUES (’$latitude’, ‘$longitude’, ‘’)”);
if ($insert){
echo “data inserted successful”;
echo $lat.’<br>’.$long;
}else if (!$insert){
echo “data wasnt inserted successfully”;
}
}
?>