織夢dedecms轉易優cms后tag鏈接保持統一的方法
織夢cms轉換為易優cms后tag鏈接發生了改變,這對seo優化有影響,如何統一tag呢?按照下面的代碼重新改造一下:
require (“db.php”);
//定義url,不帶后面的斜杠
$url=”http://127.0.0.1″;
//獲取當前URI開始
$uri= iconv(“gb2312″,”UTF-8″,$_SERVER[‘REQUEST_URI’]);
$result = substr($uri,0,strrpos($uri,”?”));
if(!empty($result)){
$a=urldecode($result);
$b=substr($a,10);
}
else{
$res=urldecode($uri);
$b=substr($res,10);
}
//獲取page開始
if(!isset($_GET[‘page’])or($_GET[‘page’])<=0 ){
$page=1;
}
else{
$page=$_GET[‘page’];
}
$min=$page*10-10;
include “head1.html”;
echo “
echo “”;
echo “”;
echo “
”;
include “head2.html”;
//判斷tag不為空時輸出
if(!empty($b)){
//面包屑
echo “
”;//右側標簽開始
//熱門標簽
echo “
TAG標簽
熱門標簽
- ”;
- $tag ”;
$sql = “select tag,count from ey_tagindex order by count desc limit 40 “;
$retval = mysqli_query($conn,$sql);
$num=mysqli_num_rows($retval);
for ($i=0; $i <$num ; $i++)
{
$row=mysqli_fetch_array($retval);
$count=$row[‘count’];
$tag=$row[‘tag’];
echo “
}
echo “
//隨機標簽
echo “
隨機標簽
- ”;
- $tag ”;
$sql = “select tag from ey_tagindex order by rand() limit 40 “;
$retval = mysqli_query($conn,$sql);
$num=mysqli_num_rows($retval);
for ($i=0; $i <$num ; $i++)
{
$row=mysqli_fetch_array($retval);
$tag=$row[‘tag’];
echo “
}
echo “
//周排行
echo “
本周排行
- ”;
- $tag ”;
$sql = “select tag from ey_tagindex order by weekcc desc limit 40 “;
$retval = mysqli_query($conn,$sql);
$num=mysqli_num_rows($retval);
for ($i=0; $i <$num ; $i++)
{
$row=mysqli_fetch_array($retval);
$tag=$row[‘tag’];
echo “
}
echo “
//月排行
echo “
本月排行
- ”;
- $tag ”;
$sql = “select tag from ey_tagindex order by monthcc desc limit 40 “;
$retval = mysqli_query($conn,$sql);
$num=mysqli_num_rows($retval);
for ($i=0; $i <$num ; $i++)
{
$row=mysqli_fetch_array($retval);
$tag=$row[‘tag’];
echo “
}
echo “
//右側標簽結束
echo”
- ”;
$title
$seo_description…$click 人閱讀發布時間:$add_time
”;
//利用關鍵字查詢tag,獲取包含tag的文檔aid
$sql = “select aid from ey_taglist where tag=’$b”;
$retval = mysqli_query($conn,$sql);
$num1=mysqli_num_rows($retval);
if ($num1>10){
$sql = “select aid from ey_taglist where tag=’$b’ order by aid desc limit $min,10 “;}
else{
$sql = “select 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 = “select * 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 = “select 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 “
}
}
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 “
}
else{
//首頁末頁判斷提示
if ($page>=$end){