?
$servername = ' localhost ';
$dbname = ' Test '; Database name
$dbusername = ' root '; Database user Name
$dbpassword = ' root '; Database Password
$link =mysql_connect ($servername, $dbusername, $dbpassword);
mysql_select_db ($dbname) or Die ();
mysql_query ("Set names ' GBK '");
function GetIP () {
if ($_server[' http_x_forwarded_for ']) {
$online _ip = $_server[' http_x_forwarded_for '];
}elseif ($_server[' http_client_ip ']) {
$online _ip = $_server[' http_client_ip '];
}else{
$online _ip = $_server[' remote_addr '];
}
return $online _ip;
}
function Ip2int ($IP) {
List ($ip 1, $ip 2, $ip 3, $ip 4) =explode (".", $ip);
Return $ip 1*pow (256,3) + $ip 2*pow (256,2) + $ip 3*256+ $ip 4;
}
$ip =ip2int (GetIP ());
$sql = "SELECT * from iptocity where ip_start<= ' $ip ' ORDER by ip_start desc LIMIT 1";
$q =mysql_query ($sql);
$rs =mysql_fetch_array ($q);
$sheng = $rs ["Ip_province"];
$city = $rs ["ip_city"];
echo $sheng. " -> ". $city;
?>
MySQL IP library download address
Http://g.111cn.net/down/ipdata.rar