将纯真ip数据库解析并导入mysql数据库中

<?php
header("content-type:text/html; charset=utf-8");
echo "导入纯真ip库";
$conn = mysql_connect('localhost', 'root', 'password') or
        die("Could not connect: " . mysql_error());
mysql_select_db("database");
mysql_query("set names utf8"); 

//解析ip.txt数据, 并插入数据库中
set_time_limit(-1);
$file = "/path/to/ip.txt";
$fp = fopen($file, "r");
while($str = trim(fgets($fp, 2000))){
    preg_match("/([\.\d]+)\s+([\.\d]+)\s+(.*?)\s+(.*)/is", $str, $arr);
    unset($arr[0]);
    $arr = array_map("my_replace", $arr);
    $str = iconv("gbk", "utf-8",
        "INSERT INTO `ip`(`ip_start`,`ip_end`,`area`,`position`)
        VALUES('".implode("','", $arr)."');\n");
    mysql_query($str);
}
fclose($fp); 

//function start
function my_replace($str) {
    return str_replace("'", "''", $str);
} 

?>