GEOIP

k_miya PC関係, お仕事関係

GEOIPの使い方マニュアル

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

example.code


// SQL

CREATE DATEBASE geo

Load the sql file using the command line

example.code


// Command Line

shell>mysqlbinmysql -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

example.code

<?php

echo GeoIPCountry($_SERVER[‘REMOTE_ADDR’]);

function GeoIPCountry($ip){

global $c; // the ADOdb database connection class

$a = explode(‘.’, $ip);

$q = “SELECT code FROM geo.ip4_”.$a[0].” a LEFT JOIN geo.countries b ON (b.id = a.country) WHERE b = “.$a[1].” AND c = “.$a[2].“”;

return $c->GetOne($q);

}

?>

GEOIP