CODEWITHSUNDEEP
javascriptphphtmljquerymysql
Lucas Abraham
Lucas Abraham

Reputation: 11

Live updating table with mySQL data

I have a database that is updated with new rows almost every few seconds.

I have a table on my website that I would like to be automatically updated with the new rows added to the top without the user having to refresh the page.

I was testing the below:

        $(document).ready(function(){    
        loadstation();
    });
    function loadstation(){
        $("#data_download").load("/include/data_download.php");
        setTimeout(loadstation, 1000);      
    }

This works however I am unable to select anything in the table as when the function refreshes the request is unselects everything. I am also met with another issue of scale and after some time on the page I receive an error on the browser about memory issues "SBOX_FATAL_MEMORY_EXCEEDED".

What would be the best approach to having this be scalable and with no memory issues.

Thanks in advance.

Upvotes: 0

Views: 478

Answers (2)

vanowm
vanowm

Reputation: 10201

The best approach would be use AJAX. The server should only send data of the updated fields (JSON format preferable) and javascript should simply replace textContent of the needed field(s).

Upvotes: 0

LordNeo
LordNeo

Reputation: 1182

You could add a timestamp to your rows and only pull (and load) the extra rows happened since the last update.

Let's say you loaded the page at 00:01, then you pull and append (instead of load) the rows added since 00:01 and update the timestamp.

This would solve the issue deleting the selection, because it would add and load only the extra rows and not reload the full table on each update.

Upvotes: 1

Related Questions