数据库下载地址 https://download.csdn.net/download/u012607165/10534630
一级行政区: 省份
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/index.html');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = https://www.it610.com/article/curl_exec($curl);
curl_close($curl);
$data = https://www.it610.com/article/mb_convert_encoding($data,'UTF-8', 'GBK');

// 裁头
$offset = mb_strpos($data, 'provincetr',2000,'GBK');
$data = https://www.it610.com/article/mb_substr($data, $offset,NULL,'GBK');

// 裁尾
$offset = mb_strpos($data, '', 200,'GBK');
$data = https://www.it610.com/article/mb_substr($data, 0, $offset,'GBK');
preg_match_all('/\d{2}|[\x7f-\xff]+/', $data, $out);
$out = $out[0];
var_dump($out);

二级行政区 城市
public function add()
{
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/index.html');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = https://www.it610.com/article/curl_exec($curl);
curl_close($curl);
$data = https://www.it610.com/article/mb_convert_encoding($data,'UTF-8', 'GBK');

// 裁头
$offset = mb_strpos($data, 'provincetr',2000,'GBK');
$data = https://www.it610.com/article/mb_substr($data, $offset,NULL,'GBK');

// 裁尾
$offset = mb_strpos($data, '', 200,'GBK');
$data = https://www.it610.com/article/mb_substr($data, 0, $offset,'GBK');
preg_match_all('/\d{2}|[\x7f-\xff]+/', $data, $out);
$out = $out[0]; // 省份


$b = 0;
$time = time();
for ($i = 0; $i < count($out); $i++) {

$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/' . $out[$i++] . '.html');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = https://www.it610.com/article/curl_exec($curl);
curl_close($curl);
$data = https://www.it610.com/article/mb_convert_encoding($data,'UTF-8', 'GBK');

// 裁头
$offset = mb_strpos($data, 'citytr',2000,'GBK');
$data = https://www.it610.com/article/mb_substr($data, $offset,NULL,'GBK');

// 裁尾
$offset = mb_strpos($data, '', 200,'GBK');
$data = https://www.it610.com/article/mb_substr($data, 0, $offset,'GBK');

preg_match_all('/\d{12}|[\x7f-\xff]+/', $data, $city);
$city = $city[0];
// 某个省份的城市


var_dump($city);
echo ++$b;

$list = [];
for ($j=0; $j < count($city) ; $j++) {
$list[] = [
'code'=> $city[$j],
'name'=> $city[++$j],
'create_time' => $time,
'update_time' => $time,
];
}
Db::table('city')->insertAll($list); // 城市
/*
$data = https://www.it610.com/article/[
'code' => '1sfds',
'name' => 'test',
'create_time' => time(),
'update_time' => time(),
];
$list = [
$data, $data, $data
];
*/
// return Db::table('province')->insertAll($list);
}

// return Db::table('province')->insertAll($list);
}
三级行政区

$code_list = Db::table('city')->column('code');
$time = time();
foreach ($code_list as $key => $code) {
$code = substr($code, 0,4);
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/'. substr($code, 0,2) . '/' . $code . '.html');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = https://www.it610.com/article/curl_exec($curl);
curl_close($curl);
$data = https://www.it610.com/article/mb_convert_encoding($data,'UTF-8', 'GBK');
// 裁头
$offset = @mb_strpos($data, 'countytr',2000,'GBK');
if (!$offset) {
continue;
}
$data = https://www.it610.com/article/mb_substr($data, $offset,NULL,'GBK');

// 裁尾
$offset = mb_strpos($data, '', 200,'GBK');
$data = https://www.it610.com/article/mb_substr($data, 0, $offset,'GBK');
preg_match_all('/\d{12}|[\x7f-\xff]+/', $data, $out);
$out = $out[0]; // 某个城市
$list = [];
for ($j=0; $j < count($out) ; $j++) {
$list[] = [
'code'=> $out[$j],
'name'=> $out[++$j],
'create_time' => $time,
'update_time' => $time,
];
}
Db::table('county')->insertAll($list);
}

四级行政区：乡村或街道

$code_list = Db::table('county')->column('code');


$time = time();
foreach ($code_list as $key => $code) {
$code = substr($code, 0,6);
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, 'http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/'. substr($code, 0,2) . '/' . substr($code,2, 2) . '/' . $code . '.html');
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$data = https://www.it610.com/article/curl_exec($curl);
curl_close($curl);
$data = https://www.it610.com/article/mb_convert_encoding($data,'UTF-8', 'GBK');
// 裁头
$offset = @mb_strpos($data, 'towntr',2000,'GBK');
if (!$offset) {
continue;
}
$data = https://www.it610.com/article/mb_substr($data, $offset,NULL,'GBK');

// 裁尾
$offset = mb_strpos($data, '', 200,'GBK');
$data = https://www.it610.com/article/mb_substr($data, 0, $offset,'GBK');
preg_match_all('/\d{12}|[\x7f-\xff]+/', $data, $out);
$out = $out[0];
$list = [];
for ($j=0; $j < count($out) ; $j++) {
$list[] = [
'code'=> $out[$j],
'name'=> $out[++$j],
'create_time' => $time,
'update_time' => $time,
];
}
Db::table('town')->insertAll($list);
}





【PHP 抓取 国家统计局全国省市区镇四级行政区数据文章有数据库表下载地址】

推荐阅读

• 

  天梭表怎么验真假鉴别 天梭手表真假鉴别方法
• 

  鲁班七号最强出装铭文是什么
• 

  万国觉醒扫田有什么好处 万国觉醒扫田可以得资源吗
• 

  比较好看的小说作者排行 2019最好看的完结小说排行榜前十名
• 

  头痛来袭 中医推荐缓解头痛的茶饮
• 

  崩坏三战力多少达标 崩坏三战力怎么提到3300
• 

  养老金领取是按工作地还是户籍地？领取时间如何确定的？
• 

  面部spa是什么意思
• 

  最经典的七部恐怖网络大电影 彭禺厶电影大全鬼片大全
• 

  电商如何组建团队，组建一个电商团队初期需要几个人
• 

  西门子洗衣机打钢怎么调原因？
• 

  电脑上经常弹出广告怎么解决？
• 

  悦跑圈怎么设置锁屏？
• 

  奇亚籽和亚麻籽同吃的功效与作用
• 

  脐橙富含什么维生素
• 

  bunny的意思
• 

  蜜蜂失王会自己造王吗 蜜蜂失王一般急造多少个王
• 

  蚂蚁庄园今日答案大象鼻子 大象鼻子里有骨头吗2.24
• 

  刚吃的李子种能种活吗
• 

  mysql表空间迁移 mysql空间传输功能

• 笔记|如何在Windows11安装安卓子系统（）
• 笔记|C语言数据结构——二叉树的顺序存储和二叉树的遍历
• 2021年下半年《信息系统项目管理师》真题
• 个人理解|【C语言基础之类型转换】
• 学习分享|【C语言函数基础】
• 个人理解|【C语言实现井字棋及电脑落子优化】
• Python|蓝桥杯 平面切割 Python
• Python|Python 每日一练 二分查找 搜索旋转排序数组 详解
• 笔记|这是一个关于face_recognition和dlib库的安装（亲测有用，毕竟我代码都写出来了）
• 信令模式与非信令模式