Welcome to WebmasterWorld Guest from 23.20.215.116

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Refreshing webpage when MySQL db has changed

     
3:24 pm on Dec 17, 2007 (gmt 0)

New User

5+ Year Member

joined:Dec 3, 2007
posts: 7
votes: 0


I am pretty sure there is not a way to directly do this but wanted to throw it out. Basically we have a log (that several users at a time could be looking at), when data is submitted it posts to the MySQL db. Instead of having the page auto-refresh every 2 minutes or so, it would be nice if it would just refresh when a change is detected. This would also cut down on the chances that data is missed due to inopportune refreshing/submitting. Read something about AJAX? Pretty much a novice so any help would be appreciated.

Thanks
DS

3:37 pm on Dec 17, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 15, 2003
posts:2606
votes: 0


Ajax is the nicest route because no page refresh is called, the data just reloads from an http header request.

Look into it.

There are fully built libraries available.

I use this one with much success. They take care of all the browser compliance and code updates.

Yahoo (YUI)
[developer.yahoo.com...]

5:37 pm on Dec 17, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Jan 16, 2007
posts:914
votes: 0


You'll still have to poll the server for changes, though. About all you could do is increase your polling rate.