reseting variables from form PHP_SELF

[Anon]

************The Scenario************
I have a form that updates a database

<form action="<? PHP_SELF ?>" method="post">

<input type="text" name="title" size="40" maxlength="75">

<input type="text" name="sub_title" size="40" maxlength="75">

<input type="text" name="body" size="40" maxlength="75">

<input type="submit">

</form>

after the form is submited the user can add another entry.

variables created via form post
$title
$sub_title
$body

*******************The Problem*********

If the user refreshes the browser, via REFRESH the database is updated with the same information from the former posting. So what I need is a way to reset the variables to a NULL value.

****************The Question***************

So how can I set the variables to NULL value or !isset, after the user submits the form to the database?

Thanks

[knickerlas]

There are two ways I can think of to solve this:
First:
You could check the data in your DB and if it's the same as the vars then dont submit it.
Second:
You can set a 'flag' that is set to 'on' once the data is sucessfully submitted. then have a link/submit button that will set it to 'off' if you request another entry.( In that case just use unset($var) on your vars)
You will require sessions or hidden fields for this.

Nick

[seidel]

how do I impliment <input hidden> fields with this flag system you are refering to?

Not exactly sure whate you are talking about, could you please explain in a little more detail for me. Thanks
Thanks

[knickerlas]

Okay, you could do something like this(forget the hidden thing this is easier)

Have a logic statement at the top of your page and display different stuff accordingly:

if(NewPage) {
// display input form with submit button
}
elseif (Submit) {
// submit then set $is_submitted='yes'show succes msg with another form asking to either finish(goto home etc) or submit another page(NewPage)and within this form have something like
if($is_submitted){
print("<input type='hidden'name='is_submitted' value='yes'>");

}
elseif(Finish) {
// send wherever
}
else {
// display input form with submit button
}

I wouldn't expect this code to actually work it's just meant to give you an idea of how it might be done

Good luck

Nick

[rrijnders]

After the code that updates your db, send a

header("Location: form_page.php");

to reload the form "fresh" without any of the variables being set. If the user then hits the reload button, the "fresh" form is refreshed without sending any post vars to your script.

-- Rich Rijnders
-- Irvine, CA US