How to do timed reading in the database?

2

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{	
        }
    }
}
?>
    
asked by anonymous 03.11.2015 / 00:40

1 answer

0

Your error is occurring in PHP code, change it as follows:

<?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 COUNT('idpost') as total
        FROM post
        WHERE 'idpost' > "?"
        ORDER BY 'idpost' DESC
        LIMIT 1
    ');
    $result->bind_param('i', $last);
    $result->execute();
    $row = $result->fetch();
    if($row['total'] > 0) {
        echo "Existem novos posts";
    } else {
        echo "Não existem novos posts";
    }
}
?>

I highly recommend switching the mysqli functions to the PDO, as the usage is very similar, you will not have a hard time learning.

    
13.11.2015 / 16:07