ecshop调用指定分类下分类
//**在文件 includes/lib_goods.php 最后加上 //*** 调用商品分类指定分类下级分类 function get_parent_id_tree($parent_id) { $three_c_arr = array(); $sql = 'SELECT count(*) FROM ' . $GLOBALS['ecs']->table('category') . " WHERE parent_id = '$parent_id' AND is_show = 1 "; if ($GLOBALS['db']->getOne($sql)) { $child_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($child_sql); foreach ($res AS $row) { if ($row['is_show']) $three_c_arr[$row['cat_id']]['id'] = $row['cat_id']; $three_c_arr[$row['cat_id']]['name'] = $row['cat_name']; $three_c_arr[$row['cat_id']]['url'] = build_uri('category', array('cid' => $row['cat_id']), $row['cat_name']); } } return $three_c_arr; }
声明后用$smarty调用,就是在index.php中加上:
$smarty->assign('get_parent_id1_tree', get_parent_id_tree(1));//调用父级分类1的下级分类
在index.dwt模板文件里开始调用了
<!--{foreach from=$get_parent_id1_tree item=list}-->
<a href="{$list.url}" target="_blank">{$list.name|truncate:15:true}</a>
| <!--{/foreach}--></div>
转:http://www.heheseo.com/News.asp?ID=117