Auto refresh

[sandy1028]

hi,

 

I am facing problem in refreshing... When any new data is added in database it is not displayed unless the page is refreshed with F5 key

 

How can I make the page auto refresh when the data is added

[sandy1028]

hi,

 

Please help me with this

[rajivgonsalves]

You could use Ajax and check the database every 1 minutes or so

 

here a link which might help

 

http://en.wikipedia.org/wiki/Ajax_(programming)

 

or if you do not want to check if data has change you can refresh the page with a meta tag

 

<meta http-equiv="refresh" content="60" />

 

10 - number of seconds

 

[sandy1028]

If I use meta tag the page gets refresh and page gets disturbed when viewing the page

[trav]

i would use ajax

 

here is a quick fast tutorial

http://w3schools.com/ajax/default.asp

 

you don't even really need to know javascript,

just take the section of your code that displays the dynamic data and move it into another .php file, then use ajax to grab it, then you can make a button or link that refreshes the data, or a timer, or set a function that checks at intervals for the number of result to have changed from the number display and at that point display a button to refresh or some other notification so the user can be in control of when to refresh,

 

hope that helped.

[trav]

here is another tutorial aimed more at php integration

http://www.w3schools.com/php/php_ajax_intro.asp

 

also one last thought, you should have a catch so that if a person's website doesn't support ajax it will display normally with a note that the information will not be refreshed (or use a meta tag)