Chinaunix

标题: Convert IP to City 的脚本 [打印本页]

作者: r_a 时间: 2009-10-21 11:27
标题: Convert IP to City 的脚本

$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` 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 |    |       |    |
+--------------+-------------+------+-----+---------+-------+

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/61329/showart_2074672.html

作者: nrzhong 时间: 2009-10-30 10:59

强烈要求发全文

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)