ecshop增加浏览过该商品的人还浏览了那些商品功能

这个功能比较简单但是需要增加一个数据表

CREATE TABLE `sc_history` ( `id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL, `goods_id` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

复制代码 首先在goods.php中找到

/*更新浏览历史*/ $sql = “select count(*) from “.$GLOBALS[‘ecs’]->table(‘history’).” where goods_id=’$goods_id’”; $num = $GLOBALS[‘db’]->getOne($sql); if(empty($num)){ $user_id = !empty($_SESSION[‘user_id’])?intval($_SESSION[‘user_id’]):0; $sql = “insert into “.$GLOBALS[‘ecs’]->table(‘history’).” (goods_id,user_id) values(‘$goods_id’,’$user_id’)”; $GLOBALS[‘db’]->query($sql); }

复制代码 将浏览的商品放入数据库。在 lib_insert中增加一个函数

insert_db_history()； function insert_db_history() { $str = ”; $res = array(); $sql = “select goods_id from “.$GLOBALS[‘ecs’]->table(‘history’); $res = $GLOBALS[‘db’]->getAll($sql); $ins = ”; foreach($res as $key=>$val){ $ins .= $val[‘goods_id’].’,’; } $ins = rtrim($ins,’,’); if (!empty($ins)) { $where = db_create_in($ins, ‘goods_id’); $sql = ‘SELECT goods_id, goods_name, goods_thumb, shop_price FROM ‘ . $GLOBALS[‘ecs’]->table(‘goods’) . ” WHERE $where AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0″; $query = $GLOBALS[‘db’]->query($sql); $res = array(); while ($row = $GLOBALS[‘db’]->fetch_array($query)) { $goods[‘goods_id’] = $row[‘goods_id’]; $goods[‘goods_name’] = $row[‘goods_name’]; $goods[‘short_name’] = $GLOBALS[‘_CFG’][‘goods_name_length’] > 0 ? sub_str($row[‘goods_name’], $GLOBALS[‘_CFG’][‘goods_name_length’]) : $row[‘goods_name’]; $goods[‘goods_thumb’] = get_image_path($row[‘goods_id’], $row[‘goods_thumb’], true); $goods[‘shop_price’] = price_format($row[‘shop_price’]); $goods[‘url’] = build_uri(‘goods’, array(‘gid’=>$row[‘goods_id’]), $row[‘goods_name’]); $res[] = $goods; } } $GLOBALS[‘smarty’]->assign(‘db_history’,$res);// $output = $GLOBALS[‘smarty’]->fetch(‘library/db_history.lbi’); return $output; }

复制代码 在增加一个db_history.lbi就完成了所有功能了。如果你想添加到任何页面的话值需要将{insert name=”db_history”}增加到你需要的位置就可以了。但是这个功能会导致你的数据表一直增加，所以适用于商品不是太多的网站，如果商品多的话只要定时更新数据表即可。有一种旅行，叫单车旅行。它没有奢侈准备，

相关文章：

你感兴趣的文章：

标签云：