Automatic Refresh of DIV using jQUery on MySQL change

Question

Is there a tutorial out there which shows you how to refresh a DIV upon a MySQL change? Like to show only the MySQL records above a certain timestamp and/or ID?

You'll have to poll the db at regular intervals. However, beware that polling solutions scale very poorly, so make the interval long enough. — Marco
– Marco, Commented Mar 23, 2011 at 16:40
Alternative to what Marco said would be to catch all changes to the database in your application and have your UI driven by that. It is like going from accessing your class members directly to having setters/getters (always a good idea) — Zepplock
– Zepplock, Commented Mar 23, 2011 at 16:48

Zakaria · Accepted Answer · 2011-03-23 17:35:00Z

1

I agree with the comments. But, you can try to experiment an event-driven server side technology. For example, node.js (based on websockets).

Your client stays listening till an event occurs (database insert), and then, you can reload your div.

This is theory, but I'm sure you can do it this way.

But, as Marco said it, the best way is to set intervals to your refresh (poll method).

Regards.

answered Mar 23, 2011 at 17:35

Zakaria

15.1k22 gold badges86 silver badges126 bronze badges

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

Collectives™ on Stack Overflow

Automatic Refresh of DIV using jQUery on MySQL change

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