real time updating website with data from server

[mrausch]

Hello,

 

I need to build a website that updates in real time, but I do not know what the best way to implement a solution that will allow me to do this. I have a program which constantly checks for new pricing data from an exchange and then writes this data to a mysql table. I would like to build a website which will display this data and be up to date. Ideally any new data would be 'pushed' and immediately reflected on the website but I would also settle for a slightly less ideal solution if it's significantly easier to implement. Can anyone suggest how I should go about solving this problem and what tools (php, javascript, ...) would be best applicable for each part?

 

Thanks,

 

Max

[lemmin]

If your MySQL tables are automatically being updated, all the work in making it dynamic is done! All you have to do is create a script (in PHP) that queries your database for the information. Any time that information is changed by your program that writes to your database, those changes will be reflected on the web page.

[Lamez]

One word: AJAX. I bet you can find some sorta pre-made script that watches the DB and 'pushes' the new info when it is added\changed.

[waynewex]

Obviously this "scraping" of pricing data is being carried out by a cron job, or something along those lines. Simply implement the scraper script before the results are taken out of your database.