原生 PDO 写法地址接口

最新推荐文章于 2021-04-05 05:18:50 发布

JXL666888

最新推荐文章于 2021-04-05 05:18:50 发布

阅读量477

点赞数

分类专栏： PDO链接数据库地址接口返回 PHP

本文链接：https://blog.csdn.net/JXL9910/article/details/84987998

版权

PHP 同时被 2 个专栏收录

40 篇文章 1 订阅

订阅专栏

PDO链接数据库地址接口返回

1 篇文章 0 订阅

订阅专栏

<?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文件下载