Ec (2); & lt ;? $ Servernamelocalhost; $ dbnametest; & nbsp; database name $ dbusernameroot; & nbsp; database username $ dbpasswordroot; & nbsp; Database Password & nbsp; $ linkmysql_connect ($ servername, $ dbuserna script ec (2); script
$ Servername = 'localhost ';
$ Dbname = 'test'; // Database Name
$ Dbusername = 'root'; // database username
$ 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 ($ ip1, $ ip2, $ ip3, $ ip4) = explode (".", $ ip );
Return $ ip1 * pow (256) + $ ip2 * pow () + $ ip3 * + $ ip4;
}
$ 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
Http://g.111cn.net/down/ipdata.rar