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

推荐阅读

• 

  数据结构斐波那契数列 mySQL计算斐波那契数
• 

  手机|为何买新骁龙8旗舰机的人越来越多？
• 

  碧护不能和什么混用，碧护一克兑水多少
• 

  佳能新老f1 佳能新老24-70F2.8
• 

  2021年抖音最火励志的句子 2021年抖音最火励志的句子有哪些
• 

  如何分辨5号7号电池,两节七号电池几个月没电
• 

  科磊路由器详细设置
• 

  夏秋交替容易与感冒混淆的9种疾病
• 

  女性清洗私处容易犯的错误都有哪些？
• 

  浙大邵逸夫医院|今天，浙大邵逸夫医院绍兴院区正式开工！
• 

  赛博朋克2077主线救人义务攻略,主线救人义务图文攻略
• 

  我的世界猪灵交易表一览 我的世界猪灵能换什么
• 

  冬瓜茶喝了有什么作用
• 

  元是人民币单位中最大的单位对吗
• 

  三天光吃鸡蛋能瘦多少
• 

  手机号换了快手登不上怎么办
• 

  深圳防腐木木屋 深圳防腐木批发市场在哪里
• 

  可能年少的心太柔软是什么歌 可能年少的心太柔软是什么歌女生
• 

  毕业生自我鉴定200字左右 毕业生自我鉴定范文
• 

  凤梨的营养价值及营养成分 凤梨的营养价值高吗

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