📄 xinxi.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<link href="inc_style.css" rel="stylesheet" type="text/css">
<body topmargin="0" leftmargin="0">
<script>
function loadThreadFollow(t_id,b_id){
var targetImg =eval("document.all.followImg" + t_id);
var targetDiv =eval("document.all.follow" + t_id);
if ("object"==typeof(targetImg)){
if (targetDiv.style.display!='block'){
targetDiv.style.display="block";
}else{
targetDiv.style.display="none";
}
}
}
</script>
<SCRIPT language=JavaScript>
function showoperatealert(id)
{
if (id==1)
{
{
thisForm.target='_self';
thisForm.action="xinxi_yz.asp";
thisForm.submit();
}
}
if (id==2)
{
{
thisForm.target='_self';
thisForm.action="xinxi_del.asp";
thisForm.submit();
}
}
if (id==3)
{
{
thisForm.target='_self';
thisForm.action="xinxi_zd.asp";
thisForm.submit();
}
}
if (id==4)
{
{
thisForm.target='_self';
thisForm.action="xinxi_zddel.asp";
thisForm.submit();
}
}
if (id==5)
{
{
thisForm.target='_self';
thisForm.action="xinxi_yzdel.asp";
thisForm.submit();
}
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall' )
e.checked = form.chkall.checked;
}
}
//-->
</SCRIPT>
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="86%" height="1" bordercolor="#808000">
<tr>
<td width="100%" height="24" colspan="6">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="25">
<tr>
<td width="285" height="24">
<FORM name=sou1 action="?cnmai=1" method=POST>
<p align="center">按帐号：<input type="text" name="T1" size="10">
<input type="submit" value="查找" name="B1">
</form>
</td>
<td width="285" height="24">
<FORM name=sou2 action="?cnmai=2" method=POST>
<p align="center">按姓名：<input type="text" name="T2" size="10">
<input type="submit" value="查找" name="B1">
</form>
</td>
<td width="285">
<FORM name=sou3 action="?cnmai=3" method=POST>
<p align="center">按关键词：<input type="text" name="T3" size="10">
<input type="submit" value="查找" name="B1">
</form>
</td>
</tr>
<tr>
<td width="864" colspan="3" height="24">
<p align="center">
<%
dim dqrs,dqsql
set dqrs=server.createobject("ADODB.recordset")
dqsql="select * from class1 "
dqrs.open dqsql,conn,1,1
%>
<select size="1" name="diqu" onchange="location=this.options[this.selectedIndex].value">
<option selected>选择行业</option>
<% do while not dqrs.eof%>
<option value="xinxi.asp?hangye=<%=dqrs("id")%>&cnmai=8"><%=dqrs("class1")%></option>
<%dqrs.movenext
loop
dqrs.close%>
</select>---<a href="?cnmai=4">未(<font color="#FF0000">ⅹ</font>)验证信息</a>---<a href="?cnmai=5">已(√)验证的信息</a>---<font color="#FF0000"><a href="?cnmai=10">VIP信息</a>---<a href="?cnmai=11">非VIP信息</a>---<a href="?cnmai=12">置顶信息</a>---</font><a href="?cnmai="><font color="#FF0000">显示全部信息</font></a></td>
</tr>
</table>
</td>
</tr>
<FORM name=thisForm action="" method=POST>
<%
dim rs,sql,k,cnmai,hangye,diqu,j
dim ThisPage,Pagesize,Allrecord,Allpage
k=1
set rs = Server.CreateObject("ADODB.RecordSet")
cnmai=trim(request("cnmai"))
hangye=request("hangye")
diqu=request("diqu")
Select Case cnmai
Case "1"
sql="select * from [xinxi] where username='"&trim(request("T1"))&"' order by fbsj desc"
Case "2"
sql="select * from [xinxi] where name like '%"&trim(request("T2"))&"%' order by fbsj desc"
Case "3"
sql="select * from [xinxi] where biaoti like '%"&trim(request("T3"))&"%' or memo like '%"&trim(request("T3"))&"%' order by fbsj desc"
Case "4"
sql="select * from [xinxi] where yz<>1 order by fbsj desc"
Case "5"
sql="select * from [xinxi] where yz=1 order by fbsj desc"
Case "8"
sql="select * from [xinxi] where class1="&cint(hangye)&" order by fbsj desc"
Case "10"
sql="select * from [xinxi] where vip=1 order by fbsj desc"
Case "11"
sql="select * from [xinxi] where vip<>1 order by fbsj desc"
Case "12"
sql="select * from [xinxi] where zd=1 order by fbsj desc"
Case Else
sql="select * from [xinxi] order by fbsj desc"
End Select
rs.open sql,conn,1,1
if rs.eof then
response.write "<li>没有记录"
response.end
end if
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
rs.Pagesize=30
Pagesize=rs.Pagesize
Allrecord=rs.Recordcount
Allpage=rs.Pagecount
if ThisPage<1 then
ThisPage=1
end if
On Error Resume Next
rs.move (ThisPage-1)*Pagesize
%>
<tr>
<td width="5%" height="24" align="center" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666">选择</td>
<td width="47%" height="24" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666">标题</td>
<td width="8%" height="24" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666">
<p align="center">姓名</td>
<td width="19%" height="24" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666">
<p align="center">日期</td>
<td width="5%" height="24" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666">
<p align="center">验证</td>
<td width="5%" height="24" bgcolor="#FDD355" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#666666"> </td>
</tr>
<%
dim uid
do while not rs.eof
uid=rs("id")
%>
<tr>
<td width="5%" height="24" align="center" style="border-top-style: solid; border-top-width: 1">
<INPUT type=checkbox value="<%=uid%>" name=selectedid></td>
<td width="47%" height="24" style="border-top-style: solid; border-top-width: 1">
<font color="#0000FF">[<%
dim rshy
set rshy = Server.CreateObject("ADODB.RecordSet")
sql="select * from [class1] where id="&rs("class1")&""
rshy.open sql,conn,1,1
response.write ""&rshy("class1")&""
%>]</font><a target="_blank" href=<%=rshy("memopage")%>?cnmai=<%=uid%>><%=rs("biaoti")%></a><%if rs("zd")=1 then%><font color="#FF0000">[置顶]</font><%end if%><%if rs("vip")=1 then%><font color="#FF0000">[VIP]</font><%end if%></td>
<td width="8%" height="24" align="center" style="border-top-style: solid; border-top-width: 1"><a target="_blank" href=../user_zl.asp?username=<%=rs("username")%>><%=rs("name")%></td>
<td width="19%" height="24" align="center" style="border-top-style: solid; border-top-width: 1"><%=rs("fbsj")%></td>
<td width="5%" height="24" align="center" style="border-top-style: solid; border-top-width: 1"><%if rs("yz")=1 then%>√<%else%><b><font color="#FF0000">ⅹ</font></b><%end if%></td>
<td width="5%" height="24" style="border-top-style: solid; border-top-width: 1">
<p align="center"><font color="#FF0000"><span id="followImg<%=k%>" style="CURSOR: hand" onclick="loadThreadFollow(<%=k%>,5)">操作</span></font></td>
</tr>
<tr style="display:none" id="follow<%=k%>">
<td height="24" colspan="6" style="border-bottom-style: solid; border-bottom-width: 1" bgcolor="#FFF8EC">
<div align="center">
<center>
<table border="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" width="90%" height="100%">
<tr>
<td align="center"><a href="xinxi_del.asp?selectedid=<%=uid%>">
<font color="#0000FF">删除该信息</font></a></td>
<td align="center"><a href="xinxi_hfdel.asp?selectedid=<%=uid%>">删除所有回复</a></td>
<td align="center"><a href="<%=rshy("adminpage")%>?id=<%=uid%>">编辑该信息</a></td>
<td align="center"><a href="#" ONCLICK="window.open('xinximail.asp?id=<%=uid%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=355,height=328,left=300,top=100')">发送邮件</a></td>
<td width="160" align="center"><a target="_blank" title="查看发布IP" href="http://ip.wisa.com.cn/ipsearch.php?textfield=<%=rs("ip")%>">
<font color="#FF0000">发布者IP：<%=rs("ip")%></font></a></td>
<td align="center"><%if rs("zd")=0 then%><a href="xinxi_zd.asp?selectedid=<%=uid%>">置顶该信息</a><%else%><a href="xinxi_zddel.asp?selectedid=<%=uid%>">取消置顶</a><%end if%></td>
<td align="center"><%if rs("yz")=0 then%><a href="xinxi_yz.asp?selectedid=<%=uid%>">通过验证</a><%end if%></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
<%
rshy.close
set rshy=nothing
k=k+1
rs.movenext
if k>=Pagesize then exit do
loop
rs.close
set rs=nothing
closedb
%>
<tr>
<td width="100%" height="1" colspan="6" style="border-top-style: solid; border-top-width: 1">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="1">
<tr>
<td height="25" width="55%" colspan="3">
<p align="left">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有<input onclick=javascript:showoperatealert(1) type="submit" value="验证" name="B1">
<input onclick=javascript:showoperatealert(5) type="submit" value="取消验证" name="B5">
<input onclick=javascript:showoperatealert(2) type="submit" value="删除" name="B2">
<input onclick=javascript:showoperatealert(3) type="submit" value="置顶" name="B3" style="color: #FF0000">
<input onclick=javascript:showoperatealert(4) type="submit" value="取消置顶" name="B4"></td>
<td height="25" width="45%" colspan="2">
<p align="center">
</td>
</tr>
<tr>
<td height="25" width="17%" align="center">
共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td>
<td height="25" width="8%" align="center">
共 <font color="#CC5200"><%=Allpage%></font> 页</td>
<td height="25" width="30%" align="center">
现在是第
<font color="#CC5200"><%=ThisPage%></font> 页</td>
<td height="25" width="27%" align="center">
<%dim myurl,pageposition
myurl=Request.ServerVariables("QUERY_STRING")
if myurl<>"" then
pageposition=instr(myurl,"page")
if pageposition>0 then
myurl=left(myurl,pageposition-1)
else
myurl=myurl+"&"
end if
end if
if ThisPage<2 then
response.write "<font color=""#808080"">首页</font> "
response.write "<font color=""#808080"">上一页</font> "
else
response.write "<a href=?"&myurl&"page=1>首页</a> "
response.write "<a href=?"&myurl&"page="&ThisPage-1&">上一页</a> "
end if
if Allpage-ThisPage<1 then
response.write "<font color=""#808080"">下一页</font> "
response.write "<font color=""#808080"">尾页</font> "
else
response.write "<a href=?"&myurl&"page="&(ThisPage+1)&">下一页</a> "
response.write "<a href=?"&myurl&"page="&Allpage&">尾页</a> "
end if
%></td>
<td height="25" align="center" width="18%">
转到：<select size="1" name="page" onchange="location=this.options[this.selectedIndex].value">
<%for j=1 to allpage%>
<option value="?<%=myurl%>page=<%=j%>" <%if cint(thispage)=j then %> selected <%end if%>><%=j%></option>
<%next%>
</select>页</td>
</tr>
<tr>
<td height="1" width="595" colspan="5">
<p align="right"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" height="39" colspan="6" style="border-bottom-style: solid; border-bottom-width: 1" bordercolor="#999999">
<p align="center"><img style="CURSOR: hand" onclick=javascript:showoperatealert(1) border="0" src="img/ershou_2.gif">
<img style="CURSOR: hand" onclick=javascript:showoperatealert(2) border="0" src="img/ershou_1.gif"></td>
</tr>
</form>
<tr>
<td width="100%" height="1" colspan="6" style="border-top-style: solid; border-top-width: 1"></td>
</tr>
</table></center>
</div>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -