ThinkPHP分類查詢(擷取當前分類的子分類，擷取父分類，下一級分類)

標籤：logs   foreach   sub   for   ret   empty   each   get   eid   

 擷取指定分類的所有子分類ID號

//擷取指定分類的所有子分類ID號function getAllChildcateIds($categoryID){    //初始化ID數組    $array[] = $categoryID;    do {        $ids = ‘‘;        $where[‘pid‘] = array(‘in‘,$categoryID);        $cate = M(‘cate‘)->where($where)->select();        foreach ($cate as $k=>$v){            $array[] = $v[‘id‘];            $ids .= ‘,‘ . $v[‘id‘];        }        $ids = substr($ids, 1, strlen($ids));        $categoryID = $ids;    }    while (!empty($cate));    $ids = implode(‘,‘, $array);    return $ids;    //  返回字串    //return $array //返回數組}

 

擷取指定分類所有父ID號

//擷取指定分類所有父ID號function getAllFcateIds($categoryID){//初始化ID數組$array[] = $categoryID; do{    $ids = ‘‘;    $where[‘id‘] = array(‘in‘,$categoryID);    $cate = M(‘cate‘)->where($where)->select();    echo M(‘cate‘)->_sql();    foreach ($cate as $v){        $array[] = $v[‘pid‘];        $ids .= ‘,‘ . $v[‘pid‘];    }    $ids = substr($ids, 1, strlen($ids));    $categoryID = $ids;}while (!empty($cate));$ids = implode(‘,‘, $array); return $ids;   //  返回字串//return $array //返回數組}

 

擷取指定分類的所有子分類 鍵為ID，值為分類名

//擷取指定分類的所有子分類 鍵為ID，值為分類名function getCateKv($categoryID){    //初始化ID數組,賦值當前分類    $array[] = M(‘cate‘)->where("id={$categoryID}")->getField("cateName");    do {        $ids = ‘‘;        $where[‘pid‘] = array(‘in‘,$categoryID);        $cate = M(‘cate‘)->where($where)->select();        echo M(‘cate‘)->_sql();        foreach ($cate as $k=>$v) {            $array[$v[‘id‘]] = $v[‘cateName‘];            $ids .= ‘,‘ . $v[‘id‘];        }        $ids = substr($ids, 1, strlen($ids));        $categoryID = $ids;    }    while (!empty($cate));    $ids = implode(‘,‘, $array);     //return $ids; //  返回字串    return $array //返回數組}

 

ThinkPHP分類查詢(擷取當前分類的子分類，擷取父分類，下一級分類)