原生 PDO 写法地址接口_pdo地址-优快云博客

本文介绍了一个使用PHP和PDO从MySQL数据库中检索中国省份、城市及区县数据的方法。通过定义数据库连接参数，执行SQL查询获取地域信息，并使用JSON格式返回结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php 

define('DSN', 'mysql:dbname=test;charset=utf8;host=localhost');
define('USER', 'root');
define('PWD', 'root');

$db = new PDO(DSN, USER, PWD);

// 省
$province_listSql = "SELECT region_id, region_name FROM ecs_region WHERE region_type = '1' AND parent_id = '1'"; //sheng
$res = $db->query($province_listSql);
if($res){
    $province_list = $res->fetchAll(PDO::FETCH_ASSOC);
}else{
    $province_list = array();
}

foreach ($province_list as $key => $value) {
    // 市
    $citySql = "SELECT region_id,region_name FROM ecs_region WHERE region_type='2' and parent_id<35 and parent_id='$value[region_id]'";
    $cityRes = $db->query($citySql);
    if($cityRes){
        $province_list[$key]['city'] = $cityRes->fetchAll(PDO::FETCH_ASSOC);
    }else{
        $province_list[$key]['city'] = array();
    }

    // 县,区
    foreach ($province_list[$key]['city'] as $k => $val) {
        $areaSql = "SELECT region_id,region_name FROM ecs_region WHERE region_type='3' and parent_id!=18881 and parent_id='$val[region_id]' ";
        $areaRes = $db->query($citySql);
	    if($areaRes){
	        $province_list[$key]['city'][$k]['area'] = $areaRes->fetchAll(PDO::FETCH_ASSOC);
	        
	    }else{
	        $province_list[$key]['city'][$k]['area'] = array();
	    }

    }
    
}

die(json_encode(array('res'=>1,'msg'=>'成功','province_list'=>$province_list))) ;

地址数据表 mysql文件下载