After ajax action, data is not saved in mysql database

Question

I am capturing latitude and longitude through the Geolocation plugin of Cordova, and after that I store it in two variables and then, through an ajax request, I transfer these values to a PHP script where I am saving the data in a table called map. The problem is that it executes ajax code, returns success information, nothing else in the database is saved... I can’t find the error.

PHP:

if($_GET['acao']=='btnfinaliza'){

$latitude = $_GET['tlatit'];
$longitude = $_GET['tlongt'];

$SQL = "INSERT INTO mapa (lat, lng) VALUES ('$tlati','$tlong')";

$re = mysql_query($SQL, $serve);
}

Ajax:

$('#btn_finaliza').on('click', function(){

        var Cap = function(position){
            var coord = position.coords;
            var tlatit = position.coords.latitude;
            var tlongt = position.coords.longitude;
            $tlati = $('tlatit');
            $tlong = $('tlongt');
                    $.ajax({
                            type: "get",
                            url: $server+"/conecta.php",
                            data: "latitude="+$tlati+"&longitude="+$tlong+"&acao=btn_finaliza",
                            success: function(data) {
                                intel.xdk.notification.alert('Problema cadastrado', '', 'ok'); 
                            }
                        });

        }

        });

Answer 1

You should take php by the same names you sent by js, $_GET['latitude'] and $_GET['longitude']

data: "latitude="+$tlati+"&longitude="+$tlong+"&acao=btn_finaliza

change to:

$latitude = $_GET['latitude'];
$longitude = $_GET['longitude'];

$SQL = "INSERT INTO mapa (lat, lng) VALUES ('$tlati','$tlong')";
mysql_query($SQL, $serve) or die(mysql_error());

Do not use the mysql_* functions already removed in php7 prefer Mysqli or PDO.

Recommended reading:

Why should we not use mysql type functions_*?

Mysqli vs PDO - which is the most recommended to use?

How to prevent SQL code injection into my PHP code

Why parameterized SQL queries (name = ?) prevent SQL Injection?

Answer 2

After specifying the syntax of the code, I discovered the error... Missing an _ in php code. Was

if($_GET['acao']=='btnfinaliza')

more should be:

if($_GET['acao']=='btn_finaliza')

After the fix, the code worked and the data was saved to the database as expected. I thank you for your help and I will follow the recommendations!