PHP递归函数获取属于这个分类的所有子分类

最新推荐文章于 2024-07-26 15:17:19 发布

原创最新推荐文章于 2024-07-26 15:17:19 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#php #cms #merge #null

PHP 专栏收录该内容

13 篇文章

订阅专栏

本文介绍了一个PHP函数，用于递归地查询并返回指定顶级ID下所有的子节点ID。该函数能够处理单一ID或ID数组，并通过修改SQL查询语句以适应不同的应用场景。

只要根据自己的情况修改相关的查询语句，然后只要传入一个顶层的ID就可以得出所属的所有ID

function GetSon($PID='')
{
  $this->dataconnect();
  if($PID=='') return;
  $returnSiteID = null;

  if($PID == 0)
  {
   $returnSiteID = $this->db->GetCol("SELECT SiteID FROM cms_r_site WHERE PublishMode=1 ORDER BY SiteID ASC");
  }elseif(is_array($PID)){
   foreach ( $PID as $SID)
   {
    $returnSiteIDTemp = $this->db->GetCol("SELECT SiteID FROM cms_r_site WHERE ParentID=".$SID." AND PublishMode=1 ORDER BY SiteID ASC");
    if(!empty($returnSiteIDTemp))
    {
     if(empty($returnSiteID))
     {
      $returnSiteID = $returnSiteIDTemp;
     }else{
      $returnSiteID = array_merge($returnSiteID, $returnSiteIDTemp);
     }
    }
   }
  }elseif(!empty($PID)){
   $returnSiteID = $this->db->GetCol("SELECT SiteID FROM cms_r_site WHERE ParentID=".$PID." AND PublishMode=1 ORDER BY SiteID ASC");
  }else{
   $returnSiteID = null;
  }
  if(!empty($returnSiteID))
  {
   if(empty($this->retrunSite))
   {
    $this->retrunSite = $returnSiteID;
   }else{
    $this->retrunSite = array_merge($this->retrunSite, $returnSiteID);
   }
   $this->GetSon($returnSiteID);
  }
  return $this->retrunSite;
}