[SOLVED] Keeps inserting in table on refresh

[bobahad]

Hello guys,

 

I created a simple entry form, but the problem is everytime I refresh the page, it keeps adding the same values over and over again.

I just want it to insert it when Add is clicked. Please advice.

Thanks

 

//Query to insert in table

if (isset($_POST['add'])){

$query="INSERT INTO $Table (Type,Make,Model,Year,VIN,Color,Cost,Price,Bought,Link)

    VALUES ('$type','$make','$model','$year','$vin','$color','$cost','$sellingprice','$datebought','$logolink')";

   

 

  if(mysql_db_query($Database,$query,$Link)){

print("<FONT SIZE=\"3\" COLOR=\"Green\">");

print("The car was added successfully!\n");

print("</FONT>");

     

    } else{

   

print("<FONT SIZE=\"3\" COLOR=\"Red\">");

print("The car was not added!\n");

print("</FONT>");

      }

//Close connection

mysql_close($Link);

}

[kopytko]

Instead of

<?php
print("<FONT SIZE=\"3\" COLOR=\"Green\">");
print("The car was added successfully!\n");
print("</FONT>");
?>

use header function, like this:

<?php
header('Location: your.congrats.file');
exit;
?>

When you refresh page, post is being send again, because it's made to do this, so only way to avoid this, is reload page with header function.

In "your.congrats.file" you can place "The car was added successfully!" text and back link.

[bobahad]

so your.congrats.file can be something like addedsuccessfully.php with a link that goes back to addcar.php ?

[kopytko]

Yes. But remember to pass all your variables if you rely on them.

[bobahad]

Thank you