第1步,在index.php的最后添加一个函数:
function index_get_comments()
{
$sql = ‘select c.content,c.add_time,g.goods_thumb,g.goods_id from ".$ecs->table('comment')." c , ".$ecs->table('goods')." g where g.goods_id = c.id_value and c.status = 1 order by c.add_time desc limit 5′;
$res = $GLOBALS['db']->getAll($sql);
$pvnewcomments = array();
foreach ($res AS $row)
{
$pvnewcomments[] = array(‘id_value’ => $row['id_value'],
‘user_name’ => $row['user_name'],
‘content’ => $row['content'],
‘add_time’ => date(“Y-m-d H:i:s”, $row['add_time']));
}
return $pvnewcomments;
}
第2步,在index.php中很多
$smarty->assign
那段添加一行:
$smarty->assign('pvnewcomments', index_get_comments());
第3步,在模板index.dwt中要调用最新评论的位置添加以下代码:
<!– {foreach from=$pvnewcomments item=idxcomment} –>
<div style=”margin: 8px 0 0 0;”>
<!– {if $idxcomment.user_name eq ”} –>
匿名用户
<!– {else} –>
{$idxcomment.user_name}
<!– {/if} –>
<span style=”color: #999; font-size: 10px;”>({$idxcomment.add_time})</span>
</div>
< div style=”padding: 0 0 8px 0; border-bottom: 1px dotted #ccc;”>
<a href=”goods.php?id={$idxcomment.id_value}”>{$idxcomment.content}</a>
</div>
< !– {/foreach} –>
如果需要在首页显示微缩图片则取{$idxcomment.goods_thumb}。