How to refresh a form containing table in PHP?

[bAALAaDITYA]

I have developed a PHP page which contains many forms. In my one of the form there is a table which is having data in it. I want my form that is containing this table to be updated after a fixed interval. I don’t want to refresh all the forms of the table. Is there any way by which I can only update this form and not the entire form? Actually I want the table that displays data from the database to be updated for every minute automatically.

[Shreevats]

Making the browser to cache XML files is not a bad idea. To generate XML, create a query and make it to run only whenever the database is updated. Don’t run the query to load the page. You need to turn off the cache if you want your table to get the updated information from the table for every single minute. It is also depended on the size of the database you are having. Also write a query for XML file that is only for updating the database.

[Villiers]

You can add the following lines of code at the end of your PHP page:

<script language="javascript">
window.setTimeout("self.location.href='<?=$PHP_SELF ?>'", 60000);
</script>

You can see that there is a single quote (‘) after the ?> followed by the double quotes (“)
You can add the variables in the page. You can do this by adding it after the ?>. for ex ?id=98765 and so on.

[Ronchi]

Try using AJAX, as AJAX gives a call to the PHP script. It then generates a HTML table. The existing table is by the table created by the PHP script. You can also make use of the META tag. Whenever the page refreshes you can send this Meta tag. This will help you to keep the page to update continuously. You can try these two lines of code in your page:

<meta http-equiv="refresh" content="60;url=<?php echo $PHP_SELF; ?>">
<meta http-equiv="refresh" content="60;url=<? echo $_SERVER['PHP_SELF'] ?>">

[Dwarner]

Another solution is of using IIFE, which is used to set the setInterval. IIFE stands for Immediately-Invoked Function Expression. You can use the following lines of code using IIFE:

var $results = $('#results'),
loadInterval = 5000;
(function loader() {
$.get('script.php', function(html){
$results.hide(200, function() {
$results.empty();
$results.html(html);
$results.show(200, function() {
setTimeout(loader, loadInterval);
});
});
});
})();

[Author]

You will need to have the getTable.PHP to display the content of the table. You can have the following code to make your table content to refresh for the time interval you want.
<script type="text/javascript">
$(document).ready(function(){
refreshTable();
});

function refreshTable(){
$('#tableHolder').load('getTable.php');
setTimeout(refreshTable, 5000);
}
</script>

Here, refreshTable() variable is used to refresh the content of your table.