ECshop首页调用产品评论

方法一：

首先：在index.php文件中定义取得评论的函数 
 

 

 /**
 * 获得最新的评论列表。
 *
 * @access  private
 * @return  array
 */
function get_mycomments($num)
{
  @$sql = 'SELECT * FROM ecs_comment '.
            ' WHERE status = 1 AND parent_id = 0 AND comment_type=0 AND comment_rank!=0'.
            ' ORDER BY add_time DESC';
  if ($num > 0)
  {
   $sql .= ' LIMIT ' . $num;
  }   
  $res = $GLOBALS['db']->getAll($sql);
  $comments = array();
  foreach ($res AS $idx => $row)
  {

   $comments[$idx]['user_name']       = $row['user_name'];
   $comments[$idx]['content']       = $row['content'];
            $comments[$idx]['id_value']       = $row['id_value'];

  }
  return $comments;
}

 

 

以及定义给模板$smarty->assign('my_comments',    get_mycomments(5)); // ‘5’代表首页显示5条评论
在首页index.dwt中调用显示：
 

 

 <!--用户评论开始-->
<ul>
<!--{foreach from=$my_comments item=comments}-->
      <li><a href="goods.php?id={$comments.id_value}">{$comments.content|truncate:10:""}</a></li>
     <!--{/foreach}-->
 </ul>
<!--评论结束-->

 

方法二：

在库目录里增加一个文件:comment.lbi 里面有内容如下:

 

 
<?php
if(!function_exists("get_comments")){
function get_comments($num)
{
   $sql = 'SELECT a.*,b.goods_id,b.goods_thumb,b.goods_name FROM '. $GLOBALS['ecs']->table('comment') .
            ' AS a,'. $GLOBALS['ecs']->table('goods') .'AS b WHERE a.status = 1 AND a.parent_id = 0 and a.comment_type=0 and a.idvalue=b.goods_id '.
            ' ORDER BY a.add_time DESC';
  if ($num > 0)
  {
   $sql .= ' LIMIT ' . $num;
  }
  //echo $sql;
        
  $res = $GLOBALS['db']->getAll($sql);
  $comments = array();
  foreach ($res AS $idx => $row)
  {
   $comments[$idx]['add_time']       = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
   $comments[$idx]['content']       = $row['content'];
   $comments[$idx]['id_value']       = $row['id_value'];
   $comments[$idx]['goods_thumb']  = get_image_path($row['goods_id'], $row['goods_thumb'], true);
   $comments[$idx]['goods_name']       = $row['goods_name'];
  }
  return $comments;
}
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!--数据调用-最新评论开始 -->       
<?php
   $this->assign('my_comments',get_comments(6)); // 数据条数
?>
<!--{foreach from=$my_comments item=comments}-->
<table width="546" border="0" cellspacing="0" cellpadding="0" style=" border-bottom:1px #ccc dashed;">
  <tr>
    <td width="73" height="70" align="center"><a href="goods.php?id={$comments.id_value}" target="_blank"><img src="{$comments.goods_thumb}" border="0" width="60" height="60" style=" border:1px #CCCCCC solid;"/></a></td>
    <td width="473" align="left" valign="top">
<div style="height:3px; overflow:hidden;">&nbsp;</div>
<div><a href="goods.php?id={$comments.id_value}" target="_blank"><font style=" color:#FF0000; font-size:14px;">{$comments.goods_name}</font></a></div>
<div><img src="../images/pl.gif" width="38" height="19" align="absmiddle">{$comments.content|truncate:100:""}</div>
<div style="color:#999999;">时间：{$comments.add_time}</div>
</td>
  </tr>
</table>
   <!--{/foreach}-->
 

 

 

 

首页调用这个库文件就ok了

 

 
<!-- #BeginLibraryItem "/library/comment.lbi" -->  <!-- #EndLibraryItem -->

<!--EndFragment-->