请问这种分类树是怎么回事？要如何解决？附图

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

看这三张图，第一张是一级分类，第二张是二级分类，第三张是底级分类，因为下面没分类了，所以显示成那样，但我想显示成像第四张这样的效果，类似http://demo.wd5u.com/360buy/category.php?id=72这样的效果。

找了很多有关修改get_categories_tree的帖，但都没有效果。希望哪位高人赐教。。








回答：
买个他的模板不就可以了吗，祝楼主早日得到高手的帮助！



第四张图跟第三张图是同一级的分类，但是第四张图的底级分类跟第三张图的底级分类样式不同。

我不知道你的代码是啥我想应该是 ：{if } 就是写个判断分类存在的情况下显示。搞不定 找我 发我代码看

分类不同导致效果不一样！模板本身应该不会有问题吧~

/**
* 获得指定分类同级的所有分类以及该分类下的子分类
*
* @accesspublic
* @paraminteger$cat_id分类编号
* @returnarray
*/
function get_categories_tree($cat_id = 0)
{
if ($cat_id > 0)
{
$sql = 'SELECT parent_id FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$cat_id'";
$parent_id = $GLOBALS['db']->getOne($sql);
}
else
{
$parent_id = 0;
}

/*
判断当前分类中全是是否是底级分类，
如果是取出底级分类上级分类，
如果不是取当前分类及其下的子分类
*/
$sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('category') . " WHERE parent_id = '$parent_id' AND is_show = 1 ";
if ($GLOBALS['db']->getOne($sql) || $parent_id == 0)
{
/* 获取当前分类及其子分类 */
$sql = 'SELECT cat_id,cat_name ,parent_id,is_show ' .
'FROM ' . $GLOBALS['ecs']->table('category') .
"WHERE parent_id = '$parent_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";

$res = $GLOBALS['db']->getAll($sql);

foreach ($res AS $row)
{
if ($row['is_show'])
{
$cat_arr[$row['cat_id']]['id']= $row['cat_id'];
$cat_arr[$row['cat_id']]['name'] = $row['cat_name'];
$cat_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);

if (isset($row['cat_id']) != NULL)
{
$cat_arr[$row['cat_id']]['cat_id'] = get_child_tree($row['cat_id']);
}
}
}
}
if(isset($cat_arr))
{
return $cat_arr;
}
}




