self redirection with PHP_SELF

[secici]

I have a code like following:

$SELFPAGE = $_SERVER['PHP_SELF'];

if (substr($_SERVER['HTTP_REFERER'], -11) == "clients.php") {
  header("location: $SELFPAGE");
  }

I want to use this code to avoid common multiple posts problem which is caused by the users' refresh/F5 command to the web browser. And once it works I think it can be used for many purposes.

But the code above causes my Firefox to complain like "redirection limit is exceeded". I think this is because of an infinite loop; but the code doesn't look to be an infinite loop.

Any help will do me a great favor.

Thanks.

[Moharo]

hey

in order to avoid multiple posts problem (F5), you should do something like this:

<?php

//create sql string for data insertion
//$conn is a connection identifier

$sql = "insert into blablabla values (bla, bla)";

if(mysql_query($sql,$conn))
{
header("location: anything.php");
exit;
}

?>

the reason why your code is "looping" is the fact that the 'if' statement is always true, meaning it will redirect forever....

you could provide some more information on how and where the redirect should go....

😃 😃

[secici]

I have sold the problem using two .php files. One deals with SQL connection and the other displays the conclusion message.

Self redirection could have been a more compact solution. And as I said before, it could be used for many other purposes. But I wouldn't choose to make an extra db query for that.