I'm new in ajax. I have try to find solution but failed. I want to refresh MySQL query in every second but how? I have no idea how to do it so please help me.
$sql="SELECT * FROM `user`";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
echo $row['fname'];
echo $row['email'];
}
Try below
<div class="result"></div>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script>
function refresh_div() {
jQuery.ajax({
url:'YOUR PHP page url',
type:'POST',
success:function(results) {
jQuery(".result").html(results);
}
});
}
t = setInterval(refresh_div,1000);
</script>
<div class="result"></div> to your answer so OP knows to put it on the page somewhere.
<div class="result"></div> and add your function but it does not working..You can use jQuery with $.ajax() to get data, setInterval() to call a function every x seconds and $.html() to insert your data into an element.
Here is an example :
setInterval(function(){ getUsers(); }, 1000);
function getUsers()
{
$.ajax({
url: 'myphppage.php',
type: 'post',
success: function(data) {
$('.htmlelement').html(data);
}
});
}
<div class="htmlelement">data will appear here</div>
.htmlelement is an HTML element (ex: a div with a class "htmlelement"), where your results will be inserted.
Brutal solution: set the meta refresh tag in HTML:
<meta http-equiv="refresh" content="1">
var timer=setInterval(functionName,1000)to call the PHP Skript by Ajax. I can't say more you don't give many details to work with. Another more brutal solutuion: set the meta refresh tag in HTML.