/*
版本编号:101105091046
文件名称:sql.php
更新日期:2011-05-09
代码修改:feikeq
代码功能:将数据库内的地址文字采集字符经纬度并将字符经纬度解密成数字经纬度,然后利用0.01精度校正库文件修正经纬度偏移。
*/
header("Content-Type:text/html; charset=utf-8");
$mysql_server_name="localhost"; //数据库服务器名称
$mysql_username="root"; // 连接数据库用户名
$mysql_password=""; // 连接数据库密码
$mysql_database="ycyw"; // 数据库的名字
$mysql_table="ycyw_address_test"; // 数据表
$start=0;// 开始数据记录
$over=99999;// 结束数据记录
//如果用原来的JS调用解密处理180条数据用时45秒左右现在只要15秒。
$phptime_1=explode(' ', microtime());
/* // mapabc经纬度加密解密 - 开始 // */
//MapAbc中使用编码坐标与10进度方式的坐标转换js方法,仅供参考
$__keys__=array(
array(0, 2, 1, 2, 8, 9, 4, 1, 7, 2, 5, 3, 9),
array(0, 3, 2, 2, 9, 5, 8, 2, 6, 8, 4, 6, 3),
array(1, 5, 2, 7, 1, 4, 7, 2, 4, 1, 4, 3, 0),
array(0, 7, 8, 3, 4, 9, 0, 6, 7, 7, 4, 4, 2),
array(0, 2, 1, 8, 4, 9, 3, 2, 3, 1, 5, 7, 8),
array(0, 0, 9, 5, 4, 7, 3, 0, 8, 7, 5, 2, 8),
array(0, 1, 5, 1, 1, 8, 2, 7, 1, 9, 1, 3, 5),
array(0, 5, 2, 5, 6, 0, 3, 4, 6, 7, 1, 3, 5),
array(1, 3, 2, 1, 8, 1, 8, 3, 7, 9, 2, 7, 0),
array(1, 2, 7, 7, 4, 3, 1, 5, 5, 0, 6, 4, 4),
array(1, 5, 2, 8, 9, 2, 5, 9, 6, 7, 3, 3, 5),
array(1, 7, 9, 4, 5, 0, 9, 4, 9, 6, 1, 9, 9),
array(0, 6, 8, 3, 3, 6, 3, 5, 2, 0, 0, 9, 1),
array(1, 1, 1, 4, 7, 8, 6, 9, 6, 8, 8, 4, 6),
array(0, 5, 2, 1, 2, 5, 7, 0, 0, 4, 7, 4, 1),
array(0, 7, 6, 4, 2, 3, 9, 0, 7, 8, 5, 6, 7),
array(0, 1, 7, 6, 0, 5, 4, 7, 6, 7, 7, 5, 7),
array(0, 5, 2, 9, 8, 1, 7, 8, 3, 8, 5, 4, 5),
array(0, 4, 3, 1, 2, 8, 3, 7, 0, 9, 4, 8, 8),
array(1, 0, 6, 7, 9, 4, 3, 5, 2, 9, 8, 7, 7),
array(1, 6, 4, 4, 6, 7, 1, 4, 4, 2, 6, 7, 5),
array(0, 8, 1, 7, 7, 5, 2, 6, 4, 3, 9, 7, 5),
array(1, 7, 0, 5, 6, 2, 5, 2, 7, 4, 6, 2, 8),
array(0, 4, 9, 2, 3, 0, 5, 4, 7, 8, 7, 0, 5),
array(1, 1, 0, 5, 1, 7, 2, 8, 7, 2, 6, 9, 3),
array(1, 4, 2, 3, 6, 1, 5, 3, 2, 0, 3, 6, 2),
array(1, 1, 6, 5, 1, 0, 6, 8, 9, 7, 1, 7, 9),
array(0, 6, 5, 4, 0, 7, 1, 7, 6, 2, 5, 4, 2),
array(1, 9, 8, 6, 6, 6, 8, 4, 5, 4, 0, 4, 0),
array(1, 2, 7, 1, 5, 0, 6, 8, 0, 1, 3, 7, 9),
array(1, 1, 6, 4, 9, 8, 6, 0, 6, 2, 1, 9, 8),
array(0, 0, 1, 9, 5, 3, 3, 9, 6, 7, 4, 1, 1),
array(0, 2, 8, 5, 7, 8, 6, 7, 3, 3, 1, 6, 4),
array(1, 8, 2, 5, 8, 4, 7, 6, 8, 8, 5, 7, 6),
array(0, 8, 3, 4, 9, 6, 1, 7, 8, 3, 0, 5, 5),
array(1, 3, 2, 6, 7, 4, 2, 8, 7, 4, 9, 6, 8),
array(1, 8, 8, 9, 3, 9, 1, 8, 5, 7, 2, 5, 0),
array(0, 5, 8, 3, 1, 8, 8, 0, 3, 9, 3, 8, 1),
array(1, 6, 0, 1, 1, 0, 3, 4, 3, 3, 3, 5, 9),
array(1, 0, 5, 1, 7, 9, 6, 2, 4, 6, 0, 3, 5),
array(1, 8, 2, 0, 9, 7, 1, 0, 5, 5, 8, 0, 6),
array(1, 8, 9, 6, 7, 3, 9, 4, 1, 9, 6, 6, 2),
array(0, 6, 0, 0, 8, 2, 6, 5, 9, 4, 1, 6, 2),
array(1, 7, 9, 7, 9, 4, 4, 2, 1, 1, 5, 7, 4),
array(1, 3, 0, 4, 3, 4, 6, 8, 6, 9, 1, 7, 0),
array(0, 1, 2, 3, 9, 4, 1, 8, 7, 2, 2, 9, 8),
array(1, 6, 5, 3, 2, 7, 6, 6, 9, 0, 0, 7, 7),
array(1, 6, 8, 4, 9, 7, 8, 0, 3, 6, 5, 4, 8),
array(0, 6, 6, 0, 9, 9, 4, 5, 5, 6, 8, 3, 7),
array(1, 0, 1, 3, 4, 0, 0, 1, 4, 8, 5, 7, 0),
array(1, 0, 2, 5, 8, 2, 2, 4, 8, 9, 7, 1, 6),
array(1, 4, 2, 6, 6, 8, 4, 5, 6, 6, 4, 5, 9),
array(1, 4, 4, 1, 7, 2, 0, 4, 6, 3, 3, 6, 7),
array(0, 2, 2, 3, 8, 0, 0, 8, 6, 0, 2, 1, 7),
array(0, 9, 4, 4, 8, 1, 2, 7, 3, 2, 6, 8, 0),
array(0, 9, 8, 4, 2, 1, 4, 5, 2, 4, 9, 5, 1),
array(0, 7, 2, 4, 7, 4, 3, 2, 4, 1, 5, 6, 9),
array(1, 1, 8, 4, 8, 8, 8, 4, 3, 4, 1, 2, 5),
array(0, 3, 2, 7, 5, 7, 0, 2, 7, 4, 5, 3, 5),
array(0, 3, 0, 4, 6, 6, 6, 5, 7, 2, 1, 9, 5),
array(1, 5, 6, 0, 1, 3, 2, 7, 3, 0, 9, 8, 6),
array(0, 5, 5, 1, 7, 1, 0, 7, 9, 0, 3, 5, 7),
array(0, 5, 4, 9, 7, 9, 7, 3, 8, 0, 1, 6, 3),
array(1, 9, 2, 7, 3, 7, 9, 4, 3, 9, 8, 8, 2),
array(0, 3, 1, 8, 9, 0, 9, 0, 4, 5, 5, 0, 9),
array(1, 8, 6, 1, 7, 7, 2, 4, 7, 9, 2, 0, 8),
array(0, 6, 1, 2, 7, 1, 4, 8, 4, 1, 1, 6, 0),
array(0, 3, 9, 8, 5, 5, 3, 0, 8, 7, 9, 3, 5),
array(0, 8, 4, 3, 7, 3, 1, 8, 2, 9, 1, 4, 7),
array(0, 1, 5, 3, 4, 0, 5, 5,