DISQUS

Hello! Newest Industry is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

newestindustry.org/ Jump to website »

Subscribe
- New Comments
Community
Top Commenters
- Stephen Pierzchala
  31 comments · 1 points
- Janette Toral
  2 comments · 5 points
- rob crumpler
  2 comments · 1 points
- David Cancel
  1 comment · 2 points
- dbarefoot
  1 comment · 1 points
Popular Threads
Recent Comments
- Cool. Now, if it's not supported by anyone, it should get pulled from the RFC. And now that the browser engines are almost all abstracted from the browser that wraps around them, maybe it's...
  4 days ago by Stephen Pierzchala
  
  in Google Chrome: One thing we do know… (HTTP Pipelining)
- You're wrong. Chrome could pipeline, nothing in Webkit prevents this. Chrome doesn't use the CFNetwork loader nor does WebKit marry the browser to any given network / HTTP stack, just look...
  4 days ago by Mark Pauley
  
  in Google Chrome: One thing we do know… (HTTP Pipelining)
- Lee Valley Tools carry the 3mm Fix pencil and parts.
  3 weeks ago by iamuarme
  
  in Caran D’Ache Fixpencil: Where do you buy them?
- Found the problem - it wasn't the theme, it was a rogue plugin that was borking the HTML. Likely a tag that wasn't being properly closed. <sigh> smp
  1 month ago by Stephen Pierzchala
  
  in Browser Wars: The Slow Rise of Internet Explorer 8
- Ugh. Time to find a browser compatible Wordpress theme. smp
  1 month ago by Stephen Pierzchala
  
  in Browser Wars: The Slow Rise of Internet Explorer 8

Newest Industry

Chronicles of a Crazy Canuck

Jump to original thread »

Geographic IP database using PERL, PHP and MySQL

Started by Stephen Pierzchala · 10 months ago

Targeting Web site content to the specific visitors who view the site is a very important marketing advantage. Being able to track incoming visitors by the country that they originate from is an additional item that can assist companies in ensuring that visitors are presented with relevant content. ... Continue reading »

10 comments

kanquona
2 years ago

Thanks a lot!! I really appreciate this wonder piece of knowledge. I am indebted to you for sharing it with us.

Thanks again
Kanquona
http://www.wertex.org

reply

RevJoe
1 year ago

Can you share a link to where the texet files can be found on ARIN's website?

reply

smp
1 year ago

I use these Addresses:

ftp://ftp.arin.net/pub/stats/apnic/delegated-apnic-latest
ftp://ftp.arin.net/pub/stats/ripencc/delegated-ripencc-latest
ftp://ftp.arin.net/pub/stats/arin/delegated-arin-latest
ftp://ftp.arin.net/pub/stats/lacnic/delegated-lacnic-latest
ftp://ftp.afrinic.net/pub/stats/afrinic/delegated-afrinic-latest

Have fun everyone!

smp

reply

iddl2
1 year ago

help me to make, visitor ip convert to country
santranpisak@yahoo.com
www.spktt.com

reply

Jeff W
1 year ago

When attempting to connect to the FTP sites above, I am prompted for login credentials. Anonymous login does not seem to work for me. Is the data publicly available or do I need a subscription of some sort to get the registry data from the FTP sites?

Thanks,
JW

reply

Bhrath Gandhi
1 year ago

Thank you man... That was a step by step procedure to a complete ip-tracker code!!! great work...

reply

Jakob
5 months ago

I am doing something simliar to this to generate whitelist IP-list based on country of origin. I am troubled by the fact that I have 4.751 rows in my database, which have a country code of EU. Anyone know of a way of determining what country it really is?

reply

Stephen Pierzchala
5 months ago

Jakob:

From just the registrar data, you will unlikely be able to do this. However, there are a number of commercial products that may be able to assist you in narrowing these down.

smp

reply

Jakob
5 months ago

Well yes, but the idea was to make a do-it-yourself solution using public and free information. I have all the pieces in place, except for the one "country code" that does not conform to the standard ISO 3166.

reply

Stephen Pierzchala
5 months ago

Unfortunately, all the data does exist, but it is in the whois data for the blocks in question. This is a manual process that I chose not to undertake due to its complexity and my lack of programming skils.

reply