hit F5 refresh triggers again the query

cp75 · #1 (**permalink**) September 10th, 2008, 02:58 PM

When i hit the F5 to refresh the page, sql statement in that page runs again. It means last insert, update or delete process is triggered again. How can i solve this problem?

urtrivedi · #2 (**permalink**) September 17th, 2008, 03:13 AM

You need to use cookies both in javascript and php
<?
  if ($_COOKIE['pagename_displayed']==0) //if page is not displayed then only execute
   {
       //insert,update, statement
      //this portion will only exeucte once, it will not execute on F5, when user submit form then we manual set cookie to 0 and then only this portion will execute. Also learn cookies in javascript following javascript code is just a place holder.
  }
?>
<html>

<script language=javascript>
function submit()
{
  //reset cookie meansm, page is not displayed
    setcookie('pagename_displayed',0);
/*setcookie is not inbuild javascript function you need to create function after learing handling cookies in javascript*/

    docuent.frm.submit();
}
</script>

<body>
<form>
<input>....................

</form>
</body>

<script language=javascript>
  setcookie('pagename_displayed',1);//we are setting page is displayed
</script>
</html>

urt

Help yourself by helping someone.

surendran · #3 (**permalink**) September 25th, 2008, 01:12 AM

hi,
then use session
start a session before insert page,
check the session before insert command write, then make the session false.
like this.

1.php
$_SESSION['u']=true;

2.php
if($_SESSION['u']==true){
//insert statment
$_SESSION['u']==false;
}

surendran
(Anything is Possible)
http://www.suren.info
http://ssuren.spaces.msn.com

Need to download code?

Navigation