How to get data from PHP MySQL realtime and display it

Use JavaScript to call a function that will update calls every n milliseconds. You also need to use JQuery library to deal with Ajaxs’call in order to update your page. If you don’t have JQuery then download it. Check JQueryAjax.txt attached to this message. The file has a code showing how to update. The code make use of the PHP script to call the server and update the webpage. The page is updated every 1000 milliseconds.

 

You can also check this site that has a nice tutorial with details on how to use Ajax, JavaScript and PHP to display the data without refreshing the page.

I hope this helps.