referer url

[corillo181]

why every thing is set into the table but not the refere url... i got this code in all the pages.

<?php
$reff=$_SERVER['HTTP_REFERER'];
if(!isset($_SESSION['online'])){
mysql_query("INSERT INTO online(session_id,activity, ip_address, refurl, user_agent)VALUES('".session_id()."','now()','".$_SERVER['REMOTE_ADDR']."','".$reff."','".$_SERVER['HTTP_USER_AGENT']."')");

$_SESSION['online']="online";

}else{
    
if(isset($_SESSION['user_id'])){

@mysql_query("UPDATE online SET activity=now(), member='y' WHERE session_id='".session_id()."'");
    } 
}

if(isset($_SESSION['online'])){        
@mysql_query("UPDATE online SET activity=now() AND refurl='$reff' WHERE session_id='".session_id()."'");
} ?>
[code]

[/code]

[per1os]

Spelling it right can help:

 

$reff=$_SERVER['HTTP_REFERRER'];

 

Also on a side note, that field may not always be populated or correct as it is sent by the client.

[corillo181]

the php manual says is only one r

[pocobueno1388]

Spelling it right can help:

 

$reff=$_SERVER['HTTP_REFERRER'];

 

Also on a side note, that field may not always be populated or correct as it is sent by the client.

 

Actually the Manuel has it spelled "HTTP_REFERER"

http://www.php.net/manual/en/reserved.variables.php

 

EDIT: Beat to it

 

Frost is probably right about it just not being populated. Try echoing to the screen to see if it prints anything.

[corillo181]

also if i try to echo $reff it does echo the previous page, but when i try to insert it into mysql it doesn't populate at all and every field is set correctly.

[pocobueno1388]

Try changing this line:

mysql_query("INSERT INTO online(session_id,activity, ip_address, refurl, user_agent)VALUES('".session_id()."','now()','".$_SERVER['REMOTE_ADDR']."','".$reff."','".$_SERVER['HTTP_USER_AGENT']."')");

 

To this:

mysql_query("INSERT INTO online(session_id,activity, ip_address, refurl, user_agent)VALUES('".session_id()."','now()','".$_SERVER['REMOTE_ADDR']."','".$reff."','".$_SERVER['HTTP_USER_AGENT']."')")or die(mysql_eror());

 

What field type do you have the column set to in the database?

[corillo181]

varchar is the field

[pocobueno1388]

Did you try the query I gave you? That should return the error.

[corillo181]

it returns no errors

[per1os]

The problem is in the update query.

 

<?php
if(isset($_SESSION['online'])){        
mysql_query("UPDATE online SET activity=now(), refurl='$reff' WHERE session_id='".session_id()."'") or die(mysql_error());
} 

 

I highly suggest not using those @ symbols, they screw you up especially when you are trying to fix something that is broken. The update query does not use AND it takes a comma to separate fields.

[corillo181]

yeah i removed it jus tnot, but the reff stills echo out on the page, but it does not goes into mysql.

[per1os]

What is the size of the varchar field?

[corillo181]

255 unsigned

[per1os]

The unsigned part is the error, it is expected a numeric type data. Change it to not be unsigned and try it again.

[corillo181]

no my bad is not unsigned.. lol i looked at the wrong column every thing is properly formatted.