求高手赐教，怎样在商品子分类下调用上级分类的产品

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

求高手赐教，怎样在商品子分类下调用上级分类的产品

回答：
你取得父类接点的ＩＤ．然后通过ＩＤ取得商品　

搜索的时候加上父级ID就可以啊。

  1. function get_child_tree($tree_id)
  2. {


  5. $three_arr = array();
  6. $sql = 'SELECT cat_name FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$tree_id' AND is_show = 1 ";
  7. $cat_name = $GLOBALS['db']->getOne($sql);

  9. $sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('category') . " WHERE parent_id = '$tree_id' AND is_show = 1 ";

  11. if ($GLOBALS['db']->getOne($sql))
  12. {
  13. $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
  14. 'FROM ' . $GLOBALS['ecs']->table('category') .
  15. "WHERE parent_id = '$tree_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
  16. $res = $GLOBALS['db']->getAll($child_sql);
  17. foreach ($res AS $row)
  18. {
  19. if ($row['is_show'])

  21. $three_arr[$row['cat_id']]['id']= $row['cat_id'];
  22. $three_arr[$row['cat_id']]['name'] = $row['cat_name'];
  23. $three_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);

  25. }
  26. }
  27. else {
  28. // echo "sdf";

  30. $sql = "SELECT parent_id,cat_name FROM " . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$tree_id' AND is_show = 1 ";

  32. $rows = $GLOBALS['db']->getRow($sql);
  33. // print_r($rows);exit;
  34. $parent_id = $rows['parent_id'];

  36. $sql1 = "SELECT cat_name FROM " . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$parent_id' AND is_show = 1 ";

  38. $cat_name = $GLOBALS['db']->getOne($sql1);
  39. //echo $cat_name;exit;
  40. $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
  41. 'FROM ' . $GLOBALS['ecs']->table('category') .
  42. "WHERE parent_id = '$parent_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
  43. $res = $GLOBALS['db']->getAll($child_sql);
  44. foreach ($res AS $row)
  45. {
  46. if ($row['is_show'])

  48. $three_arr[$row['cat_id']]['id']= $row['cat_id'];
  49. $three_arr[$row['cat_id']]['name'] = $row['cat_name'];
  50. $three_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);
  51. }
  52. }

  54. //$arr['cat_list'] = $three_arr;
  55. //$arr['cat_name'] = $cat_name;
  56. //print_r($three_arr);exit;
  57. return $three_arr;
  58. }
复制代码
能否看懂这个函数