Unique DB Status

[calua]

Hello. I'm creating a site that uses php/mysql. Operations are done in my tables depending on data passed through the url via get method or post. My problem shows itself in two occasions:

1st -> when the data is passed in the url, everytime the user does a refresh or goes back to a page previously visited using back the page reprocesses whatever he did to the db, which is bad.

2nd -> When the user goes back or refreshes as above, the browser says something like: the page was created with information you submited yada yada yada press refresh to resend everything (again, this is BAD :mad: )

How to solve this?

I though that if I send, along with the data already going through via URL or POST, something about a unique db status nothing would be reprocessed, I'd just add something like bellow:

if (table's status NOW is different than on the URL/POST)
do nothing
else
work

Is there any unique status in tables I could access? Something like "last changed"?

:rolleyes: Thanks

[leatherback]

Hi,

In a similar problem (SUbmission of details through a form) I used a session variable, which I changed upon succesfull insertion of data. THis variable was checked whenever a page was loaded/submitted, and choices for processing made based upon it.

But it is quite deendent on your setup and data which you use. You could consider a minimum time between updates, compare the insert data with the last record etcetc.

J.

[calua]

it worked! I created a session variable that recieves a rand() between 1 and MAXINT whenever a submit is made (that is also passed by GET or POST method, depending on the page), and after the operation is executed, a 0, so if the user refreshes nothing is done.

thanks.
caluã