How can I detect the latest updates made to a database and silently refresh a page when a change occurs?
Let's say the database access looks like:
$host = "localhost";
$username = "root";
$password = "root";
$db = mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db('ccr') or die(mysql_error());
Any ideas and samples would be appreciated. Thank you.
This is how I recently implemented a solution using jQuery.
PHP increments a field in the database every time a significant update occurs.
When the page is initially loaded, populate a JavaScript variable with a number from the database: