# 帝国cms如何实现帝国cms猜你喜欢功能

*Published:* 2025-04-25
*Author:* 客服001

#### 温馨提醒

如果文章内容或图片资源失效，请留言反馈，我们会及时处理，谢谢

本文最后更新于2025年4月25日，已超过 180天没有更新



使用方法：

将代码复制到e/class/userfun.php文件，然后在模板内调用sCainixihuan函数即可。

```
//猜你喜欢
function sCainixihuan($num=10){
    global $empire,$dbtbpre,$navinfor,$class_r;
    $tbname=$class_r[$navinfor[classid]]['tbname'];

    if($navinfor['keyid']){ //有相关信息
        $sql=$empire->query("select id,title,titleurl,titlepic,diggtop,classid from {$dbtbpre}ecms_".$tbname." where id in(".$navinfor['keyid'].") order by newstime desc limit $num");
    }else{ //无相关信息

        $ynum=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_{$tbname} WHERE classid='$navinfor[classid]' AND id!='$navinfor[id]'");
        if($ynum) {
            $sql = $empire->query("select id,title,titleurl,titlepic,diggtop,classid from {$dbtbpre}ecms_{$tbname} WHERE classid='$navinfor[classid]' AND id!='$navinfor[id]' ORDER BY rand() limit $num");
        }else{
            $sql = $empire->query("select id,title,titleurl,titlepic,diggtop,classid from {$dbtbpre}ecms_{$tbname} WHERE id!='$navinfor[id]' ORDER BY rand() limit $num");
        }
    }

    $data=array();
    while ($r=$empire->fetch($sql)) {
        $data[]=$r;
    }
    return $data;
}
```