获得指定分类以及下级分类的函数

2016-07-07 14:55 来源：www.chinab4c.com 作者：ecshop专家


  1. //获得指定分类以及他的下一级分类 liangfang add

  3. function get_self_child_tree($cat_id = 0)
  4. {

  6. $sql = 'SELECT cat_name,cat_id FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$cat_id' AND is_show = 1 ";
  7. $rw=$GLOBALS['db']->getRow($sql);

  9. $self_arr[$rw['cat_id']]['id']=$rw['cat_id'];
  10. $self_arr[$rw['cat_id']]['name']=$rw['cat_name'];
  11. $self_arr[$rw['cat_id']]['url']=build_uri('category', array('cid' => $rw['cat_id']), $rw['cat_name']);

  13. $parent_id=$rw['cat_id'];

  15. $three_arr = array();
  16. /*判断是否存在子下级分类*/
  17. $sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('category') . " WHERE parent_id = '$parent_id' AND is_show = 1 ";
  18. if ($GLOBALS['db']->getOne($sql) || $cat_id == 0)
  19. {
  20. $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
  21. 'FROM ' . $GLOBALS['ecs']->table('category') .
  22. "WHERE parent_id = '$parent_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
  23. $res = $GLOBALS['db']->getAll($child_sql);
  24. foreach ($res AS $row)
  25. {
  26. if ($row['is_show'])
  27. {
  28. $three_arr[$row['cat_id']]['id']= $row['cat_id'];
  29. $three_arr[$row['cat_id']]['name'] = $row['cat_name'];
  30. $three_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);
  31. }
  32. }
  33. }

  35. $self_arr[$rw['cat_id']]['three']=$three_arr;
  36. return $self_arr;
  37. }
复制代码
  1. TEST....................

  3. Array
  4. (
  5. [261] => Array
  6. (
  7. [id] => 261
  8. [name] => 优品稻米
  9. [url] => category.php?id=261
  10. [three] => Array
  11. (
  12. [269] => Array
  13. (
  14. [id] => 269
  15. [name] => 东北大米
  16. [url] => category.php?id=269
  17. )

  19. [270] => Array
  20. (
  21. [id] => 270
  22. [name] => 泰国香米
  23. [url] => category.php?id=270
  24. )

  26. [271] => Array
  27. (
  28. [id] => 271
  29. [name] => 日本大米
  30. [url] => category.php?id=271
  31. )

  33. )

  35. )

  37. )
复制代码