Hello, please sign in or register
You are here: Home

Geo IP

Preface

Ever wondered "where on earth?"? This is simply splendiferous feature to include in your website where location is kinda important, and may effect the information you wish to provide your users... quite rightly the document describes a warm fuzzy feeling generated by introducing this into your website

Download

Download hostip_current.sql.gz from www.hostip.info, and extract the .sql file

Create Database and Tables

// SQL

CREATE DATEBASE geo

Load the sql file using the command line

// Command Line

shell>mysql\bin\mysql -e "source directory_location/hostip_current.sql" -u user -D geo -p password

... this takes a while, 0.5gb of space, and 258 tables. Extreme !?

Scripting up

The function here return the country code using the ADOdb database connection

Whoops! ... where is that code?

Comments

ninestab123
ninest123 One canada goose pas cher gucci outlet thing
Created 21/07/16
Title*
Comment

Prove you are not a robot

To prove you are not a robot, please type in the six character code you see in the picture below
Security confirmation codeI can't see this!
Contact
Name*
Email never shown*
Home Page

Author

Andrew Dodson
Since:Feb 2007

Comment | flag

Categories

Bookmark and Share