PHP and AJAX, what am I doing wrong?

Question

Friends, I am doing an AJAX with PHP but the record is going empty. What I am doing wrong?

function newColor() {
    var nome = document.getElementById("descricao_cor").value;
    var cor = document.getElementById("hexadecimal").value;
    alert (nome);
    alert(cor);
    $.ajax({
        url: "atualiza-cor.php",  
        type: "GET",
        data: { descricao_cor: "nome", hexadecimal: "cor" },   
        cache: false,
        success: function() { 
        document.adm.submit();
        $('#btnSelecionar').trigger('click');
    }
});
}

The Alerts work well. And there’s PHP like this:

//NOVA COR
if (isset($_GET['novaCor']) && ($_GET['novaCor']) != '') {
    echo $sql_novacor = 'INSERT INTO veiculos0_cores (descricao_cor,relevancia,hexadecimal) VALUES("' . $_POST['nome'] . '","", "' . $_POST['cor'] . '")';
    mysql_query($sql_novacor) or die(mysql_error());
}

And a record is entered, but it’s empty. I’m not finding the problem. Someone help me, please?

[]s

Answer 1

You don’t seem to be using the method POST. Simplify using $.post:

$.post({
    'url': "atualiza-cor.php",
    'data': {
        'descricao_cor': $("#descricao_cor").val(),
        'hexadecimal': $("#hexadecimal").val()
    },
    'success': function() { 
        document.adm.submit();
        $('#btnSelecionar').trigger('click');
    }
});

Remembering: You were returning a string to descricao_cor and hexadecimal. If you take the quotes will return the value that is in the variables descricao_cor and hexadecimal.