📄 user_sc.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=usercookies.asp-->
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>我的收藏夹</title>
<link rel="stylesheet" type="text/css" href="1.CSS">
</head>
<SCRIPT language=JavaScript>
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>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="778" height="371">
<tr>
<td width="778" colspan="4" height="46"><!--#include file=top.asp--></td>
</tr>
<tr>
<td width="157" height="299" valign="top"><br>
<!--#include file=userleft.asp--></td>
<td width="10" height="299" background="img/line_01.gif"> </td>
<td width="603" height="299" valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="111">
<FORM name=thisForm action="user_scchk.asp" method=POST>
<tr>
<td width="94%" height="1" colspan="5"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="26">
<tr>
<td width="100%" background="img/mysc.gif" height="26"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="6%" height="27" align="center" background="img/bar_bg3.gif">
<p>编号</td>
<td width="59%" height="27" align="center" background="img/bar_bg3.gif">
标 题</td>
<td width="15%" height="27" align="center" background="img/bar_bg3.gif">
发布人</td>
<td width="17%" height="27" align="center" background="img/bar_bg3.gif">
收藏时间</td>
<td width="4%" height="27" align="center" background="img/bar_bg3.gif">
</td>
</tr>
<%
dim username,rs,sql,i,rs1,sql1,b,bb
dim ThisPage,Pagesize,Allrecord,Allpage
i=1
if request("page")="" then
ThisPage=1
else
ThisPage=request("page")
end if
username=request.cookies("ijob")("username")
set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from [shoucang] where username='"&username&"' order by scsj desc"
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td></td><td><li>没有收藏记录</td></tr>"
else
rs.Pagesize=21
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
do while not rs.eof
%>
<tr>
<td width="6%" height="25" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=i%>
</td>
<%
set rs1 = Server.CreateObject("ADODB.RecordSet")
sql1="select biaoti,name,a,b from [xinxi] where id="&cstr(rs("scid"))
rs1.open sql1,conn,1,1
b=trim(rs1("b"))
bb=len(b)
On Error Resume Next
%>
<td width="59%" height="25" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<p align="left"><a target="_blank" href="xinximemo.asp?ijob=<%=rs("scid")%>"><%if rs1("a")="0" then%><%=rs1("biaoti")%><%else%><font color="#<%=rs1("a")%>"><%=rs1("biaoti")%></font><%end if%></a><%if b<>0 then%><img src="images/num/jsq.gif"><%for i=1 to bb%><img src="images/num/<%=Mid(b,i,1)%>.gif"><%next%><%end if%>
</td>
<td width="15%" height="25" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=rs1("name")%>
</td>
<%
rs1.close
set rs1=nothing
%>
<td width="17%" height="25" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<%=datevalue(rs("scsj"))%>
</td>
<td width="4%" height="25" align="center" bordercolor="#E1E1E1" style="border-bottom-style: solid; border-bottom-width: 1">
<input type="checkbox" name="selectedid" value="<%=rs("id")%>"></td>
</tr>
<%
i=i+1
rs.movenext
if i>=Pagesize then exit do
loop
end if
%> <tr>
<td width="99%" height="25" colspan="5">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td height="25" width="151">
<p align="center">
</td>
<td height="25" width="126">
<p align="center"> </td>
<td height="25" width="118">
<p align="right"> </td>
<td height="25" width="200">
<p align="center">
<INPUT onclick=CheckAll(this.form) type=checkbox value=on name=chkall>选中所有记录
<input onclick=javascript:showoperatealert(1) type="submit" value="删除" name="B1"></td>
</tr>
<tr>
<td height="25" width="151" align="center">
共有 <font color="#CC5200"><%=Allrecord%></font> 条记录</td>
<td height="25" width="126" align="center">
共 <font color="#CC5200"><%=Allpage%></font> 页</td>
<td height="25" width="118" align="center">
现在是第
<font color="#CC5200"><%=ThisPage%></font> 页</td>
<td height="25" width="200" align="center">
<%
if ThisPage<2 then
response.write "<font color=""#808080"">首页</font> "
response.write "<font color=""#808080"">上一页</font> "
else
response.write "<a href=?page=1>首页</a> "
response.write "<a href=?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=?page="&(ThisPage+1)&">下一页</a> "
response.write "<a href=?page="&Allpage&">尾页</a> "
end if
%></td>
</tr>
<tr>
<td height="25" width="595" colspan="4">
<p align="right"> </td>
</tr>
</table>
</td>
</tr>
</form>
</table>
</td>
<td width="8" height="299" background="img/line_01.gif"> </td>
</tr>
<tr>
<td width="778" height="26" colspan="4"><!--#include file=copywright.asp--></td>
</tr>
</table>
</center>
</div>
</body>
</html>
<%
rs.close
set rs=nothing
closedb
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -