ECshop首頁調(diào)用最新評論的辦法

2024-07-09 22:56:35

字體：大中小

供稿：網(wǎng)友

<?php
if(!function_exists("get_comments")){
function get_comments($num)
{
   $sql = 'SELECT * FROM ecs_comment '.
            ' WHERE status = 1 AND parent_id = 0 and comment_type=0 '.
            ' ORDER BY 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]['user_name']       = $row['user_name'];
   $comments[$idx]['content']       = $row['content'];
   $comments[$idx]['id_value']       = $row['id_value'];
}
return $comments;
}
}
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
       
    <?php
        $this->assign('my_comments',get_comments(6)); // 6代表會條數(shù)據(jù)
    ?>
<div id="promotion">
<div class="sortbg">
    <div id="comments_left"></div>
    <div id="comments_right"></div>
</div>
<div class="sort">
    <ul   style="padding-left:8px">
      
      <li><a href="goods.php?id={$comments.id_value}" target="_blank">{$comments.content|truncate:10:""}</a></li>
      
    </ul>
</div>
</div>

首頁調(diào)用這個庫文件就OK了.

樣式大家自己根據(jù)網(wǎng)店的風格調(diào)整下！

上一篇：ECshop商品詳情頁顯示折扣、節(jié)省的方法

下一篇：ecshop中g(shù)t 與 lt 是什么意思