Reload problem with forms

Anon

Here is my problem.

A php file includes a series of forms that are used to make some modification on a database (add, delete, modify records, and so on...).

The problem is that if the end user reload the file, the database modifications are made again.

I have considered a few solutions that I feel are too heavy:

Adding a script that will prevent the same modifications be made again.
Using a redirection (header()) fonction to redirect to the same file without the POST variables. It is not very convenient either for several reasons...

If anybody has a straight forward solution, that would prevent the POST variables to be used again when the RELOAD button is hit, I thank him by advance.

Herve...

Anon

Here is just an idea...

Place your action scripts (i.e. add, delete, modify, and so on) in different pages that are designed only to open and redirect. Redirection is not difficult in cases such as that. For instance if you add a record, the submitted form will go to a new page where the record will be added, then the new page will redirect to the original page. That way, if the user refreshes, they see the same information. Here is an example of such a page.

<?php

if ($blah=="Add Record")
{
echo "Add a record.";
}
elseif ($blah=="Delete Record")
{
echo "Delete a record.";
}
elseif ($blah=="Modify Record")
{
echo "Modify a record.";
}

echo "<META HTTP-EQUIV='refresh' CONTENT='0;URL=original_page.php'>
</HEAD>
<BODY></BODY>
";

Of course, you'd need to change the original_page.php to whatever it should be.

AaronZoller.com

Anon

And of course, close the PHP section with the ?>.

Doh!!! I'm such an idiot!

AaronZoller.com

Anon

other than putting them on seperate pages you could have a variable that keeps track of whether they have been made... such as

$changed = 0;

if ($changed == 0){
<write to db stuff>
$changed = 1;
}

might work :/