PHP getAreaInfoFromAreaID示例

示例#1

文件： CommonController.class.php 项目： zhennong/DataReport

 function getAreaInfoFromAreaID($areaid, &$areaInfo)
 {
     $sql = "SELECT * FROM __MALL_area WHERE areaid = " . $areaid;
     $x = $this->MallDb->list_query($sql);
     //        $x = D('Area')->where(['areaid'=>$areaid])->select();
     if ($x[0]['parentid'] == 0) {
         $areaInfo[] = $x[0]['areaname'];
     } else {
         $areaInfo[] = $x[0]['areaname'];
         getAreaInfoFromAreaID($x[0]['parentid'], $areaInfo);
     }
     return $areaInfo;
 }

示例#2

文件： function.php 项目： zhennong/DataReport

function getAreaInfoFromAreaID($areaid, &$areaInfo)
{
    $tb_area = C('BUSINESS_DB_TABLE_PREFIX') . "area";
    $sql = "SELECT * FROM {$tb_area} WHERE areaid = {$areaid}";
    $x = queryMysql($sql);
    if ($x[0]['parentid'] == 0) {
        $areaInfo[] = $x[0][areaname];
    } else {
        $areaInfo[] = $x[0][areaname];
        getAreaInfoFromAreaID($x[0]['parentid'], $areaInfo);
    }
    return $areaInfo;
}