When reload a page it insert more data ...

Anon

HI friends;

I am using redhat 5 , php 3.0.16 and mysql 3.23. I have a question about reload a page, maybe it is a stupid question for the experts in php , but I am new in this program. I create a form that insert new clients. The first form is:

NAME: <input type=text name=name size=20 maxlength=20><br>

PASSWORD: <input type=password name=passwd size=20 maxlength=20><br>

</form>
</body>

the second form is:

<?php

mysql_connect (localhost, root, airplane);

mysql_select_db (plane);

if ($passwd) {

$key = "senha de acesso";
$passwd_encrypt = mcrypt_cbc(MCRYPT_SAFER-SK128, $key, $passwd, MCRYPT_ENCRYPT);

mysql_query ("INSERT INTO client (name,login,passwd) VALUES ('$name', '$login', '$passwd_encrypt')");

print ("$name");

print (" Thank you for registration");

} else {
echo " error ";

}

If I reload a page the user is insert more times, anyone can tell where can I find a doc that tell me about, that is not possible insert anything else after the submit buttom.
I thank in advanced.

Regards.

Anon

Set a cookie if the insert works.
Maybe something like this:

if ($has_inserted != 'yes') {
mysql_query ("INSERT INTO client (name,login,passwd) VALUES ('$name', '$login', '$passwd_encrypt')");
$has_inserted = "yes";
set_cookie("has_inserted");
} else {
echo "error";
}

More info on cookies can be found on this site.

Anon

The method I use is this:

1) Upon pressing the "submit" button on an add or change form, the 'action' attribute points to a processing script.

2) The processing script process the add/change/delete in the database and then sends a 'header("Location: confirmation.php")' to the client to take them to the confirmation page.

Since the confirmation page is the result of a redirect, pressing "reload" on the browser only causes the redirected page to be re-displayed or re-run; in this case that is just the confirmation page without the database processing.

Works like a charm on all my web sites.

-- Rich --

Anon

Hi Rich;

I tested with header , but I receive this error message:

Warning: Cannot add more header information - the header was already sent (header information may be added only before any output is generated
from the script - check for text or whitespace outside PHP tags, or calls to functions that output text) in /home/httpd/html/submitform.php3 on
line 13.

Do you have any idea what is the problem??

Regards.

Anon

The problem is exactly what the error message says. The "header()" must be sent to the browser before ANYTHING else; even blanks, tabs, or any other HTML. This means you can not even have any blanks before your "<?php" tag.

-- Rich --

Anon

I not sure if your question has already been answered. I'm not sure but I think your question is how to prevent a duplicate client row from being inserted. If that's the case, make sure you have a unique key on table client. Column login would be a good choice. That way, if you tried to insert a row with the same login, you could trap the sql error and perform what you want.