更新数据记录onBlur

Question

I am trying to update a record in a database onBlur but it does not work. Any ideas on how I can achieve this? my code looks like below.

JS

$(function () {
$("textarea").blur(function() {

       var meta_value =   $(this).val();
                var meta_key   =   $(this).attr("id");

             alert(meta_value + meta_key);


    $.get('script-url', { key: meta_Key, value: meta_value}, function(data) {

    });
});
});

PHP

<?php


if(isset($_POST['key']))
{
   $meta_value = $_REQUEST['value'];
   $meta_key = $_REQUEST['key'];


$servername = "hhh";
$username = "hhh";
$password = "hhh";
$dbname = "hhh";


 global $wpdb;
 $user_ID = get_current_user_id();  



// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 



$sql = "UPDATE wp_usermeta SET meta_value = $meta_value WHERE meta_key = $meta_key AND user_id= $user_ID";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}


}
?>

Answer 1

Try this ;)

You are sending key & value to server not meta_key;

So update this condition

if(isset($_POST['meta_key'])){

to

if(isset($_POST['key'])){

Answer 2

issue? So really you never get results trying get POST values from a GET request maybe use

$.on('ready', function() {
  $("textarea").on('blur', (function() {

    var meta_value = $(this).val();
    var meta_key = $(this).attr("id");

    alert(meta_value + meta_key);

    $.post('script-url', {
      key: meta_Key,
      value: meta_value
    }, function(data) {

    });
  });
});