# Extracting the Country from the IP Address:- How To?

## Get Coding

Now that we've got the database, we will move on to writing the ASP code.

Firstly, we must know how to get the IP Address of the Visitor. To do that, our code will be

 <% strIP = Request.ServerVariables("HTTP_REMOTE_ADDR") %>

The ServerVariables collection contains the combination of values that represent the HTTP headers sent from the visitor's browser to our server. By passing the " HTTP_REMOTE_ADDR" parameter to it, we request the IP Address of the visitor.
Through this, we will get an IP Address in the format xxx.xxx.xxx.xxx which may look like 108.89.128.147
But since our database have IP Numbers instead of IP Addresses, we will have to convert the IP Address into an IP Number.
To convert an IP Address into an IP Number, the formula is
A * (256*256*256) + B * (256*256) + C * 256 + D
for the IP Address A.B.C.D
So, for ease of things, we can use the following function to get an IP Number of an IP Address.

 <% Private Function ipAd2ipNum(ipA) strO = ipA pos1 = InStr(strO, ".") intA = CInt(Left(strO, (pos1-1))) strO2 = Mid(strO, pos1+1, len(strO)) pos2 = InStr(strO2, ".") intB = CInt(Left(strO2, (pos2-1))) strO3 = Mid(strO2, pos2+1, len(strO2)) pos3 = InStr(strO3, ".") intC = CInt(Left(strO3, (pos3-1))) intD = CInt(Mid(strO3, pos3+1, len(strO3))) intConvert = (intA*(256*256*256)) + (intB*(256*256)) + (intC*256) + intD ipAd2ipNum = Trim(intConvert) End Function %>

so, we can use this function as

 <% strIP = Request.ServerVariables("HTTP_REMOTE_ADDR") strIPN = ipAd2ipNum(strIP) %>

Thus we will get the IP Number of our IP Address. Now we are ready to query our ip2country database.

## You might also like...

### Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

### Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There are only two kinds of languages: the ones people complain about and the ones nobody uses”