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

2019独角兽企业重金招聘Python工程师标准>>>

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

1. 
   
2. CREATE TABLE `sc_history` (
   
3. `id` int(10) unsigned NOT NULL auto_increment,
   
4. `user_id` int(10) unsigned NOT NULL,
   
5. `goods_id` int(10) NOT NULL,
   
6. PRIMARY KEY (`id`)
   
7. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

复制代码

首先在goods.php中找到

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

复制代码

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

1. 
   
2. insert_db_history()；
   
3. function insert_db_history()
   
4. {
   
5. $str = ”;
   
6. $res = array();
   
7. $sql = “select goods_id from “.$GLOBALS['ecs']->table(‘history’);
   
8. $res = $GLOBALS['db']->getAll($sql);
   
9. $ins = ”;
   
10. foreach($res as $key=>$val){
    
11. $ins .= $val['goods_id'].’,';
    
12. }
    
13. $ins = rtrim($ins,’,');
    
14. if (!empty($ins))
    
15. {
    
16. $where = db_create_in($ins, ‘goods_id’);
    
17. $sql = ‘SELECT goods_id, goods_name, goods_thumb, shop_price FROM ‘ . $GLOBALS['ecs']->table(‘goods’) .
    
18. ” WHERE $where AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0″;
    
19. $query = $GLOBALS['db']->query($sql);
    
20. $res = array();
    
21. while ($row = $GLOBALS['db']->fetch_array($query))
    
22. {
    
23. $goods['goods_id'] = $row['goods_id'];
    
24. $goods['goods_name'] = $row['goods_name'];
    
25. $goods['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
    
26. $goods['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);
    
27. $goods['shop_price'] = price_format($row['shop_price']);
    
28. $goods['url'] = build_uri(‘goods’, array(‘gid’=>$row['goods_id']), $row['goods_name']);
    
29. $res[] = $goods;
    
30. }
    
31. }
    
32. $GLOBALS['smarty']->assign(‘db_history’,$res);//
    
33. $output = $GLOBALS['smarty']->fetch(‘library/db_history.lbi’);
    
34. return $output;
    
35. }

复制代码

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

转载于:https://my.oschina.net/u/561668/blog/69045