Refresh problem

[seralasu]

Hi,
I have refresh problem.When user does refresh or clicks F5 then form variables again posting. It crates same a lot of inserts. I don't know How to solve it.

[ak1dnar]

I think you are using a html form to submit the data and there might be a submit button.
Let's assume that submit button is like this.

[HTML]<input type="submit" name="sub" value="Send">[/HTML]

then from your php side use like this.

[PHP]if ($_POST['sub'])
{
// insert current coding inside this if block for getting values from html form and //inserting it to the database
}[/PHP]

php will execute only user cllicks the sub button .

[seralasu]

I have already done it. My code sample;
Submit buton definition
<input type="submit" name="kaydet" value="Kaydet">

insertion side

if($_POST['kaydet'] )
{
// I'm taking POST variables and inserting to database
}

[ak1dnar]

Good for you. :D

[Purple]

Hi seralasu,

I am assuming you are still having a problem with this.. a suggestion is to use Javascript on the onClick event of your submit button and set a hidden field on your form and test that rather than the submit button - the onClick event will only fire when clicked - ie it does not fire on refresh / F5..

the following code demonstrates using a basic javascript alert..
[PHP]
echo "<form name=\"test\" action=\"".$_SE RVER["PHP_SELF"]."\" method = \"post\">
<input type=\"submit\" name=\"kaydet\" value=\"Kaydet\ " onClick=\"javas cript:alert('he re');\"></input></form>";
print_r($_POST) ;
[/PHP]

[subash]

Hi,

Please check the thread http://www.thescripts. com/forum/thread576526.ht ml

Subash :)

[Purple]

Hi Subash,

I don't think the thread you referenced answers the initial issue - the problem experience is caused by hitting refresh or F5 on a form using a method of post - basically the form is submitted every time the form is refreshed, F5 is hit or the submit button is pressed..

Rgds Purple

[pbmods]

Easiest way I can think of to prevent this is to set up some unique keys in MySQL.

For example, suppose you had a table that looked something like this:

mysql> DESCRIBE `Data_Categories`;
+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| categoryid | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment | 
| desc       | varchar(64)         | NO   |     |         |                | 
+------------+---------------------+------+-----+---------+----------------+
 

Obviously, it wouldn't be useful to have a bunch of duplicate categories (this is an example; bear with me). So we would want to add a unique constraint so that every category has a different name.

To set up a unique key:

ALTER TABLE `Data_Categories` ADD UNIQUE KEY `catName`(`desc`);
 

The `catName` is just the name of your key and can be just about anything you want it to be. You put the name of the column(s) you want constrained inside the parenthesis.

Once the unique is in place, attempting to insert a duplicate row will fail:

mysql> INSERT INTO `Data_Categories` (`desc`) VALUES('Tester');
Query OK, 1 row affected (0.00 sec)
 
mysql> INSERT INTO `Data_Categories` (`desc`) VALUES('Tester');
ERROR 1062 (23000): Duplicate entry 'Tester' for key 2
 

[EDIT: Just to make things complicated, you can put a constraint on more than one column in the table. For example, if you used:

ALTER TABLE `Data_Categories` ADD UNIQUE KEY `parentData`(`parent`, `desc`);
 

(assuming that `Data_Categorie s` also had a `parent` field)

Then an INSERT would only fail if you tried to add a row with the same `parent` AND `desc` as an existing row, but would still allow the INSERT if only one of the fields matched.]

[seralasu]

Hi,
Thanks for all replies. I will try them.

[paja]

To AJAXRAND (sorry - I could not post this as a reply to your comment)

It does not work. Your $_POST['sub'] will be still there (the form will be sent again with F5 - refresh).

Have a try to add at the end of your PHP script this:
echo "<PRE>POST :";
print_r($_POST) ;
echo "</PRE>";

Paja