ecshop实现用foreach的形式调用浏览历史

ecshop实现用foreach的形式调用浏览历史 Ecshop系统默认调用浏览历史是通过调用一个insert函数，并且html格式都是写入到这个 insert函数，以下我将它改写成像调用商品列用foreach的形式调用浏览历史 效果图 在lib_common.php中添加函数 /** * 调用浏览历史 by fenfenglee * * @access public * @return string */ function get_history_list() { $str = ''; if (!empty($_COOKIE['ECS']['history'])) { $where = db_create_in($_COOKIE['ECS']['history'], 'g.goods_id'); $sql = 'SELECT g.goods_id, g.goods_name, g.goods_thumb, g.shop_price, cat.cat_name, attr.attr_value FROM ' . $GLOBALS['ecs']->table('category') .' AS cat ,'.$GLOBALS['ecs']->table('goods') .' AS g LEFT JOIN '.$GLOBALS['ecs']->table('goods_attr') .' AS attr '. " ON g.goods_id=attr.goods_id AND attr.attr_id=166 WHERE g.cat_id= cat.cat_id AND $where AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0"; $query = $GLOBALS['db']->query($sql); $res = array(); $goods = array(); $l_key=0; while ($row = $GLOBALS['db']->fetch_array($query)) { $goods[$l_key]['goods_id'] = $row['goods_id']; $goods[$l_key]['goods_name'] = $row['goods_name']; $goods[$l_key]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name']; $goods[$l_key]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true); $goods[$l_key]['cat_name'] = $row['cat_name']; $goods[$l_key]['attr_value'] = $row['attr_value']; $goods[$l_key]['shop_price'] = price_format($row['shop_price']); $goods[$l_key]['url'] = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']); $l_key++; } } return $goods; } 然后在php文件中用smarty向模板传入数据,接下就可以用foreach按你的页面自由调用了 (怎么做，你懂的，这里就不多说了) 细心的朋友会发现，代码中有一段代码attr.attr_id=166，这表示什么意思呢,其实查看一下 数据库结构，可以发现这个表示 “化装品规格标识”，如果你的站是做化装品的，这段代码 挺实用的哦 更多请访问 fenfenglee 博客