Storing IP location in Mysql database

[subho]

Hello all

I have a simple feedback form, from there the user inputs are getting stored in Mysql database.But I want to track my visitors IP location along with other inputs and store it into database as well. How to do it? A

ny help or tutorial would be appreciable.

Thanks in advance-

[wige]

IP addresses are generally stored as text because you can not store them as numbers without doing a lot of conversion to remove the decimals. On the form that is entering the information into the database, simply add the user IP from the environment variable, $_SERVER['REMOTE_ADDR'].

[Tech Manager]

You can follow Wige's advice and store the IP as a string (text). I prefer storing the IP address in decimal (integer) as it makes it easier to work with later.

I wrote a tutorial called Decimal and Binary Conversion of IP Addresses. But you can use MySQL commands to easily convert the data. For instance if you retrieved the IP you can use the inet_aton('$ip') command to convert the insert the IP Address ($ip) into decimal and then add the data into the database. You can convert the Decimal Address back to octets by using inet_ntoa.

[clonfran]

Would this help at all?

How-to create a simple PHP mail contact form with MySQL - The Tech Labs

[edhan]

Originally Posted by Tech Manager

You can follow Wige's advice and store the IP as a string (text). I prefer storing the IP address in decimal (integer) as it makes it easier to work with later.

I wrote a tutorial called Decimal and Binary Conversion of IP Addresses. But you can use MySQL commands to easily convert the data. For instance if you retrieved the IP you can use the inet_aton('$ip') command to convert the insert the IP Address ($ip) into decimal and then add the data into the database. You can convert the Decimal Address back to octets by using inet_ntoa.

Thanks! This is good resource as I never think of it. Now I can add this in my database for those login in my private access area.