[SOLVED] avoid dump......

[thenature4u]

when the user is refreshing the page the same data(data type is text) is again inserting into the database...how to avoid it..... 

 

 

[~n[EO]n~]

 

First do not allow blank values.

Second, after saving clear the form fields.

Third, if you refresh, show him the message "Please fill something...."

[phpQuestioner]

you could unset the variables:

 

<?php

if (!isset($_POST['mySubmitButton'])) {
unset($foo1, $foo2, $foo3); // add each variable you want to unset
header("Location: ". $_SERVER['PHP_SELF'] ."");
exit;
}
else if (isset($_POST['mySubmitButton'])) {
// mysql update or insert here
echo "Thank You Data Has Been Received\n";
}

?>

<form action="<?php echo ". $_SERVER['PHP_SELF'] ."; ?>" method="post">
<!-- Add Input Fields Here -->
<input type="submit" name="mySubmitButton" value="Send">
</form>

[tapos]

Try this

<?php
if (isset($_POST['mySubmitButton'])) {
// mysql update or insert here
header("Location: ". $_SERVER['PHP_SELF'] ."");
exit;
}

?>

<form action="<?php echo ". $_SERVER['PHP_SELF'] ."; ?>" method="post">
<!-- Add Input Fields Here -->
<input type="submit" name="mySubmitButton" value="Send">
</form>

 

Hope this will work.

 

Thanks

--

Tapos Pal

 

[thenature4u]

form is there in one php file and mysql insertion is there in another php file.....how to use the above the code....

 

because same form and mysql insertion are there in the same file.....iam unable to understand..

 

thankyou in advance