这是lib.goods.php里的代码，实在找不到解决的办法，我也想写个{if}的判断，但是好像底级分类都识别不出似的。

  1. /**
  2. * 获得指定分类同级的所有分类以及该分类下的子分类
  3. *
  4. * @accesspublic
  5. * @paraminteger$cat_id分类编号
  6. * @returnarray
  7. */
  8. function get_categories_tree($cat_id = 0)
  9. {
  10. if ($cat_id > 0)
  11. {
  12. $sql = 'SELECT parent_id FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$cat_id'";
  13. $parent_id = $GLOBALS['db']->getOne($sql);
  14. }
  15. else
  16. {
  17. $parent_id = 0;
  18. }

  20. /*
  21. 判断当前分类中全是是否是底级分类，
  22. 如果是取出底级分类上级分类，
  23. 如果不是取当前分类及其下的子分类
  24. */
  25. $sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('category') . " WHERE parent_id = '$cat_id' AND is_show = 1 ";
  26. if ($GLOBALS['db']->getOne($sql) || $parent_id == 0)
  27. {
  28. /* 获取当前分类及其子分类 */
  29. $sql = 'SELECT a.cat_id, a.cat_name, a.sort_order AS parent_order, a.cat_id, a.is_show,' .
  30. 'b.cat_id AS child_id, b.cat_name AS child_name, b.sort_order AS child_order ' .
  31. 'FROM ' . $GLOBALS['ecs']->table('category') . ' AS a ' .
  32. 'LEFT JOIN ' . $GLOBALS['ecs']->table('category') . ' AS b ON b.parent_id = a.cat_id AND b.is_show = 1 ' .
  33. "WHERE a.parent_id = '$parent_id' ORDER BY parent_order ASC, a.cat_id ASC, child_order ASC";
  34. }
  35. else
  36. {
  37. /* 获取当前分类及其父分类 */
  38. $sql = 'SELECT a.cat_id, a.cat_name, b.cat_id AS child_id, b.cat_name AS child_name, b.sort_order, b.is_show ' .
  39. 'FROM ' . $GLOBALS['ecs']->table('category') . ' AS a ' .
  40. 'LEFT JOIN ' . $GLOBALS['ecs']->table('category') . ' AS b ON b.parent_id = a.cat_id AND b.is_show = 1 ' .
  41. "WHERE b.parent_id = '$parent_id' ORDER BY sort_order ASC";
  42. }
  43. $res = $GLOBALS['db']->getAll($sql);

  45. $cat_arr = array();
  46. foreach ($res AS $row)
  47. {
  48. if ($row['is_show'])
  49. {
  50. $cat_arr[$row['cat_id']]['id']= $row['cat_id'];
  51. $cat_arr[$row['cat_id']]['name'] = $row['cat_name'];
  52. $cat_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);

  54. if ($row['child_id'] != NULL)
  55. {
  56. $cat_arr[$row['cat_id']]['children'][$row['child_id']]['id']= $row['child_id'];
  57. $cat_arr[$row['cat_id']]['children'][$row['child_id']]['name'] = $row['child_name'];
  58. $cat_arr[$row['cat_id']]['children'][$row['child_id']]['url']= build_uri('category', array('cid' => $row['child_id']), $row['child_name']);
  59. }
  60. }
  61. }

  63. return $cat_arr;
  64. }
  65. function get_child_tree($tree_id = 0)
  66. {
  67. $three_arr = array();
  68. $sql = 'SELECT cat_name FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_id = '$tree_id' AND is_show = 1 ";
  69. $cat_name = $GLOBALS['db']->getOne($sql);

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

  73. if ($GLOBALS['db']->getOne($sql) || $tree_id == 0)
  74. {
  75. $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
  76. 'FROM ' . $GLOBALS['ecs']->table('category') .
  77. "WHERE parent_id = '$tree_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
  78. $res = $GLOBALS['db']->getAll($child_sql);
  79. foreach ($res AS $row)
  80. {
  81. if ($row['is_show'])

  83. $three_arr[$row['cat_id']]['id']= $row['cat_id'];
  84. $three_arr[$row['cat_id']]['name'] = $row['cat_name'];
  85. $three_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);

  87. }
  88. }
  89. else
  90. {
  91. // echo "sdf";

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

  95. $rows = $GLOBALS['db']->getRow($sql);
  96. // print_r($rows);exit;
  97. $parent_id = $rows['parent_id'];

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

  101. $cat_name = $GLOBALS['db']->getOne($sql1);
  102. //echo $cat_name;exit;
  103. $child_sql = 'SELECT cat_id, cat_name, parent_id, is_show ' .
  104. 'FROM ' . $GLOBALS['ecs']->table('category') .
  105. "WHERE parent_id = '$parent_id' AND is_show = 1 ORDER BY sort_order ASC, cat_id ASC";
  106. $res = $GLOBALS['db']->getAll($child_sql);
  107. foreach ($res AS $row)
  108. {
  109. if ($row['is_show'])

  111. $three_arr[$row['cat_id']]['id']= $row['cat_id'];
  112. $three_arr[$row['cat_id']]['name'] = $row['cat_name'];
  113. $three_arr[$row['cat_id']]['url']= build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']);
  114. }
  115. }
  116. //$arr['cat_list'] = $three_arr;
  117. //$arr['cat_name'] = $cat_name;
  118. //print_r($three_arr);exit;
  119. return $three_arr;
  120. }
复制代码

能不能用判断来做？判断是第几级分类，然后修改样式？