最新县及县以上行政区划代码（截止2014年10月31日）-php手册-php.cn

Home

php教程

php手册

最新县及县以上行政区划代码（截止2014年10月31日）

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 am 11:38 AM

采集自国家统计局
http://www.stats.gov.cn/tjsj/tjbz/xzqhdm/201504/t20150415_712722.html
有需要的同学自行下载附件，分割入库
文件格式如下
110000,北京市###110100,市辖区###110101,东城区###110102……

数据库方面CREATE TABLE `think_region` ( `id` mediumint(6) unsigned NOT NULL DEFAULT '0', `pid` mediumint(6) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8控制器方面 $DB = M('Region'); $file = './code.txt'; $content = file_get_contents($file); $content = think_s2a($content, '###'); $i=0;$addall=array(); foreach ($content as $v) { $data = think_s2a($v); switch (true) { case (preg_match('/\d{2}0000/', $data[0])): $pid = 0; $type = 0; break; case (preg_match('/\d{4}00/', $data[0])): $pid = substr($data[0], 0, 2) . '0000'; $type = 1; break; default: $pid = substr($data[0], 0, 4) . '00'; $type = 2; } $add = array( 'id' => $data[0], 'pid' => $pid, 'name' => $data[1], 'type' => $type, ); $rules = array( array('id', 'require','id必须'), array('pid', 'require','pid必须'), array('name', 'require','neme必须'), array('type', array(0,1, 2), '类型范围', 1, 'in', 1), array('id', '', '该地区已录入', 1, 'unique', 1), ); if ($DB->validate($rules)->create($add, 1)) { $addall[$i]=$DB->data(); $i++; } } $DB->addAll($addall);

地区.zip ( 20.91 KB 下载：106 次 )

AD：真正免费，域名+虚机+企业邮箱=0元

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn