Hello everyone.
I’m trying to set up a long polling with php and ajax , retrieving data from mysql.
I looked at several post and tutorial, but I’m not able to work it out.
Here my code:
server.php
<?php
include "../connect.php";
$requestedTimestamp = isset ( $_GET [ 'timestamp' ] ) ? (int)$_GET [ 'timestamp' ] : time();
while ( true )
{
if (!$result = $cn->query("SELECT date,time, nameclient, emailclient FROM shoppingcart WHERE time > $requestedTimestamp")) {
echo "Errore della query: " . $cn->error . ".";
exit();
}else{
// conteggio dei record
$rows = $result->fetch_row();
if ( count( $rows ) > 0 )
{
$json = json_encode( $rows );
echo $json;
break;
}
else
{
sleep( 2 );
continue;
}
client.js
function getContent( timestamp )
{
var queryString = { 'timestamp' : timestamp };
$.get ( 'http://127.0.0.1/server/server.php' , queryString , function ( data )
{
var obj = jQuery.parseJSON( data );
for (var k in obj)
{
var comment = "<p>" + obj[k].comment + "</p>";
var timestamp = obj[k].timestamp;
$( '#response' ).append( comment );
}
// reconecta ao receber uma resposta do servidor
getContent( timestamp );
});
}
$( document ).ready( function ()
{
getContent();
});
results.php:
<html>
<head>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="client/client.js"></script>
</head>
<body>
<h1>ORDINI</h1>
<div id="response"></div>
</body>
</html>
Is there anyone who can help me ?