I wan't auto refresh in input field. can you help me for that?
Example: Here is my php code
<?php
$result = mysql_query("SELECT * FROM datapy ORDER BY No DESC LIMIT 0,1");
$showlast = mysql_fetch_array($result);
?>
<input type="text" value="<?php echo $showlast['nilai_1']; ?>" id="last">
What should I do if I want to make the input field into an auto refresh to get last data from database. note: i will refresh on input field only
You can use the setTimeout().
Your html content
<input type="text" value="" id="last">
Add the javascript
$(document).ready(function() {
refresh_field();
})
function refresh_field() {
$.get("ajax_file.php", function(data) {
$("#last").val(data);
window.setTimeout(refresh_field, 1000);
});
}
Where the ajax_file.php is a php file that will feed the value to be updated.
<?php
$result = mysql_query("SELECT * FROM datapy ORDER BY No DESC LIMIT 0,1");
$showlast = mysql_fetch_array($result);
echo $showlast['nilai_1'];exit;
?>
Your javascript code and ensure your jQuery library is loaded.
var url = // Source of data url
var sec = // Time interval in seconds for autorefresh
$(function() {
setTimeout(function() {
$('#last').load('url' + ' #last');}, sec );
});
Take note of the space in ' #last' otherwise it will return an entire page.
