数据库下载地址 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 抓取 国家统计局全国省市区镇四级行政区数据文章有数据库表下载地址】

推荐阅读

• 

  乐苑环游世界第一站（最美的风景在路上“拉萨-林芝”（自驾篇））
• 

  宝宝频繁吃奶的原因
• 

  鱼没有腌好有点腥怎样补救
• 

  Android M(6.0) 权限爬坑之旅
• 

  荣耀9XPro手机无法开机的原因
• 

  新冠疫苗|辉瑞新冠疫苗已致两人死亡，国产疫苗引发全球抢购
• 

  G610手机参数 华为G610还能升级系统吗
• 

  【SpringCloud-Alibaba系列教程】4.服务管理
• 

  redis client有哪些 redis客户端有哪些
• 

  大金中央空调u1故障代码解决步骤,考虑这几点原因
• 

  大商道人物结局
• 

  吃太多香蕉会致人死亡？科学分析香蕉的“毒”
• 

  早上调皮幽默的问候句子 早安调皮句子超棒的幽默早安问候语
• 

  兰花的颜色有哪些特点 兰花的颜色有哪些
• 

  西门子燃气灶点火按压熄火出现这种故障怎么办,主要是看这个指标
• 

  《王者荣耀》“王炸流”狄仁杰崛起,可贴脸站撸铠皇,排位胜率接近90%,应该怎么玩？
• 

  蛙泳怎么提高呼吸技术
• 

  冰箱旁边放植物好养吗? 冰箱上面能放植物吗
• 

  2022长沙市养老金上调发放时间 退休人员养老金上调标准
• 

  灵川县景点

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