Problem with refresh

[Alex_B]

Hello,
I have a small problem...
I do have a script that uploads data into db. Yet, I have noticed that if I refresh the page it uploads data into db again.
My script redirect data to itself ( i use $PHP_SELF ) with success message and perhaps that is the problem.
I have tried to catch the problem by setting submitFlag but it does not work.
I assume that I can submit data on one page and display success method on another, yet I am curious if that can be done in the same page.

What I have is following

<?
.....
$alreadySubmitedFlag = false

if (!$alreadySubmitedFlag) {

insertDataIntoDB();
$alreadySubmitedFlag = true;
}
else {
displayErrorMessage()
}

.......
?>

Any suggestions?

[cgraz]

assuming you have a form with a submit button that looks like this

<input type="submit" name="submit" value="Submit Form">

Then to update the database, do

if(isset($_POST['submit'])) {
   // update db code here
   unset($_POST['submit']); // unsets the variable
} else {
   // don't update
}

That should work.

Cgraz

[Alex_B]

Tried that, but it still updates db anytime I am trying to refresh the page.

[cgraz]

you tried my code how it is? It should work just fine. It checks if the variable isset, if it is, updates db, then unsets it. From then on it's not set anymore, so the part of the if that updates the database is no longer executed. did you make sure you added a name attribute to your submit button?

Cgraz

[Alex_B]

Sure did try your code. I understand the idea, yet it just keep adding new rows anytime I am hiting refresh button...

[cgraz]

hmmm, can you post your code?

Cgraz

[Alex_B]

it is 'in progress' kind of thing but I just send the code over the email.
thanks for the help

[cgraz]

Posted by me

did you make sure you added a name attribute to your submit button?

That's your problem.

$_POST['submit'] looks for a variable submit, but your form doesn't have a variable submit. You have

<INPUT TYPE='submit' name='preview' value='preivew'>

meaning the variable is preview. either change the name of that to submit, or change your if to

if(isset($POST['preview'])) { etc etc (change the other $POST['submit'] to $_POST['preview'] also

Cgraz

[Alex_B]

No,
there are three sections
first is initial set up with posting all info
second is preview
third is submit

[t_bag]

Were you able to solve the problem, Alex? I have the same problem as you. My button is named correctly ("submit") but the form keeps adding new rows to the database.

Some use the following code:

if($submit)
[enter the data]

But this doesn't work for me. I think the problem is that the form is on the same page and, as you said, redirects the data to itself. Of course, I could use a separate file for the form, but I just refuse to believe that there is no solution to this problem.