[共享] 首页显示产品评论 新手分享 台灣, 醫健康, SBIR

eh99

1.首先 在../httpdocs/themes/lativ/library
   新增 index_comments.lbi 這個庫項目,

代碼如下

1. <?php
   
2. if(!function_exists("get_comments")){
   
3. function get_comments($num)
   
4. {
   
5. $sql = 'SELECT a.*,b.goods_id,b.goods_thumb,b.goods_name FROM '. $GLOBALS['ecs']->table('comment') .
   
6. ' AS a,'. $GLOBALS['ecs']->table('goods') .'AS b WHERE a.status = 1 AND a.parent_id =0 and a.comment_type=0 and a.id_value=b.goods_id '.
   
7. ' ORDER BY a.add_time DESC';
   
8. if ($num > 0)
   
9. {
   
10. $sql .= ' LIMIT ' . $num;
    
11. }
    
12. //echo $sql;
    
13. 
    
14. $res = $GLOBALS['db']->getAll($sql);
    
15. $comments = array();
    
16. foreach ($res AS $idx => $row)
    
17. {
    
18. $comments[$idx]['user_name'] = $row['user_name']; /*呼叫用戶名*/
    
19. $comments[$idx]['content'] = $row['content'];/*呼叫用戶評論*/
    
20. $comments[$idx]['id_value'] = $row['id_value'];
    
21. $comments[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);/*呼叫被評論的產品縮圖*/
    
22.    $comments[$idx]['goods_name'] = $row['goods_name'];/*呼叫被評論的產品名稱*/
    
23.   }
    
24. return $comments;
    
25. }
    
26. }
    
27. ?>
    
28. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    
29. <!--?? -->
    
30. 
    
31. <?php
    
32. $this->assign('my_comments',get_comments(10)); // /*呼叫評論數目*/
    
33. ?>
    
34. <marquee scrollamount="2.5" direction="right"> /*scrollamount=評論軸滑動速度；direction=產品縮圖跑的方向*/
    
35. <!--{foreach from=$my_comments item=comments}-->
    
36. <td width="65" height="50" align="left"><a href="goods.php?id={$comments.id_value}" target="_blank"><img src="{$comments.goods_thumb}" border="1" width="60" height="60" style=" border:1px #CCCCCC solid;"/></a></td>
    
37. <td width="130" align="left">
    
38. <div style="height:3px; overflow:hidden;"> </div>
    
39. <div>{$comments.user_name|truncate:100:""}</div>
    
40. <div><a href="goods.php?id={$comments.id_value}" target="_blank"><font style=" color:#FF0000; font-size:14px;">{$comments.goods_name}</font></a></div>
    
41. <div>{$comments.content|truncate:100:""}</div>
    
42. <div style="color:#999999;">{$comments.add_time}</div>
    
43. </td>
    
44. </tr>
    
45. <!--{/foreach}-->
    
46. </marquee>

复制代码

2.到 /httpdocs/themes/lativ 下，
  找到 index.dwt 檔案修改
  在第333行加入 下面程式碼呼叫 index_comments.lbi

1. <div style="margin-bottom:20px" id="focus">
   
2. <!-- #BeginLibraryItem "/library/index_comments.lbi" --><!-- #EndLibraryItem -->
   
3. </div>

复制代码

3.成功啦!www.eh99.com.tw  歡迎有問題可以問我喔!
  不過我這次針對框架中間的方法，由於俺還是新手其他例如右側左側上方的方法還沒研究出來；
希望有高手指導囉!

2014-6-13 16:11

shenqin

不错啊这样做得