when a user clicks refresh on my page, the sql that was set to insert on that page, inserts again, thus creating multiple entries for the same thing. Is there any way I can catch this, and stop if from happening? i am using if ($submit) to do the form processing... any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
multiple sql inserts on refresh
- Thread starter kpdvx
- Start date
vcherubini
Programmer
Well, after the user presses the submit button and goes to the page that inserts the SQL, have that page redirect him to somewhere else. On the page that inserts the SQL, say something like "You're stuff has been added. In 3 seconds, you will be fowarded to another page." And then add some code (Javascript or HTML) to foward him to another page in that amount of time. Thus, when he presses refresh, the page that refreshes will just be the page he was fowarded to.
Hope this helps.
-Vic vic cherubini
krs-one@cnunited.com
Hope this helps.
-Vic vic cherubini
krs-one@cnunited.com
- Thread starter
- #3
this code works fine for me
$succesfull=mysql_insert_id(); // get id from last insert
if ($succesfull > 1) {
print ("
<HTML>
<HEAD>
<TITLE>terug</TITLE>
<META HTTP-EQUIV=\"Pragma\" CONTENT=\"no-cache\">
<script language=\"javascript\">
function move(url)
{
window.location.replace(url);
}
move('yourpage.php3');
</script>
</head>
</html>
"
;
}
$succesfull=mysql_insert_id(); // get id from last insert
if ($succesfull > 1) {
print ("
<HTML>
<HEAD>
<TITLE>terug</TITLE>
<META HTTP-EQUIV=\"Pragma\" CONTENT=\"no-cache\">
<script language=\"javascript\">
function move(url)
{
window.location.replace(url);
}
move('yourpage.php3');
</script>
</head>
</html>
"
;}
LittleHavoc
IS-IT--Management
set a variable on that page when the query has been run
if ($query_run)
{
run query
$query_run=TRUE;
rest of page here....
}
else
{
echo "don't press refresh";
}
if ($query_run)
{
run query
$query_run=TRUE;
rest of page here....
}
else
{
echo "don't press refresh";
}
- Status
Similar threads
- Locked
- Question
- Locked
- Question