[PHP] Refreshing page after form submission

[S.D.Price]

Hi, I have a form which when submitted adds a record to a DB. However if
the user clicks back it resubmits the same record.

I have tried using cache control to no avail :

header (Expires: Mon, 26 Jul 1997 05:00:00 GMT);
header (Last-Modified: . gmdate(D, d M Y H:i:s).  GMT);
header (Cache-control: no-store, no-cache, must revalidate);
header(Cache-control: post-check=0, pre-check=0, false);
header (Pragma: no-cache);
session_cache_limiter(nocache);

I also tried testing for the presence of a submit button so if the user
enters data submits the form and clicks back the page will refresh.

?php 

if ($_POST['submit']) { 
echo META HTTP-EQUIV='refresh' CONTENT='0; URL=$PHP_SELF';
} else { 
} 
?

The problem is I need to display a confirmation message after the user
submits, and with this technique the page always redisplays the (empty)
form after submission.

Any ideas?



Steve

RE: [PHP] Refreshing page after form submission

[S.D.Price]

Thanks this was the best solution I used this code as part of form
validation.

// query to check record has not already been added by comparing
submitted title with title of last record
$query_gnewsid_unique = SELECT MAX(newsid) AS newsid FROM
tblnews;

// execute query
$result_gnewsid_unique = mysql_query($query_gnewsid_unique);

$row_gnewsid_unique = mysql_fetch_array($result_gnewsid_unique);
$newsid_unique = $row_gnewsid_unique['newsid'];


// query to extract last title from tblnews 
$query_gtitle_unique = SELECT title
FROM tblnews
WHERE newsid = $newsid_unique; 
$result_gtitle_unique = mysql_query($query_gtitle_unique);

$row_gtitle_unique = mysql_fetch_array($result_gtitle_unique);
$title_unique = $row_gtitle_unique['title'];



if ($title == $title_unique) {  
$message_unique = You have already entered this record.;  
$unique = TRUE;
}


Steve

-Original Message-
From: Burhan Khalid [mailto:[EMAIL PROTECTED] 
Sent: 17 December 2004 13:07
To: S.D.Price
Subject: Re: [PHP] Refreshing page after form submission


S.D.Price wrote:
 Hi, I have a form which when submitted adds a record to a DB. However 
 if the user clicks back it resubmits the same record.
 
 I have tried using cache control to no avail :
 
 header (Expires: Mon, 26 Jul 1997 05:00:00 GMT);
 header (Last-Modified: . gmdate(D, d M Y H:i:s).  GMT); header 
 (Cache-control: no-store, no-cache, must revalidate);
 header(Cache-control: post-check=0, pre-check=0, false); header 
 (Pragma: no-cache); session_cache_limiter(nocache);
 
 I also tried testing for the presence of a submit button so if the 
 user enters data submits the form and clicks back the page will 
 refresh.
 
 ?php
 
 if ($_POST['submit']) {
 echo META HTTP-EQUIV='refresh' CONTENT='0; URL=$PHP_SELF';
 } else { 
 } 
 ?
 
You can try and check if the user's information already exists in the 
database, then display an appropriate message.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php