Convert IP to City 的脚本

set_time_limit(9999);
if ("))
{
# mysql_select_db("ipinfodb");
mysql_select_db('ipinfodb') or die ('Can\'t use ipinfodb : ' . mysql_error());

$sql = "select ip_num from ips ";

$query = mysql_query($sql) or die("Invalid query: " . mysql_error());;

 while ($row=mysql_fetch_row($query))
    {
      $reg_ip = $row[0];
      $q = "SELECT region_name FROM `ip_group_city` where `ip_start` <= $reg_ip order by ip_start desc limit 1";
     $r_q=mysql_query($q)  or die("Invalid query: " . mysql_error());
    $row_q=mysql_fetch_row($r_q);
      if ($row_q)
      {
          $u_sql = "update ips set city_name='{$row_q[0]}' where ip_num = '{$reg_ip}'";
          mysql_query($u_sql);
      }
    }
mysql_close();
}
else
{
printf("

can't connect DB! %s

\n",
mysql_error());
}
?>

 desc ips;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| reg_ip    | varchar(18) | YES  | MUL | NULL    |       |
| city_name | varchar(50) | YES  | MUL | NULL    |       |
| ip_num    | bigint(16)  | YES  | MUL | NULL    |       |
+-----------+-------------+------+-----+---------+-------+

 

 desc ip_group_city;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ip_start     | bigint(20)  | NO   | PRI |         |       |
| country_code | varchar(2)  | NO   |     |         |       |
| country_name | varchar(64) | NO   |     |         |       |
| region_code  | varchar(2)  | NO   |     |         |       |
| region_name  | varchar(64) | NO   |     |         |       |
| city         | varchar(64) | NO   |     |         |       |
| zipcode      | varchar(6)  | NO   |     |         |       |
| latitude     | float       | NO   |     |         |       |
| longitude    | float       | NO   |     |         |       |
| timezone     | varchar(4)  | NO   |     |         |       |
| gmtOffset    | varchar(4)  | NO   |     |         |       |
| dstOffset    | varchar(4)  | NO   |     |         |       |
+--------------+-------------+------+-----+---------+-------+