站长资源网络编程
PHP获取栏目的所有子级和孙级栏目的ID号示例
简介复制代码 代码如下: //@获取子栏目ID号 private function sonCategoryIds($categoryID) { //@初始化栏目数组 $array[] = $categoryID; do { $ids = ''; $temp = $this->mysql->select(
复制代码 代码如下:
//@获取子栏目ID号
private function sonCategoryIds($categoryID)
{
//@初始化栏目数组
$array[] = $categoryID;
do
{
$ids = '';
$temp = $this->mysql->select('SELECT `id` FROM `pcb_article_category` WHERE `parentID` IN (' . $categoryID . ')');
foreach ($temp as $v)
{
$array[] = $v['id'];
$ids .= ',' . $v['id'];
}
$ids = substr($ids, 1, strlen($ids));
$categoryID = $ids;
}
while (!empty($temp));
$ids = implode(',', $array);
return $ids;
}
//@获取子栏目ID号
private function sonCategoryIds($categoryID)
{
//@初始化栏目数组
$array[] = $categoryID;
do
{
$ids = '';
$temp = $this->mysql->select('SELECT `id` FROM `pcb_article_category` WHERE `parentID` IN (' . $categoryID . ')');
foreach ($temp as $v)
{
$array[] = $v['id'];
$ids .= ',' . $v['id'];
}
$ids = substr($ids, 1, strlen($ids));
$categoryID = $ids;
}
while (!empty($temp));
$ids = implode(',', $array);
return $ids;
}