Display realtime user status using AJAX and PHP from a MySQL database

Question

I have a simple mysql query which shows users last status. I now want to go further and create a page to show users most recent status without refreshing. The mysql DB is dynamically updated with the users status.

So all that is required is for the page rendering the mysql to refresh with the latest user status without me having to hit the refresh button.

Could anyone provide guidance on how I go about doing this. Thanks

You'd need to use some form of Ajax (or nodes) to poll for data and then insert it into the page with Javascript. — BenOfTheNorth
– BenOfTheNorth, Commented Nov 20, 2012 at 17:42

pregmatch · Accepted Answer · 2012-11-20 18:25:53Z

1

You need push into page, not pool. It is kind of stupid to do poling from database. Here is how that works.

Let asume that you have n users on you page.
Every time that status is changed (you insert that into you DB)

2.1 As this happens you need to push signal to your webpage (use Strophe library).

2.2 In order to push something to page you need Strophe instance running.

2.3 If your website is PHP, here is good class for communicating with Strophe instance.

I can do this for your but you will be more happy if you do this on your own. That real time stuff are very interesting.

answered Nov 20, 2012 at 18:25

pregmatch

2,6736 gold badges38 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Display realtime user status using AJAX and PHP from a MySQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related