How can I refresh a page when a database is updated?

by

This is how I recently implemented a solution using jQuery.

PHP increments a field in the database every time a significant update occurs.

<?php

//  Call this function when data changes
function update_clients()
{
    mysql_query( "UPDATE pageGen SET id = id + 1 LIMIT 1" );
}

//  Call this function to get the ID to pass to JavaScript
function get_update()
{
    $result = mysql_query( "SELECT id FROM pageGen LIMIT 1" );
    $update = mysql_result( $result, 0, 'id' );
    return $update;
}

?>

When the page is initially loaded, populate a JavaScript variable with a number from the database:

<script type="text/javascript">
var pageGenID = 25218603  //  generated by PHP
var processUpdate = function( response ) 
{
    if ( pageGenID < response ) 
    {
        replace_current_data_with_new_via_ajax();
        pageGenID = response;
    }
}
//  Compare our Page Generate ID against that of the server
var checkUpdates = function()
{
    serverPoll = setInterval( function()
    {
        $.get('script_to_return_latest_pageGenID.php', 
          { lastupdate: 1 }, 
          processUpdate, 'html');
    }, 10000 )
};

//  Check for updates every 10 seconds
$( document ).ready( checkUpdates );

</script>

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. Is it ” RTSi6+yxLwIW7KsnoehVDA== ” md5? or How to get original string? [closed]
  3. which is better every user have a table or just a row [closed]
  4. save user images in MYSQL database by which method? [closed]
  5. Php foreach give 2 users random value
  6. Many-to-many relationships examples
  7. PDO get the last ID inserted
  8. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  9. Get the Last Inserted Id Using Laravel Eloquent
  10. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  11. How to upload images into MySQL database using PHP code
  12. Refresh a page using PHP
  13. Importing CSV data using PHP/MySQL
  14. MySQL check if a table exists without throwing an exception
  15. Inserting data to table (mysqli insert) [duplicate]
  16. PDO::PARAM for type decimal?
  17. Generating a single Entity from existing database using symfony2 and doctrine
  18. Codeigniter – Using Multiple Databases
  19. Selecting a float in MySQL
  20. Get all child, grandchild etc nodes under parent using php with mysql query results
  21. Storing database connection in a session variable [duplicate]
  22. How to execute raw queries with Laravel 5.1?
  23. Dealing with timezones in PHP
  24. PHP and Microsoft Access database – Connection and CRUD
  25. MySQL skipping first row
  26. Laravel nested relationships
  27. Why I am getting an error when using w3school tutorial? [duplicate]
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. CakePHP switch database (using same datasource) on the fly?

Leave a Comment