ecshop里面添加文章点击次数
1、ALTER TABLE ecs_article ADD COLUMN clicks INT(10) DEFAULT 0;
2、可以设置一个基数在此基础上慢慢增长,不会让人觉得空.
UPDATE `ecshop`.`mz_article` SET `clicks` =365
3、接下来就是修改代码了,在article.php中找到下面的代码:
- $prev_aid = $db->getOne("SELECT max(article_id) FROM " . $ecs->table('article') . " WHERE article_id < $article_id AND cat_id=$article[cat_id] AND is_open=1");
- if (!emptyempty($prev_aid))
- {
- $prev_article = $db->getRow("SELECT article_id, title FROM " .$ecs->table('article'). " WHERE article_id = $prev_aid");
- $prev_article['url'] = build_uri('article', array('aid'=>$prev_article['article_id']), $prev_article['title']);
- $smarty->assign('prev_article', $prev_article);
- }
- assign_dynamic('article');
- }
- //添加下面的代码，
- clicks = $db->query('UPDATE ' . $ecs->table('article') . " SET clicks = clicks + 1 WHERE article_id = '$article_id'");
然后就是修改article.dwt了,也就是模板页面,在需要显示的位置修改添加下面代码
时间:{$article.add_time}浏览 {$article.clicks}次
好了大功告成了,刷新一下就ok了.
