Miscellany

<? 
define("SOURCE_FILENAME", "ip-to-country.csv"); 
define("SEPERATOR_COL", "\,"); 
define("SEPERATOR_ROW", "\n"); 



mysql_connect("localhost", "test", "test"); 
mysql_select_db("test"); 
mysql_query("DELETE FROM iptocountry") or die (mysql_error()); 



$fhFile     = fopen(SOURCE_FILENAME, "r") or die ("Error opening ".SOURCE_FILENAME); 
$sData      = fread($fhFile, filesize(SOURCE_FILENAME)); 

$aData      = explode(SEPERATOR_ROW, $sData); 

foreach($aData as $sRow) { 
    $aRow = explode(SEPERATOR_COL, $sRow); 
    /* Prepare values for query */ 
    foreach($aRow as $sKey => $sValue) { 
        $sValue         = str_replace('"', "", $sValue); 
        $sValue         = addslashes($sValue); 


        $aRow[$sKey]    = "'".$sValue."'";

    } 
    list($sIpFrom, $sIpTo, $sCountryCode2, $sCountryCode3, $sCountryName) = $aRow; 
    $sQuery = "INSERT INTO iptocountry (ip_from, ip_to, country_code2, country_code3, country_name) VALUES ('$sIpFrom', '$sIpTo', '$sCountryCode2', '$sCountryCode3', '$sCountryName')";
    mysql_query($sQuery) or die (mysql_error()); 
} 

?>