CODEWITHSUNDEEP
phpjquerymysqlajax
sir_thursday
sir_thursday

Reputation: 5409

jQuery autosave running success function, but not updating MySQL

My jQuery autosave is running the success function, but not updating the MySQL database. What am I doing incorrectly?

jQuery:

function autosave() {
    var t = setTimeout("autosave()", 5000);

    var translation = $("#doc-translation").val();

    if (translation.length > 0) {
        $.ajax({
            type: "POST",
            url: "update-draft-submission.php",
            data: translation,
            cache: false,
            success: function() {   
                         $(".autosaved").empty().append("saved");
            }
        });
    }
}

PHP:

<?php
session_start();
//retrieve our data
$iddoc = $_GET['iddoc'];
$trans = translation;
$transowner = $_SESSION['userid'];
$true = 1;
include "../dbconnect.php";
$query = "UPDATE translations
          SET trans='$trans'
          WHERE iddoc='$iddoc'
          AND transowner='$transowner'";
mysqli_query($query);
mysqli_close();

echo "Saved";
?>

Upvotes: 0

Views: 757

Answers (1)

raidenace
raidenace

Reputation: 12836

You are not fetching the data in your PHP correctly:

$iddoc = $_GET['iddoc'];
$trans = translation;
  • iddoc is not passed as a GET parameter anywhere
  • "translation" is not a variable (neither do I think it is a constant)

Your SQL will break if it does not get the required values in the query.

Update your javascript so:

$.ajax(
 {
   type: "POST",
   url: "update-draft-submission.php",
   data: data: {translation:translation,iddoc:"XXX"},
   cache: false,
   success: function()
   {   
     $(".autosaved").empty().append("saved");
   }
 });

Replace XXX with your iddoc value.

Then in PHP fetch them as:

$iddoc = $_POST['iddoc'];
$trans = $_POST['translation'];

Upvotes: 1

Related Questions