织梦dedecms转易优cms后tag链接保持统一的方法

”;

//利用关键字查询tag，获取包含tag的文档aid

$sql = “ｓｅｌｅｃｔ aid from ey_taglist where tag=’$b”;

$retval = mysqli_query($conn,$sql);

$num1=mysqli_num_rows($retval);

if ($num1>10){

$sql = “ｓｅｌｅｃｔ aid from ey_taglist where tag=’$b’ order by aid desc limit $min,10 “;}

else{

$sql = “ｓｅｌｅｃｔ aid from ey_taglist where tag=’$b’ order by aid desc limit 10 “;

}

$retval = mysqli_query($conn,$sql);

$num=mysqli_num_rows($retval);

for ($i=0; $i <$num1 ; $i++)

{

$row=mysqli_fetch_array($retval);

$aid=$row[‘aid’];

//利用aid查询typeid title seo_description

$sql1 = “ｓｅｌｅｃｔ * from ey_archives where aid=’$aid”;

$retval1 = mysqli_query($conn,$sql1);

$row1=mysqli_fetch_array($retval1);

$title=$row1[‘title’];

$typeid=$row1[‘typeid’];

$add_time=date(‘Y-m-d’,$row1[‘add_time’]);

$seo_description=$row1[‘seo_description’];

//利用typeid查询文档所在目录,拼接文档URL

$click=rand(111,999);//随机阅读变量

if (!empty($typeid)){

$sql2 = “ｓｅｌｅｃｔ dirpath from ey_arctype where id=’$typeid”;

$retval2 = mysqli_query($conn,$sql2);

$num=mysqli_num_rows($retval);

$row2=mysqli_fetch_assoc($retval2);

$dirpath=$row2[‘dirpath’];

echo “

• 

  $title

  $seo_description…$click 人阅读发布时间：$add_time

”;

}

}

echo “

//翻页变量定义

$pre=$page-1;

if ($pre<=0){

$pre=1;

}

$next=$page+1;

$end=ceil($num1/10);

if($end==0){

echo “”;

}

if ($end==1){

$page==$end;

}

//定义每页页码数

$pagesize=5;

if ($page+$pagesize<$end){

$pageno=$page+$pagesize;

}

else{

$pageno=$end+1;

}

if ($page==1 or empty($page))

{

echo “