[RESOLVED] Store user's ip

Robert_B_

Hello,

I'm using this code to store this info in that dbase before my <html> tag of index.php page but it won't store anything.


 $vis_browser = $HTTP_USER_AGENT;
 $vis_ip = $REMOTE_ADDR;

 $db = mysql_connect("host" , "user" , "password");
 mysql_select_db("dbase" , $db);

 $insert_sql = "INSERT INTO stats(ip, browser, received) VALUES('$vis_ip', 'vis_browser', NOW())";

 $results = mysql_query($insert_sql);

Where should I put this code if is correct to record this info with out a form. I know there is a bunch of free site stats but I just trying learn. 😉

Thanks

dagon

check the $_SERVER array instead of $HTTP_USER_AGENT, $REMOTE_ADDR

jsut use print_r($_SERVER); to see what's been set

Robert_B_

Both ways echo my browser/operating system and my ip

 //$vis_browser = $HTTP_USER_AGENT;
 //$vis_ip = $REMOTE_ADDR;

 $vis_browser = $_SERVER['HTTP_USER_AGENT'];
 $vis_ip = $_SERVER['REMOTE_ADDR'];

<body>

  <?php echo $vis_browser; ?> <br />
  <?php echo $vis_ip; ?> 

</body>

leatherback

Do:
$results = mysql_query($insert_sql) or die(mysql_error().$insert_sql);

instead of:
$results = mysql_query($insert_sql);

and you will probably be told what goes wrong.

Robert_B_

Thanks alot leatherback!!
Was a mispell in one of my columns.

Thank you all for this site.