PHP获取IP地址及根据IP判断城市

&lt;?php $servername ='localhost'; $dbname='test'; //数据库名 $dbusername ='root'; //数据库用户名 $dbpassword ='123123'; //数据库密码 $link=mysql_connect($servername,$dbusername,$dbpassword); mysql_select_db($dbname) or die(); mysql_query("set names 'gbk'"); function get_real_ip(){ $ip=false; if(!empty($_SERVER["HTTP_CLIENT_IP"])){ $ip=$_SERVER["HTTP_CLIENT_IP"]; } if(!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ips=explode(",",$_SERVER['HTTP_X_FORWARDED_FOR']); if ($ip){ array_unshift($ips,$ip); $ip=FALSE; } for($i=0;$i<count($ips);$i++){ if (!eregi("^(10│172.16│192.168).",$ips[$i])){ $ip=$ips[$i]; break; } } } $ip=$ip?$ip:$_SERVER['REMOTE_ADDR']; list($ip1,$ip2,$ip3,$ip4)=explode(".",$ip); return $ip1*pow(256,3)+$ip2*pow(256,2)+$ip3*256+$ip4; } $ip=get_real_ip(); $sql="select * from ip where start&lt;=$ip order by start desc limit 1"; $q=mysql_query($sql); $rs=mysql_fetch_array($q); $city=$rs["city"]; echo $city; //演示http://www.gjccx.cn/ip.php ?&gt;