1、调用最新10个tag加TAG图片
<?
$tsql=$empire->query("select * from {$dbtbpre}enewstags order by tagid desc limit 10");
while($tr=$empire->fetch($tsql))
{
$tagurl=user_tagidurl($tr['tagid']);
$pic=$empire->fetch1("select tagpic from {$dbtbpre}daixiao360_tags where tagid=".$tr['tagid']." limit 1");
?>
<li><a href="<?=$tagurl?>"><img src="<?=$pic['tagpic']?$pic['tagpic']:''.$public_r['newsurl'].'e/data/images/notimg.gif'?>"><?=$tr['tagname']?><?=$tr['tagname']?></a>(<?=$tr['num']?>)</li>
<?
}
?>
2、按分类调用TAG
<?
$tsql=$empire->query("select * from {$dbtbpre}enewstagsclass where classid>0 order by classid desc");
while($tr=$empire->fetch($tsql))
{
$tagflurl=user_tagflurl($tr['classid']);
$pic=$empire->fetch1("select classpic from {$dbtbpre}daixiao360_tagsclass where classid=".$tr['classid']." limit 1");
?>
<div class="tag">
<h2><a href="<?=$tagflurl?>"><img src="<?=$pic['classpic']?$pic['classpic']:''.$public_r['newsurl'].'e/data/images/notimg.gif'?>"><?=$tr['classname']?></a></h2>
<p>
<?
$zsql=$empire->query("select * from {$dbtbpre}enewstags where cid='".$tr['classid']."' order by tagid desc limit 10");
while($zr=$empire->fetch($zsql)){
$tagurl=user_tagidurl($zr['tagid']);
?>
<a href="<?=$tagurl?>"><?=$zr['tagname']?></a>(<?=$zr['num']?>)
<?
}
?>
</p>
</div>
<?
}
?>
3、按照tag拼音字母顺序调用
<?php
$alphabetArray=array('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z');
$alphabetCount = count($alphabetArray);
?>
<div class="zmlist">
字母：
<?php
for($i = 0; $i < $alphabetCount; $i++)
{
?>
<a href="#<?=$alphabetArray[$i]?>"><?=strtoupper($alphabetArray[$i])?></a>
<?
}
?>
</div>
<div class="taglist">
<?php
for($i = 0; $i < $alphabetCount; $i++)
{
$letter = $alphabetArray[$i];
?>
<h3><a name="<?=$letter?>"><?=strtoupper($letter)?></a></h3>
<ul>
<?php
$zsql = $empire->query("select tagid from {$dbtbpre}daixiao360_tags where py like '".$letter."%' ORDER BY tagid DESC");
while($zr = $empire->fetch($zsql)){
$t = $empire->fetch1("select * from {$dbtbpre}enewstags where tagid='".$zr['tagid']."' LIMIT 1");
$tagurl = user_tagidurl($zr['tagid']);
?>
<li><a href="<?=$tagurl?>"><?=$t['tagname']?></a></li>
<?php
}
?>
</ul>
<?php
}
?>
</div>
4、在栏目页模板，根据tag分类绑定的栏目，调用此栏目下的TAG
<?php
if($navclassid)
{
$tsql=$empire->query("select * from {$dbtbpre}daixiao360_tagsclass where lmid='$navclassid'");
while($tr=$empire->fetch($tsql))
{
$cid=$tr['classid'];
$csql=$empire->query("select * from {$dbtbpre}enewstagsclass where classid='$cid' order by classid desc");
while($cr=$empire->fetch($csql))
{
$tagclassurl=user_tagflurl($cr['classid']);
?>
<div class="tag">
<h3><a href="<?=$tagclassurl?>"><?=$cr['classname']?></a></h3>
<ul>
<?
$dsql=$empire->query("select * from {$dbtbpre}enewstags where cid=".$cr['classid']." order by tagid desc limit 10");
while($dr=$empire->fetch($dsql))
{
$tagurl=user_tagidurl($dr['tagid']);
?>
<li><a href="<?=$tagurl?>"><?=$dr['tagname']?></a>(<?=$dr['num']?>)</li>
<?
}
?>
</ul>
</div>
<?
}
}
}
?>
以下是所属TAG静态插件链接https://www.daixiao360.cn/dgcj/417.html
