📄 mysubs.php
字号:
<?
$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");
if($_GET[delid]){
$sql="delete from dingyue where id='$_GET[delid]' and userid='$_COOKIE[userid]'";
mysql_query($sql);
}
?>
<div align="center">
<table width="770" bgcolor="#FFFFFF" >
<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"> </td>
</tr>
</table></td>
</tr>
</table>
</div>
<div align="center">
<table width="770" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> <span style="font-weight: bold; font-size: 18px;">订阅管理: </span></td>
</tr>
</table>
</div>
<div align="center">
<table width="770" border="1" bordercolor="#0066CC" bgcolor="#FFFFFF" style="border-collapse:collapse ">
<tr>
<td> 此处你可以订阅某个会员的帖子,或者订阅某个标签的帖子。 </td>
</tr>
</table>
</div>
<div align="center">
<table width="770" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<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>
</div>
<div align="center">
<form name="form1" method="post" action="searchuser.php" style="margin-bottom:0;margin-top:0">
<table width="770" border="0" cellpadding="4" cellspacing="0" bgcolor="#FFFFFF" >
<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>
</div>
<div align="center">
<table width="770" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF">
<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>
</div>
<div align="center">
<form name="form1" method="post" action="searchtag.php" style="margin-bottom:0;margin-top:0">
<table width="770" border="0" cellpadding="3" cellspacing="0" bgcolor="#FFFFFF" >
<tr height="30">
<td>标签:
<input type="text" name="tag" id="tag">
<input type="submit" name="Submit" value="搜索"></td>
</tr>
</table>
</form>
</div>
<div align="center">
<table width="770" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="300" align="left" valign="top">
<table width="770" cellpadding="3" cellspacing="1" class='side'>
<tr>
<td width="104" bgcolor="#006699"><span style="color: #ffffff; font-weight: bold;">会员帐号</span></td>
<td width="582" bgcolor="#006699" style="font-weight: bold"><font color="#FFFFFF">订阅的标签名</font></td>
<td width="72" bgcolor="#006699"><span style="color: #ffffff; font-weight: bold;">操作</span></td>
</tr>
<?
$rcperpage=12;
$page=$_GET[page];
if(!$page){
$page=1;
}
$tsql="select count(*) as c dingyue where userid='".$userid."'";
$pgcount=$_GET[pacount];
if(!$pgcount){
$tqr=mysql_query($tsql);
$total=mysql_fetch_array($tqr);
$pgcount=floor((chop($total[0])-1)/$rcperpage)+1;
}
$sql="select * from dingyue where userid='".$userid."' limit ".trim(($page-1)*$rcperpage).",$rcperpage";
$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="104" ><? if($rs[suserid]!=""){?><a href="userzhai.php?zhaiuser=<? echo $rs[suserid];?>"><? echo $rs[suserid];?></a><? }?></td>
<td width="582" ><? if($rs[tags]!=""){
if($rs[tags]=="全部分类"){
?>
<a href="userzhai.php?zhaiuser=<? echo $rs[suserid];?>"><? echo $rs[tags];?></a>
<?
}
else
{
$tags=explode("|",$rs[tags]);
for($oo=0;$oo<count($tags);$oo++){
if($tags[$oo]!=""){
?>
<a href="userzhai.php?zhaiuser=<? echo $rs[suserid];?>&tag=<? echo $tags[$oo];?>"><? echo $tags[$oo];?></a>
<?
}
}
}
}
?></td>
<td width="72" ><a href="?delid=<? echo $rs[id];?>">删除</a></td>
</tr>
<?
}
?>
</table>
<br>
第
<? echo $page;?>
页 共
<? echo $pgcount;?>
页
<?
if($page>1){
echo(" <a href='?page=1&pgcount=$pgcount'>第一页</a>");
echo(" <a href='?pgcount=$pgcount&page=".($page-1)."'>上一页</a>");
}else{
echo(" 第一页");
echo(" 上一页");
}
if($page < $pgcount){
echo(" <a href='?pgcount=$pgcount&page=".($page+1)."'>下一页</a>");
echo(" <a href='?pgcount=$pgcount&page=".$pgcount."'>最末页</a>");
}else{
echo(" 下一页");
echo(" 最末面");
}
;?>
</td>
</tr>
</table>
</div>
<? include("bottom.php");?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -