storing ip address and user agent

[veluit06]

hi i want to store user ip address and user agent (browser details), i write a coding for this but its not working correctly, ip address worked but user agent not showing correctly any one can please give me the solution.... for this method

 

<?PHP

$survey_ip = $_SERVER['REMOTE_ADDR'];

$survey_agent = $_SERVER['HTTP_USER_AGENT'];

 

$con = mysql_connect("localhost","root");

if (!$con)

  {

die('Could not connect: ' . mysql_error());

}

 

mysql_select_db("mysite", $con);

$s="INSERT INTO survey VALUES('$survey_ip','$survey_agent')";

if(mysql_query($s,$con))

{

echo "IP Stored";

}

else

{

echo "IP Not Stored";

}

 

?>

[rhodesa]

try this instead:

<?php
$con = mysql_connect("localhost","root")
  or die('Could not connect: ' . mysql_error());
mysql_select_db("mysite", $con)
  or die('Could not select DB: ' . mysql_error($con));
$survey_ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$survey_agent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']);
$s = "INSERT INTO survey VALUES('$survey_ip','$survey_agent')";
mysql_query($s,$con)
  or die('Failed to insert IP: ' . mysql_error($con));
echo "IP Stored";
?>

 

i added some more error checking and escaped the values before they are inserted

[djbuddhi]

mus be the problem in the database fields ,use tiny text field