php mysql REMOTE_ADDR not working

unwashed potato! · 10 Oct 2010 at 21:48

i'm trying to store the visitors ip address in a mysql table but it's not coming out correclt some reason. this is roughyl what i have...

$ip = $_SERVER['REMOTE_ADDR'];

ip is a varchar in the table.

what i end up with everytime is ::1

am i doing something wrong? my error404 checking emails me the ip address of the user and that is correct so unsure what's making this incorrect.

Dj_Jestar · 11 Oct 2010 at 11:04

It's using IPv6.

SMB30 · 11 Oct 2010 at 11:44

As above. Just force your web server to operate on IPv4 addresses only.

unwashed potato! · 11 Oct 2010 at 16:16

SMB30 said:
As above. Just force your web server to operate on IPv4 addresses only.

how would i do that and would it not be better to make the script read IPv6 so it works locally and on the web server?

SMB30 · 11 Oct 2010 at 23:36

Well if it's hosted you'll have to ask your hosts I should imagine.

Otherwise it will be your apache or IIS config.

There should be a class already written for IPv4 - IPv6 conversion which is what you'll need I should imagine.

unwashed potato! · 11 Oct 2010 at 23:59

it isn't hosted but will be. at a guess then as when the file is hosted i get sent emails of 404 errors with the ip address and they come out fine, this will work when hosted aswell?

Mattus · 12 Oct 2010 at 04:01

It looks to me like the script is working fine.

::1 is localhost - it's the IPv6 equivalent of 127.0.0.1. If you're running the script on the same machine which is hosting it, and that system is using IPv6 addressing, the visitor IP will come out as ::1. So the script is doing what it's supposed to do. When it's hosted, your visitors will have normal IPv4 addresses which will also be stored correctly.