No Return Json to Ajax

Question

I don’t get Json feedback in Ajax. Any idea what it might be?

Ajax.js

$.ajax({
type: 'POST',
dataType: 'json',
url: "crud/insere.php",
data: dados,
success: function(data) {

    var objeto = JSON.parse(data);
    alert(objeto.id);

 }
 });
 return false;

php insert.

$nome = $_POST['nome'];
$telefone1 = $_POST['telefone1'];
$operadora1 = $_POST['operadora1'];
$telefone2 = $_POST['telefone2'];
$operadora2 = $_POST['operadora2'];
$email = $_POST['email'];
$cidade = $_POST['idCidade'];
$observacao = $_POST['obs'];
$dataCadastro = date('Y-m-d H:i:s');

if(empty($cidade)){
   $cidade = '0';
}

 $select = "INSERT INTO Cliente(nome, telefone1, telefone2, operadora1,   operadora2, 
       email, idCidade, observacao, dataCadastro) 
       VALUES ('$nome', '$telefone1', '$telefone2', '$operadora1',     '$operadora2', '$email', '$cidade','$observacao', '$dataCadastro')";
 $conexao = conexao();           
 $PDO=$conexao->prepare($select);
 $PDO->execute();

 $select = "SELECT id FROM Cliente WHERE email='$email'";
 $PDO=$conexao->prepare($select);
 $PDO->execute();
 $obj = $PDO -> fetch(PDO::FETCH_OBJ);

 $arr = array('id' => $obj->id);
 echo json_encode($arr);insira o código aqui

Complete Code

Answer 1

In this situation just look at what the ajax request is returning. On the page that makes the request go to inspect elements, network (network) and see what is happening with your request (will vary from browser to browser). So you will see if the error is in the request, server, or client.

Answer 2

Just one more detail. When you enter dataType: 'json', the callback Success parameter is already a json object, i.e., JSON.parse is unnecessary and can generate an Exception in some cases.

Your JS code can be like this:

$.ajax({
type: 'POST',
dataType: 'json',
url: "crud/insere.php",
data: dados,
success: function(data) {
    alert('funcao success');
    alert(data.id);
 }

});

In your PHP file is indispensable include the json header:

<?PHP
$data = /** seus dados **/;
header('Content-Type: application/json');
echo json_encode($data);

Another important thing is that json_encode() only works with data in UTF-8. That is, if your php file or data in the database is in ISO-8859-1, you need to make a utf8_encode() in each of the strings.

Answer 3

Looking at the code quickly I saw something that if it is present in the code that you are running may actually be the cause. It is the last line:

echo json_encode($arr);insira o código aqui

delete after the ;

if this is not present in the code do so:

Change the code for this:

alert('antes ajax'); //ou console.log, como preferir
$.ajax({
    type: 'POST',
    dataType: 'json',
    url: "crud/insere.php",
    data: dados,
    success: function(data) {
        alert('funcao success');
        var objeto = JSON.parse(data);
        alert(objeto.id);

     }
 });
 return false;

to know if there is a syntax error or if the code is not even executed. If you know how to use it, you’d better use the browser’s Debugger instead of the Alerts or console.log.

Then check the apache log or your http server. For apache it is usually in /var/log/apache/error.log. See if there are any php errors there.

after this, in case you don’t use some php Debugger to see where it is failing, put some Snippets in various parts of the code even if it looks bad on the screen to see where the line is that the error occurs.

If this is not enough for you to see where the bug is, when you discover the line, edit the question with the part of the code where the bug is and I will continue to assist you.