data insertion

yvettesio

Hi please Help. I am new in PHP and confused in how to do the following scenario.

I am trying in insert data into my mysql database and it works my problem is everytime I click refresh, the same data is inserted again. What I want to happen is, after the data is inserted automatically the same form will load again but as a new form.

NogDog

You might want to do a redirect to the form page via the [man]header[/man] function upon successful completion of the update.

yvettesio

hi already did that i use this

header('location:i called the same page'); but still if i click refresh another entry added to my database

NogDog

You could do like this site does, which is redirect to a separate "success" page, which then uses a meta refresh tag in the <head> section to send you back to the form page:

insert_form.php:

// upon successful completion of the insert:
header('Location: http://www.yoursite.com/insert_success.html');
exit;

insert_success.html:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html lang='en'>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=ISO-8859-1'>
<meta http-equiv="refresh" content="1;url=http://www.charles-reace.com/">
<title>Insert Success</title>
</head>
<body>
<h1>Insert Success</h1>
<p>If you are not automatically returned to the Insert Form, please click the link below.</p>
<p><a href="http://www.yoursite.com/insert_form.php">Insert Form</a></p>
</body>
</html>

yvettesio

thank you ryan

bradgrafelman

Don't forget to mark this thread resolved.