帝国cms猜你喜欢功能代码

网站制作开发经常会使用到猜你喜欢这个功能，现分享出来。

//猜你喜欢
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;
}

使用方法