How can I query the IP address of subscribers?

Question

I'm using PHP and MySQL. How can I query the IP address of subscribers?

Do not use IP address for anything like authentication etc.? It is rather meaningless as some routers use the same IP address for multiple machines. This is especially true for some ISPs. Also they can be dynamically allocated. — Ed Heal, Feb 26 '14 at 04:00

score 1 · Answer 1 · answered Feb 26 '14 at 03:53

1

You can use this

echo $_SERVER['REMOTE_ADDR'];

answered Feb 26 '14 at 03:53

Vikas Umrao

2,800
1
15
23

score 0 · Answer 2 · answered Feb 26 '14 at 03:53

this will display the ip address

echo $_SERVER['REMOTE_ADDR'];

if you want to store the ip address of the users, use this

$ipaddress = echo $_SERVER['REMOTE_ADDR'];


mysql_query("insert into table set ipaddress = '$ipaddress' where userid = '$userid' ");

score 0 · Accepted Answer · edited Aug 17 '14 at 04:37

function get_client_ip() 
 {
      $ipaddress = '';
      if (getenv('HTTP_CLIENT_IP'))
          $ipaddress = getenv('HTTP_CLIENT_IP');
      else if(getenv('HTTP_X_FORWARDED_FOR'))
          $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
      else if(getenv('HTTP_X_FORWARDED'))
          $ipaddress = getenv('HTTP_X_FORWARDED');
      else if(getenv('HTTP_FORWARDED_FOR'))
          $ipaddress = getenv('HTTP_FORWARDED_FOR');
      else if(getenv('HTTP_FORWARDED'))
          $ipaddress = getenv('HTTP_FORWARDED');
      else if(getenv('REMOTE_ADDR'))
          $ipaddress = getenv('REMOTE_ADDR');
      else
          $ipaddress = 'UNKNOWN';

      return $ipaddress; 
 }

How can I query the IP address of subscribers?

3 Answers3

Source