Stop POST when I hit F5 on page

davestar_delux · 11 Oct 2009 at 13:52

Hey, I have a webpage to add some data to a mysql database, I am sending this info using POST, the info is sent to the same webpage where it is submitted, the page is just reloaded really.

Trouble is when I hit F5 it wants to resend the POST data which would create duplicate records which I don't want. Is there a way to reset the POST values so the page can be refreshed by the user as they wish without resending any POST data?

dangerstat · 11 Oct 2009 at 13:57

Well there's probably a MUCH easier way to do it, but I'd include a hash of the data you intend to upload to MySQL in the post. Then get the PhP to check to see if the hash already exists in your table, if it does do nothing if it doesn't upload the data.

Moredhel · 11 Oct 2009 at 14:16

Submit to a post page which then redirects to the next page (401). That way the post data doesn't carry on to the redirected page.

Izi · 11 Oct 2009 at 14:53

set a session/cookie after initial success post. check for this session/cookie on page load

Dj_Jestar · 11 Oct 2009 at 19:10

Moredhel said:
Submit to a post page which then redirects to the next page (401). That way the post data doesn't carry on to the redirected page.

Why 401?

GravyMonster · 11 Oct 2009 at 20:52

I think he means 301 (302 would also work depending on how your page structure is setup for google).

Dj_Jestar · 12 Oct 2009 at 11:00

303 is designed for this purpose, but some pre-HTTP/1.1 agents don't handle it

10.3.4 303 See Other

The response to the request can be found under a different URI and SHOULD be retrieved using a GET method on that resource. This method exists primarily to allow the output of a POST-activated script to redirect the user agent to a selected resource. The new URI is not a substitute reference for the originally requested resource. The 303 response MUST NOT be cached, but the response to the second (redirected) request might be cacheable.

The different URI SHOULD be given by the Location field in the response. Unless the request method was HEAD, the entity of the response SHOULD contain a short hypertext note with a hyperlink to the new URI(s).