refresh issuse

slimjim

When I add a record, it adds fine, But when i hit refresh, it adds it again. How can i stop it from doing that.

<?

require "common.php";


$res="";

if($submit == "Add"){
	$urllink="http://".$urllink;

	$query="insert into quotes (clqoute, fontsize, randomname, url, clname, urlname, status) values ('$clqoute', $fontsize, '$randomname', '$urllink','$clname','$urlname','$status')";

mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");		

$res="Successfully added an record";

}
?>

stolzyboy

redirect the user to a different page after the page that does the inserting

Formpage->handlerpage->thankspage/confirmationpage

slimjim

Not sure if i understand you right. I don't want to redirect by clicking a link or button, Seems when ever i use :

redirectTo("addquote.php");

i get errors. I think i am not placing it on page in right place or something. Or maybe not using right code.

stolzyboy

to redirect using PHP you need to use

header("Location: pagetogoto.php");

but this has to be before any output to the browser, that is probably why you are receiving errors

or conversely you can have output, but for your first line of code (right after the opening <?), you need to use

ob_start();

that will suppress any header errors

slimjim

Can you show me where in my code i should put that, because it seems no matter where i do, i go right to the redirection page without even being able to add any record at all.

stolzyboy

well it would go like this

page with form and all your form stuff

then the page to submit to with the processing stuff like

insert into blah blah blah

after that somewhere put

header("Location: pagetogoto.php");

as long as the header is after your input stuff, it'll work

slimjim

Ok if you look at the code, it worked. But isnt there another way of redirecting to a page after a form is submitted?

<?

require "common.php";

if($submit == "Add"){
	$urllink="http://".$urllink;

	$query="insert into quotes (clqoute, fontsize, randomname, url, clname, urlname, status) values ('$clqoute', $fontsize, '$randomname', '$urllink','$clname','$urlname','$status')";

mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");		

header("Location: recordadded.php");//This is the added part and it worked

}

?>

stolzyboy

what kind of other way do you want, that is how PHP's redirecting works

slimjim

Ok is there a way to work so that after i hit submit, the page reloads, but i do not have the refresh problem ? but so that that a message saying the record was added, and without the refesh issue, or is it the way i have it now the best way ?

By the way I would like to say thank you for your help too, before i forget.

stolzyboy

the way i told you to have it is the way i do it, and it should work, it'll add the info and then redirect them to a page that says "record added" or whatever, and then if they hit refresh, they are just on the record added page so it won't resubmit the info