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;
}
}
?>
