ecshop首页调用评论及图片

１、在library文件夹中建立一个名为index_comment.lbi文件

2、输入以下代码

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?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.id_value=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;
}
}
?>
<?php
   $this->assign('my_comments',get_comments(8)); // 数据条数
?>
<div>
  <h1> 顾客评论 </h1>
  <div>
    <!-- {foreach from=$my_comments item=comments} -->
    <dl>
      <dt><a href="goods.php?id={$comments.id_value}" target="_blank"><img src="{$comments.goods_thumb}" alt="" /></a></dt>
      <dd><a href="goods.php?id={$comments.id_value}" style="color:#FF6400; font-weight:bold">名称：{$comments.goods_name}</a></dd>
      <dd>{$comments.content|truncate:100:""}</dd>
      <dd>时间：{$comments.add_time}</dd>
    </dl>
    <!-- {/foreach} -->
  </div>
</div>

3、在index.dwt文件的评论的地方加入<!-- #BeginLibraryItem "/library/pl_y.lbi" -->  <!-- #EndLibraryItem -->

完成