Library tutorials & articles
Extracting the Country from the IP Address:- How To?
By Amit Gupta, published on 13 Mar 2004
Page 4 of 6
- Introduction
- The Database
- Get Coding
- Running Query
- The Full Code
- Final Words & Resources
Running Query
As we've got the IP Number of the visitor's IP Address, we will now query the ip2country database to find out the Country of the visitor.
For this, first we connect to our ip2country database.
The connection to database is now open. We will now create the query & run it.
after running the query, we need to display the results. We can do so by
Thus it will display the IP Address & the Country of the Visitor. If the Country of the Visitor is not listed in the database, it will display the country as " unlisted".
Now, time for the full code in one piece.....
For this, first we connect to our ip2country database.
| <% strConString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" strConString = strConString & Server.MapPath("ip2country.mdb") Set objCon = Server.CreateObject("ADODB.Connection") objCon.Open strConString %> |
The connection to database is now open. We will now create the query & run it.
| <% strSQL = "select co_name from ip2c where ip_from<=" & strIPN strSQL = strSQL & "and ip_to>=" & strIPN Set objRs = Server.CreateObject("ADODB.Recordset") objRs.Open strSQL,objCon %> |
after running the query, we need to display the results. We can do so by
| <% If NOT(objRs.EOF) OR NOT(objRs.BOF) Then strCountry = objRs.Fields("co_name") %> Your IP Address is :- <%=strIP%><br> Your Country is :- <%=strCountry%> <% Else %> Your IP Address is :- <%=strIP%><br> Your Country is :- <b>unlisted</b> <% End If objRs.Close objCon.Close Set objRs = nothing Set objCon = nothing Set strSQL = nothing %> |
Thus it will display the IP Address & the Country of the Visitor. If the Country of the Visitor is not listed in the database, it will display the country as " unlisted".
Now, time for the full code in one piece.....
Related articles
Related discussion
-
Read eMails from Outlook express using ASP
by kumaravelu (1 replies)
-
Help to Call ASP function from onclick event in HTML to pass an array
by vka (0 replies)
-
Binary Studio | software development outsourcing Ukraine
by shane124 (4 replies)
-
Variable In Vb.Net
by chia (0 replies)
-
ideas in building a captive portal
by sjranjan (2 replies)
Related podcasts
-
Scott Guthrie
Scott catches up with Scott Guthrie in an interview covering Ajax, Asp 2.0, extender controls, CSS adapters and more.
Thanks for the comment..i really like this..
Get your Term papers done - FlashPapers.com
You can check Country, City, ZIP, Longitude and Latitude in C# and visual basic (VB.NET). There is source code for .NET GeoIP: http://tools.webmastermafia.com
You can use it for FREE. It is very easy, just 2 lines of code.
thanks a lot...it would me more useful if you post it in VB.NET..or C# ..thanks in advance
I just wrote a lasted sample which describes how to get countries and city from IP address and the sample contains a IP database.If you want to get the sample code,Please visite http://www.treaple.com/bbs/index.php or http://www.treaple.com/bbs/thread-17-1-1.html
First of all,you should get a database which includes all countries IP details.
and then convert IP address to decimal to find the exact country name by the decimal .
I hope that this article can be used for you
http://www.treaple.com/ArticlesDetails.aspx?id=55
cheer.
Though this is a brilliant piece of code, can u guys please explain that what are the datatypes used in the function ipAd2ipNum and also it gives me an error if i use the datatypes like integer, int32, int64...Please reply asap Rohit![Smiley Face [:)]](/emoticons/emotion-1a.gif)
Thanks a lot.![Smiley Face [:)]](/emoticons/emotion-1a.gif)
![Crying [:'(]](/emoticons/emotion-9.gif)
Hi,
First i woud like to thank you fom the bottom of my heart, on this wounderful, well orginized article, it really helped me a lot, i have been looking for a one like this for a long time
THANX A LOT
btw, i guese you have forgotten about the database anyway,
i'll do u simple favor for you and others as little return for this article
the link for the latest CSV Values
http://ip-to-country.webhosting.info/downloads/ip-to-country.csv.zip
Once again, Thanx a lot
Best Regards
How to download the MS Access database?
If your wondering why "strIP = Request.ServerVariables("HTTPREMOTEADDR")" returns no IP address change it too "strIP = request.servervariables("REMOTE_ADDR")" and this will now work !
This thread is for discussions of Extracting the Country from the IP Address:- How To?.