Error inserting data into database with Jquery and Ajax

Question

Error inserting data into database with Jquery and Ajax

Navigation

#1 by (1 votes)

0

This code snippet always returns ERROR: 200. It is inserting the data in the database normally, but it returns error in the interface.

    $("#registrar").click(function(){
        $.ajax({
            url : "registra.php",
            method: "POST",
            dataType : "json",
            data : {participante1 : $("#participante1 option:selected").val(),
                    participante2 : $("#participante2 option:selected").val(),
                    score1 : $("#score1").val(),
                    score2 : $("#score2").val()},

            success : function(resp){
                alert("Registro efetuado com sucesso!");
            },

            error : function(err){
                alert("ERRO: " + err.status);
            }
        });
    });

PHP code:

<?php 
    $con = pg_connect("host=localhost port=5432 dbname=Jogos user=postgres password=postgres");
    $participante1 = $_POST['participante1'];
    $participante2 = $_POST['participante2'];
    $score1 = $_POST['score1'];
    $score2 = $_POST['score2'];
    $comando = "INSERT INTO disputas (participante1, participante2, score1, score2) 
                VALUES ('$participante1', '$participante2', '$score1', '$score2')";
    pg_query($con, $comando);
    pg_close($con);
?>

jquery ajax

asked by anonymous 21.06.2017 / 04:45

1 answer

Change background of a section [closed] Doubt Update Panel GridView

score 1 · Accepted Answer

This behavior happens when you set the expected return as JSON to:

dataType : "json"

but the server does not return a valid JSON. In this way, jQuery, when analyzing the return, considers that there has been an error and triggers the error function, even with the return HTTP code 200. To correct this, simply modify the return type to text or make PHP return a valid JSON.

That is, do:

$("#registrar").click(function(){
    $.ajax({
        url : "registra.php",
        method: "POST",
        dataType : "text",
        data : {participante1 : $("#participante1 option:selected").val(),
                participante2 : $("#participante2 option:selected").val(),
                score1 : $("#score1").val(),
                score2 : $("#score2").val()},

        success : function(resp){
            alert("Registro efetuado com sucesso!");
        },

        error : function(err){
            alert("ERRO: " + err.status);
        }
    });
});