searchtag.php

PHP免费网摘程序 详细说明: 安装说明： 1、把文件上穿上去以后

<?
 
  $userid=$_COOKIE[userid];
 if($userid==""){
 
header("Location:login.php?tourl=myzhai");
 }
?>
<? include("conn.php");?>
<? include("include/setup.php");?>
<? include("include/function.php");?>
<? include("head.php");
 



<table width="760" align="center">
  <tr>
    <td><table width="360" height="27"  border="0" cellpadding="0" cellspacing="0">
      <tr align="center">
        <td width="80" class="<? echo $titlecss1;?>"><a href="./mysetup.php?type=basic">基本设置</a></td>
        <td width="80" class="<? echo $titlecss2;?>"><a href="./mysetup.php?type=bookmark"><font color="#FF0000">书签</font>设置</a></td>
        <td width="80" class="<? echo $titlecss3;?>"><a href="./mysetup.php?type=tags"><font color="#FF0000">标签</font>管理</a></td>
		<td width="80" class="<? echo $titlecss3;?>"><a href="mysubs.php"><font color="#FF0000">订阅</font>管理</a></td>
        <td width="80" class="<? echo $titlecss3;?>"><a href="whosubs.php"><font color="#FF0000">订户</font>管理</a></td>
		 
		 
		 <td class="bgtail">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<br>
<table width="770" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td><span style="font-weight: bold; font-size: 18px;">订阅管理： </span></td>
  </tr>
</table>
 
 <br>
 <table width="700" border="1" bordercolor="#0066CC" style="border-collapse:collapse ">
  <tr>
    <td> 此处你可以订阅某个会员的帖子，或者订阅某个标签的帖子。  </td>
  </tr>
</table>

  <br>
 
<table width="770" border="0" cellpadding="0" cellspacing="0">
 <tr>
    <td align="left"><span style="font-size: 14px; font-weight: bold;">按用户增加订阅:</span></td>
  </tr>
  <tr>
    <td align="left"><hr align="left" width="500" size="1"></td>
  </tr>
</table>


<form name="form1" method="post"   action="searchuser.php" style="margin-bottom:0;margin-top:0">
  <table width="770"  border="0" cellspacing="0" cellpadding="0" align="center">
    <tr height="30">
      <td>用户名：
      <input type="text" name="userid" id="userid"> 
       电子邮件：
       <input name="email" type="text" id="email">
      <input type="submit" name="Submit" value="搜索"></td>
    </tr>
  </table>
</form>

 <br>
 
 <table width="770" border="0" cellpadding="0" cellspacing="0">
 <tr>
    <td align="left"><span style="font-size: 14px; font-weight: bold;">按标签增加订阅:</span></td>
  </tr>
  <tr>
    <td align="left"><hr align="left" width="500" size="1"></td>
  </tr>
</table>


<form name="form1" method="post"  action="searchtag.php" style="margin-bottom:0;margin-top:0">
  <table width="770"  border="0" cellspacing="0" cellpadding="0" align="center">
    <tr height="30">
      <td>标签：
        <input type="text" name="tag" id="tag">
      <input type="submit" name="Submit" value="搜索"></td>
    </tr>
  </table>
</form>

 <br>
 <table width="770"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="400" align="left" valign="top">
<table width="500" cellspacing="1" class='side'>

<tr>
    <td width="176" bgcolor="#006699"><span style="color: #ffffff; font-weight: bold;">标签</span></td>
    <td width="152" bgcolor="#006699"><span style="color: #ffffff; font-weight: bold;">操作</span></td>
  </tr>
<?
    $rcperpage=20;  
		 $page=$_GET[page];
		if(!$page){
			$page=1;
		}

    if($_POST[tag]!=""){
	$tag=$_POST[tag];
	 }
    if($_GET[tag]!=""){
	$tag=$_GET[tag];
	 }
 
 
 


	if($tag!=""){
	
	$se=" and  tag like '%$tag%' ";
	 
	}
	 
   
  
     $sql="select * from tags  where id>0  $se group by tag  limit ".trim(($page-1)*$rcperpage).",$rcperpage";
     $tsql="select count(*) as c from tags  where id>0  $se  group by tag ";
 
		 
		 $pgcount=$_GET[pacount];
		 if(!$pgcount){
		 $tqr=mysql_query($tsql);
		 $total=mysql_fetch_array($tqr);
		  $pgcount=floor((chop($total[0])-1)/$rcperpage)+1; 
		 }
   
   $qr=mysql_query($sql);
   
   
  while($rs=mysql_fetch_array($qr)) {
  $oo=$oo+1;
  if($oo%2==0){$color="#F9F9F9";}else{$color="#FfFfFf";}
  ?>
   
 
  <tr bgcolor="<? echo $color;?>">
    <td width="176"  ><a href="userzhai.php?zhaiuser=<? echo $rs[tag];?>"><? echo $rs[tag];?></a></td>
    <td width="152"  ><a href="dtag.php?tag=<? echo $rs[tag];?>">订阅</a></td>
  </tr>
 

   
 <?
 }
 ?>
 
 

</table>
<br>
        第
              <? echo $page;?>
      页 共
      <? echo $pgcount;?>
      页
      <?			
			if($page>1){
				echo(" <a href='?userid=".$user."&email=$email&page=1&pgcount=$pgcount'>第一页</a>");
				echo(" <a href='?userid=".$user."&email=$email&pgcount=$pgcount&page=".($page-1)."'>上一页</a>");
			}else{
				echo(" 第一页");
				echo(" 上一页");
			}
			if($page < $pgcount){
				echo(" <a href='?userid=".$user."&email=$email&pgcount=$pgcount&page=".($page+1)."'>下一页</a>");
				echo(" <a href='?userid=".$user."&email=$email&pgcount=$pgcount&page=".$pgcount."'>最末页</a>");
			}else{

				echo(" 下一页");
				echo(" 最末面");
			}			
			;?> 
</td>
  </tr>
</table>

<? include("bottom.php");?>