Need a way to prevent user refreshing page - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

Fearghal · 01-17-2012, 03:19 PM

Hi everyone, I have a problem with a piece of code I have just written for my website and am hoping some genius here can help me out!

Basically I have a php script that when executed, will increase a database value by x. The value is received from a hook in the order system after an invoice has been paid.

Unfortunately, when refreshing the page the script repeats itself, and due to the way its written it increases the database value depending on what it is at the time its executed. For example:

Script executes -
Database value is Y -
Script adds X to Y -
Script calculates the new Y value and updates database -
Script ends -

If the user refreshes the script, they will be able to continuously repeat the database update adding X each time they refresh the page. I am only a beginner developer and have no idea how to stop this!

If anyone could suggest any methods of preventing this I would be very grateful!

Thanks

heads · 03-22-2012, 08:59 AM

Use a redirect page after Update Query....here is the function
function redirect($link)
{
if (! headers_sent())
{
header("Location: $link");
}
else
{
echo "<script language=Javascript>document.location.href='$link' ;</script>";
}
exit(0);
}

Cheers
John

tommeh · 04-24-2012, 11:34 AM

why not set a cookie when its been updated, and check for it