php page refresh causes problem

[Anon]

Every time the php page is refreshed the form variables are reposted. This causes a problem such that the database that is being updated using these form variables is re-updated every time the user refreshes the form, hence causing redundant data. Kindly suggest some way to clear the HTTP_POST_VARS once the data it holds has been used as required.

Thanx, Nisha

[Anon]

hi nish

right now i dont think so any help is available
the only think u can do is
before insert statement

what u can do is
let say u have a input field called
sender_name typically in a guest book application.

now what u can do is write a select sql statement which will check with the respected column lets say senders_name
if returns some record that means u have a similar record and accordingly show the message already inserted..

if i find some ill mail ya
if ya get some mail me at [e-mail]

that's it

dips

Nisha Shah wrote:

Every time the php page is refreshed the form variables are reposted. This causes a problem such that the database that is being updated using these form variables is re-updated every time the user refreshes the form, hence causing redundant data. Kindly suggest some way to clear the HTTP_POST_VARS once the data it holds has been used as required.

Thanx, Nisha

[Anon]

One technique I sometimes find useful is to enclose the INSERT statement in if($var){
INSERT
$var = "";
}; send a var with the form that must exist for the insert, then drop the $var value, perhaps you could do something like this with your input vars.
Hope this helps
Rick

[Anon]

Well that works with some types of refreshes. Other types that rely on the history.back() funciton of the DOM re-post the data. The only way around this is not to use the history, but then I'm not sure how to disable it for every browser out there...