<!-- Collection of code snippets by Arne Vajhøj -->
<!-- (from articles on eksperten.dk / vajhoej.dk written sometime between 2004 and now) -->
<?php
/* START CONFIGURATION */
define('DB_SERVER',"localhost");
define('DB_USERNAME',"root");
define('DB_PASSWORD',"");
define('DB_DATABASE',"Test");
/* END CONFIGURATION */
function db_import($csvfnm,$fromcol,$tocol,$countrycol,$tblnam) {
    $con = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
    mysql_select_db(DB_DATABASE) or die(mysql_error());
    mysql_query("DROP TABLE $tblnam", $con);
    mysql_query("CREATE TABLE $tblnam (id INTEGER NOT NULL, ip1 NUMERIC(10,0), ip2 NUMERIC(10,0), country CHAR(2), PRIMARY KEY(id))", $con) or die(mysql_error());
    mysql_query("CREATE INDEX ixip1 ON $tblnam (ip1)", $con) or die(mysql_error());
    mysql_query("CREATE INDEX ixip2 ON $tblnam (ip2)", $con) or die(mysql_error());
    $fp = fopen($csvfnm, "r");
    $n = 0;
    while(!feof($fp)) {
        $line = fgets($fp);
        if(strlen($line) > 0) {
            $n++;
            $fields = split(",", $line);
            $ip1 = str_replace('"','',$fields[$fromcol-1]);
            $ip2 = str_replace('"','',$fields[$tocol-1]);
            $country = str_replace('"','',$fields[$countrycol-1]);
            mysql_query("INSERT INTO $tblnam VALUES($n,$ip1,$ip2,'$country')", $con) or die(mysql_error() . "\n#" . $line . "#");
        }
    }
    fclose($fp);  
    mysql_close($con);
}

db_import('ip-to-country.csv',1,2,3,'whi');
db_import('GeoIPCountryWhois.csv', 3, 4, 5, 'mm');
print "Done\n"
?>