使用ajax更新sql

Question

I've been trying this code but i don't know what's wrong with it, i want my database to be update once a link is click before it goes to another page

<script type="text/javascript">
function performAjaxSubmission(){

$.ajax({
    url: 'notif_update.php',
    method: 'POST',
    data: {
        action: 'save',
        field: $("#getNotifId").val()
    },
    dataType:'json',
    success: function(data) {
        alert(data.success);
        }
    });
return false; 
}

jQuery(document).ready(function() {
$("#notif").click(performAjaxSubmission);
});
</script>

and my notif_update.php is this:

<?php
  //UpdateData.php
  require_once("connection/dbConn.php");


if (isset($_POST['action'])) {
    $value = $_POST['getNotifId'];            
    mysqli_query($conn, "update notif set notif_status='read' WHERE id=".$value."'");
    mysqli_close($conn);
    $message ="Updated Sucessfuly!";
 }

 echo json_encode(array('success'=>$message));
?>

my html code is like this:

echo "<a href='".$row['notif_link']."' target='content' id='notif'>";
                        echo "<div id='notif_block'>";
                        echo "<img src='".$imgSrc."' width='50px' height='50px' style='padding-right: 5px; float: left;'>";
                        echo $row['notif_name'];
                        echo "<br>";
                        echo "<span style='color: #999999; font-size: 16px;'>".$subTitle."</span>";
                        echo "<span style='font-style: italic; color:#999999; font-size: 16px;'> ";
                        echo date("m-d-Y", $timestamp);

                        echo "<input id='getNotifId' type='text' value='".$row['notif_id']."'>";
                        echo "</span></div></a>";

this html code is a generated notification base on what the database given, i want that when a user click the notification, the status of 'unread' in the database will go 'read' so that it won't be displayed anymore

Answer 1

Your PHP script is expecting a parameter called getNotifId and you're sending 'field'. Change the name being sent via ajax like this:

...
data: {
    action: 'save',
    getNotifId: $("#getNotifId").val()
},
...