[Resolved] Refresh Resubmits SQL

Cynthia_Blue

I have a problem with some of my pages. I have a user enter information in a form, then when the button is clicked it brings the same page back using the $PHP_SELF. Does the SQL insert and gives the user a message reflecting the insert made.

However, if you click Refresh on the browser, it reinserts this information. This is a critical problem.

Is there any way to clear out those vars? I tried setting them to NULL or 0, but to no avail. Or will I have to redirect my user to another page, so the submit doesn't happen again?

Thanks.

kevinsequeira

i usually redirect the user to a thankyou page or a message page, its easier this way - use header("location"page.php");

reg
kevin

Cynthia_Blue

Okay thanks. I've been looking into it for the past couple hours... now I'm having header problems. I'll have to go read up on how they work.

Cynthia_Blue

Searching the web I found this little article:
http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_11928218.html

The guy suggests using cookies. Setting the cookie when the page is reached, then deleting it. Use an If statement to see if the cookie is there. If the page is refreshed and the cookie has already been deleted, don't do the SQL statement.

I think it's working! 😃

TheIceman5

Originally posted by Cynthia Blue
Searching the web I found this little article:
http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_11928218.html

The guy suggests using cookies. Setting the cookie when the page is reached, then deleting it. Use an If statement to see if the cookie is there. If the page is refreshed and the cookie has already been deleted, don't do the SQL statement.

I think it's working! 😃

fuk, no way i would do that, cookies arent reliable, ive found a reasonable percentage of machines dont accept cookies and there fore page wont work, i simple reset the action variable to null when the action has been done, works perfect in all situations.

Xoid

Hi Cynthia!

Perhaps you could use sessions? once the user has submitted the form you call a session, if they try to post again then you could check the session, if session exist then display message such as "Sorry you have already posted" etc...

Hope this helps!