Question

ECshop如何调用bbs数据

首先一点就是我们要保证bbs的表和我们ECshop的表在一个库的情况下：1、$subject_list = $db->getAll("select tid,subject,dateline from cdb_post where fid=54 limit 0,10");foreach($subject_list as $idx=>$value){ $subject_list[$idx]['subject'] = sub_str($value['subject'],8);//字符串截取 $subject_list[$idx]['dateline'] = date($GLOBALS['_CFG']['date_format'], $value['dateline']);//格式化时间}$smarty->assign('subject_list',$subject_list);贴到.php2、{$list.subject}{$list.dateline}

Answer 1

前提 保证bbs的表和我们ecshop的表在一个库的情况下

 

1、

 

$subject_list = $db->getAll("select tid,subject,dateline from cdb_post where fid=54 limit 0,10");
foreach($subject_list as $idx=>$value)
{
            
        $subject_list[$idx]['subject'] = sub_str($value['subject'],8);//字符串截取
            
        $subject_list[$idx]['dateline'] = date($GLOBALS['_CFG']['date_format'], $value['dateline']);//格式化时间
            
}
            
$smarty->assign('subject_list',$subject_list);

 

 

贴到.php

 

 

 

 

2、

 

 

<!-- {foreach from=$subject_list item=list } -->
     
<li><a href="bbs/forum.php?mod=viewthread&tid={$list.tid}" target="_blank">{$list.subject}</a><span>{$list.dateline}</span></li>
     
<!-- {/foreach} -->

Answer 2

再装不就好了吗？