$HTTP_SERVER_VARS in Function (?)

[Anon]

Hi,

I'd like to write a function, which inserts everytime a page is opened an item in the log book.
I tried it with a function call insert_log().

$USER = $sesUser;
$PATH_INFO = $HTTP_SERVER_VARS["SCRIPT_NAME"];
$REMOTE_HOST = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$HTTP_SESSION_VARS = $HTTP_SERVER_VARS["HTTP_COOKIE"];
$HTTP_USER_AGENT = $HTTP_SERVER_VARS["HTTP_USER_AGENT"];
$sql = "insert into log99 (user,action,remote_addr,http_user_agent,http_session_vars) values ('$USER','$PATH_INFO','$REMOTE_HOST','$HTTP_USER_AGENT','$HTTP_SESSION_VARS')";
$conn = connect_to_mysqldb();
$ret = mysql_query($sql,$conn);
if (!$ret) echo mysql_error($conn)."<br>$sql";
//mysql_free_result($ret);
mysql_close($conn);

Problem: all vars from HTTP_SERVER_VARS-array are blank. However, inserting that code in each file - without calling the function - the script works.

What is wrong with that?

Thanx
-sebastian

[Anon]

function insert_log() {
do_session_register();
$USER = $sesUser;
$PATH_INFO = $HTTP_SERVER_VARS[\"SCRIPT_NAME\"];
$REMOTE_HOST = $HTTP_SERVER_VARS[\"REMOTE_ADDR\"];
$HTTP_SESSION_VARS = $HTTP_SERVER_VARS[\"HTTP_COOKIE\"];
$HTTP_USER_AGENT = $HTTP_SERVER_VARS[\"HTTP_USER_AGENT\"];
$sql = \"insert into log99 (user,action,remote_addr,http_user_agent,http_session_vars) values (\'$USER\',\'$PATH_INFO\',\'$REMOTE_HOST\',\'$HTTP_USER_AGENT\',\'$HTTP_SESSION_VARS\')\";
$conn = connect_to_mysqldb();
$ret = mysql_query($sql,$conn);
if (!$ret) echo mysql_error($conn).\"<br>$sql\";
//mysql_free_result($ret);
mysql_close($conn);
}

[gljaber]

change the beggining of the function so that it reads this:

function insert_log() {
global $HTTP_SERVER_VARS;
$USER = .....

glj

[Anon]

it still does not work with "global". I get blank fields in my database user those variables ($REMOTE_ADDR, HTTP_COOKIE...)

See the listing:
function insert_log() {
do_session_register();
global $USER;
global $PATH_INFO;
global $REMOTE_HOST;
global $HTTP_SESSION_VARS;
global $HTTP_USER_AGENT;
$USER = $sesUser;
$PATH_INFO = $HTTP_SERVER_VARS["SCRIPT_NAME"];
$REMOTE_HOST = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$HTTP_SESSION_VARS = $HTTP_SERVER_VARS["HTTP_COOKIE"];
$HTTP_USER_AGENT = $HTTP_SERVER_VARS["HTTP_USER_AGENT"];
$sql = "insert into log99 (user,action,remote_addr,http_user_agent,http_session_vars) values ('$USER','$PATH_INFO','$REMOTE_HOST','$HTTP_USER_AGENT','$HTTP_SESSION_VARS')";
$conn = connect_to_mysqldb();
$ret = mysql_query($sql,$conn);
if (!$ret) echo mysql_error($conn)."<br>$sql";
//mysql_free_result($ret);
mysql_close($conn);
}

[gljaber]

I don't know if multiple global statements will confuse PHP.
Try to just import the variables that are actually global, and put them all in one line

global $HTTP_SERVER_VARS, $ANOTHER_GLOBAL_VAR;

HTH

glj

[Anon]

I just just tried it again. The session var is not blank anymore. All other variables remain still blank.

SQL-commmand: "insert into log99 (..,..,..,) VALUES ('','','',...)

function insert_log() {
do_session_register();
global $USER,$PATH_INFO,$REMOTE_HOST,$HTTP_SESSION_VARS,$HTTP_USER_AGENT,$sesUser;
$PATH_INFO = $HTTP_SERVER_VARS["SCRIPT_NAME"];
$REMOTE_HOST = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$HTTP_SESSION_VARS = $HTTP_SERVER_VARS["HTTP_COOKIE"];
$HTTP_USER_AGENT = $HTTP_SERVER_VARS["HTTP_USER_AGENT"];

$sql = "insert into log99 (user,action,remote_addr,http_user_agent,http_session_vars) values ('$sesUser','$PATH_INFO','$REMOTE_HOST','$HTTP_USER_AGENT','$HTTP_SESSION_VARS')";
$conn = connect_to_mysqldb();
$ret = mysql_query($sql,$conn);
if (!$ret) echo mysql_error($conn)."<br>$sql";

mysql_close($conn);

sebastian
}

[Anon]

Perfect!
It works setting $HTTP_SERVER_VARS global!

Thank you!
s.