Dynamic Update (Insert) with ajax

Question

I did some research, and I still can’t solve this problem. is an onclick event that sends a request to the update.php file, which updates the notification table. Follows code below:

Triggers the onclick event:

<input type="hidden" name="id" id="id" value="'.$id.'">

<a onclick="sendData()" href="#">

Ajax from this page:

<script>
function sendData()
{
    var id_n = $('#id').val();

    $.ajax({
        type:"POST",
        url:"update.php",
        data: { id: id_n },
        contentType: false,
        cache: false,
        processData: false,
        success:function(dta)
        {
            alert(dta);
        }

    });
}

</script>

Excerpt from update.php file, code:

$id = ($_POST['id']);
$sql = "UPDATE notif SET status = 1 WHERE id = :id";
$res = $pdo->prepare($sql);
$res->bindParam(':id',$id);
$res->execute();
$pdo->close(); 

What could be wrong? Grateful for the attention.

Answer 1

When you pass an object like { id: id_n }, in the data from ajax, what jQuery does is convert to query string: id=oValorDe_id_n with the jQuery.param(). Having the option processData: false it prevents it. Removing it assumes processData: true.

You can read more about it here (in English)