Ad:

PHP Discussion Thread
Unsolved
Views: 1175

Aug 31st, 2010

How to stop sending data on refresh

Expand Post »

HI All

I am relatively new to PHP and am in the processing of developing a site making use of PHP and MySQL. The problem I am experiencing is that when I refresh Internet Explorer, the data that was processed by a form is resubmitted to the database - can anyone tell me what the correct process is to avoid having this happen. The only thing that comes to mind is to, after the processing is complete, redirect to another screen - ultimately I would like to avoid doing that.

Any ideas?

Thanks in advance

Shiv

Similar Threads

Send data on a serial port in C++
Problem with sending data over tcp/ip in Python
reading from serial port way too slow (C++) in C++
Need some help sending data in C#
Forms: How do I use 2 buttons for sending the data each to different pages? in PHP

designer_shiv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jun 2010

Permalink

Aug 31st, 2010

Re: How to stop sending data on refresh

You might want to implement a session token or javascript redirect. A session token gets implemented before page execution and on page execution it gets destroyed. And the javascript way has its obvious implementations. Also, your database could assist in this if you are inserting the unique value which to compare against.

EverWebby

Reputation Points: 11

Solved Threads: 5

Light Poster

Offline

46 posts
since Jan 2010

Permalink

Sep 1st, 2010

Re: How to stop sending data on refresh

Always try to practice with header.

PHP Syntax (Toggle Plain Text)
<?
	if(isset($_REQUEST['submit']))
	{
		/* ----------
		   your code 
		 ------------ */
		 header("Location:page.php");
		 exit;
	}
?>
<?
	if(isset($_REQUEST['submit']))
	{
		/* ----------
		   your code 
		 ------------ */
		 header("Location:page.php");
		 exit;
	}
?>

Because if there is no header and you press refresh then form will be resubmitted.

vibhadevit

Reputation Points: 154

Solved Threads: 162

Master Poster

Offline

791 posts
since Apr 2010

Permalink

Sep 1st, 2010

Re: How to stop sending data on refresh

You are absolutely right EverWebby. I have encountered the same problem before and I made use of the following options:

1. I was storing a unique ID in the mysql database and what I did is that if the page is refreshed, I would check on the database if this ID has been recorded before. If so I then redirected the user to another page. But Mysql queries are expensive to make, so I will encourage you to use redirection where possible:

2. To implement redirection in PHP you user:

PHP Syntax (Toggle Plain Text)
header("location:http://www.mywebsite.com/index.php");
exit;
header("location:http://www.mywebsite.com/index.php");
exit;

In this case I redirect the user to my default index.php page.

Hope it helps :-)

Last edited by sithembisophp; Sep 1st, 2010 at 3:33 am.

sithembisophp

Reputation Points: 10

Solved Threads: 3

Newbie Poster

Offline

14 posts
since Aug 2010

Permalink

Sep 2nd, 2010

Thanks

Thank you for your suggestion,

designer_shiv

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Jun 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Looking for help on output rows in a table

Next Thread in PHP Forum Timeline: Can't override the __doRequest function from the SoapClient class

DaniWeb Message

Cancel Changes

User Name
Password