That is my goal to only use only file and I do use a lot of IF statements.
I will try this. I have not used the Header() function. I will take a look
at it. If you have an example, that would be great.
-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 10:06 AM
To: Crane, Christopher
Subject: Re: [PHP] Page Refresh
Importance: High
i don't undertand why you have the meta refresh in there, but the porblem
you have is simular to any one who clicks refresh on their browser...
essentialy, what you want to do is after the DB insert, use a header()
redirect to a blank form -- steps might look like:
1. form.php (blank) [click submit]
2. validate.php
a) if not ok redirect to form.php (with entered data)
b) if ok, insert into DB redirect to form.php (blank)
In other words, form.php doesn't actually print any data to the screen, it
just evaluates the entered data, and acts upon it.
The value of this is that if the user never sees validate.php, they can't
refresh it (or have a meta refresh), so the data can't be inserted more than
once via a refresh.
if they refresh the form.php, the DB will not be affected.
If you're cleaver with if() statements and other control structures, you can
actually achieve this effect with only one file (form.php)... but that's
another story :)
Have fun,
Justin French
Creative Director
http://Indent.com.au
on 23/04/02 11:47 PM, Crane, Christopher ([EMAIL PROTECTED]) wrote:
I use a template page and then split out the middle of the page to do my
PHP
stuff depending on a variable I pass to it.
I have a problem I hope someone can help me on.
The template page has a meta refresh in the header set for 60 secs. One of
the things this page does is insert data into a MySQL database. The
problem
is once it is finished it displays the same form used to enter the data in
the MySql database for another record to be added if you wish...here comes
the problem. After the first insert, the data form is redisplayed, but
after
the 60 secs and the refresh takes place it runs the last insert again. If
the user just leaves that page up, every 60 secs it will insert another
record every 60 secs.
I was thinking there may be a mechanism to redirect to a different URL
after
the database insert, but I do not know how to do that. I want to keep the
meta refresh because there is a lot of dynamic data displayed on the
template page that changes. Which is the reason for the Meta Refresh to
begin with...
Christopher J. Crane
Network Operations Manager
IKON Office Solutions
860.659.6464
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php