Good evening,
I am here trying to send a value to a php file, and receive response from that same file, this automatically. But something is going wrong. I am a beginner in this area and I have some difficulty. Can someone please help me?
I leave below the jQuery code, there is something wrong with it that is not returning any value.
$(document).ready(function() {
var myLast = 'sendlast='+ $("#send_total").val();
var auto_refresh = setInterval(
jQuery.ajax({
type: "POST",
url: "auto_load_news.php",
dataType:"text",
data:myLast,
success: function () {
$('#have_news').load('auto_load_news.php').show("slow");
},
error: function (xhr, ajaxOptions, thrownError) {
alert(thrownError);
}
}),
200000
);
});
<?php
include("config.php");
if (isset($_POST["sendlast"])) {
$last = filter_var($_POST["sendlast"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
$result = $mysqli->prepare("SELECT idpost FROM post ORDER BY idpost DESC LIMIT 1");
$result->execute(); // Execute prepared Query
$result->bind_result($idposta); // Bind variables to prepared statement
while($result->fetch()) {
if($idposta > $last) {
echo "Existem novos posts";
} else{
}
}
}
?>