方维分享系统首页，插入新品，用来做优化

index.dynamic.php 加如下函数

//add by wangtongphp 首页调用新品和tag标签
function wt_seo(){
    global $_FANWE;
    $sql = "select share_id,content from  ".FDB::table('share')." order by share_id desc limit 30";
    $res = FDB::query($sql);
    while($data = FDB::fetch($res))
    {
        $args['shangpin'] .=  '<a href="http://www.tiaowode.com/shangpin/'.$data['share_id'].'" title="'.$data['content'].'"> '.$data['content'].'</a> | ';
    }
    /*
    $sql = "SELECT * FROM fanwe_goods_tags AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(tag_id) FROM  fanwe_goods_tags )-(SELECT MIN(tag_id) FROM  fanwe_goods_tags ))+(SELECT MIN(tag_id) FROM   fanwe_goods_tags )) AS id) AS t2 WHERE t1.tag_id >= t2.id ORDER BY t1.tag_id LIMIT 20";
    $res = FDB::query($sql);
    while($data = FDB::fetch($res))
    {
        $args['tags'] .=  '<a href="http://www.tiaowode.com/gouwu/shopping?tag='.$data['tag_name'].'&from=search" title='.$data['tag_name'].' > '.$data['tag_name'].'</a> | ';
    }*/
    return tplFetch('inc/index/wt_seo',$args);
}

 

然后在inc/index/wt_seo.htm

 

在index_index.htm 中调用<!--{dynamic wt_seo}--> ；