hi all php experts i have a gues

[dgwilliams]

hi all php experts

i have a guest book on the internet that is linked to a MySQL database. the PHP script which links to the database does not update and register the changes when viewed on the internet. I think it is has somthing to do with cache so i tryed inserting the following function into my script clearstatcache();

it made no difference.
The only way i can get the script to register the changes is by adding an extension (changing the URL) for instance:

http://www.tek-tips.com

(this wouldnt show the changes)

http://www.tek-tips.com?2

(this would show the changes to the guestbook)

can anyone help... i hope i made my self clear but if not please feel free to ask for more info.

thanks

 

[Bastien]

the clearstatcache is not the cache that you need to clear. You need to clear the local cache on the client machine. what you can do also is redirect the page to some kind of confirmation page.

if you could show the code I can give you a few more tips


Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[jimoblak]

Could you be behind a firewall/proxy that is caching php pages for you and preventing you from seeing the updates?

Your browser may be lying to you. Could you run a MySQL client to see if your guestbook modifications are being made? A MySQL client connecting directly to your MySQL server (instead of getting data through your web browser) might bypass the caching of your firewall/proxy.

You might also try to hold the shift key while clicking on the web browser's refresh button to force the page to refresh. If this work then you definitely have a proxy caching problem.

- - picklefish - -

Why is everyone in this forum responding to me as picklefish?

 

[dgwilliams]

yeah i have tryed clearing the browsers cache of the local machine by alt-refresh and the changes that are being made to the database throgh the online form are getting through to the MySQL database and the correct changes and updates are being made to the database.

like i said i can see the changes through the browser if i add on the end of the URL somthing like ?2 for instance.
This would show the up-to-date guest book.