Script refresh problem /************/

GarroteYou

Hello,

I've got an interesting problem, and I'm not sure how to go about fixing it. The script is located here:

http://www.zegelin.com/php/gbook.php

The code is located here:

http://www.zegelin.com/php/gbook.txt

When a user completes the required fields, and hits submit, the entry is added to the database, the page reloads and the form is cleared. The problem is that if you hit F5, and or refresh the page, a duplicate entry is added to the database. Feel free to try it and see.

Sign the book with anything, hit submit, and when the page is back, refresh it a few times. With each refresh another entry is added.

This is not a big deal, but from experience I can tell that a problem like this could become much more troublesome in a more grandiose application.

I've tried setting the variables to NULL and I've setup some flags etc.

Help from anyone teaching me how to fix this will be greatly appreciate.

drawmack

instead of just reprinting the page from inside php try this

<?php
header('Location: ' . $_SERVER['PHP_SELF']);
?>

GarroteYou

Thanks for the reply.

I added both

header('Location: ' . $_SERVER['PHP_SELF']);

and:

header( 'Location: http://www.zegelin.com/php/gbook.php' );

to my script, and unfortunately it causes the script to hang when the page tries to load. I read the manual for header(), and the RFC section on the Location: header. I understand what these things are doing, and what they are for, but I'm not sure how this approach can help my problem.

Can you please explain further?

zapa

how about this little trick,

ffrom what i understand you having problems with Data being submited two times if page is refreshed with browser.

What if you added a HIDDEN field
for exmaple...

<?
$been_here = "0";

if (isset($_post['submit']){
$been_here = "1";
if (!empty($_post['sent']){
add database code here...
}
else {
print "Information is already sent to database";
}
}
?>

i.e. <input type="hidden" name="sent" value="<?PHP print $been_here; ?> ">

then when you submit the database.

mothod is to set the Hidden Text field to off, then set it to ON (1)
when you try to refresh it will check to see if Hidden value is set.
if its true then it want submit to database

hope you hunderstand what i am trying to exmaple and also hope i understand your problem right