How to clear the fields?

[Jarba]

Hi everyone!

My small database contains a few dropdown menues, some textfields, and evertything works fine! Everything is sent to the database as supposed to and some of the fields are even validated, to make sure they contain some information.

Now there is a thing that I can't seem to find the answer to:

After having pressed the Submit-button, I present the entered information to the user, but after that I want to clear the fields ana make sure nothing more is sent to the database! As it works now the information is re-sent if I perform a Refresh on the Browser!

How do I handle this easily?

Thanks a lot for any tips :-)

      / Åsa

[Traduim]

I guess you submit the form to the same page wich contents it.
You could solve your refreshing problem by pointing the action to a page which processes the code and, once the data is in the database, you redirect to the page which presents the information to the browser out of the database, not the form.

If you do so, when somebody refreshes the window after an insert, data will be shown againg out of the database, but it won't be resubmitted. 🙂

Good luck

[Jarba]

Here is my Post/Action statement:

<form method="post" action="<?php echo $PHP_SELF?>">

Do you mean that I in this statement shall add what page is posted?
I´ve been trying to find some information about this in the manual, but I dont quite understand how it is done!

And how do I redirect the pointer but to what?

I am so new to all this, with only low basic programming knowledge, I hope you can point me in the right direction!

      thanks again

[Traduim]

<form method="post" action="<?php echo $PHP_SELF?>">

This means the form is processed in the same page.

You should make 2 more pages to avoid resubmitting the form when you refresh the page.

You should cut&paste the database insertion in a new page, which should be declared as action in the first page.

<form method="post" action="second.php">

Then, once the data is inserted in the database, you redirect to the third page, where you should cut&paste the database look up and copy&paste the form filled out of database.

<script language="Javascript">document.location.replace('third.php');</script>

I hope I have explained myself a bit more

[Jarba]

Now I understand better and I will try all this out tomorrow!

      / Åsa

[zalath]

One way to do it is to use a save script that doesn't output anything, and after saving header() -redirects to another page. In my experience, the browser will only 'see' the page with the form and the redirected page, completely ignoring the script in between, in effect making 'reload' harmless.