📄 advicelist.asp

📁 一个互联网络公司网站源码

💻 ASP

字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>文章添加</title>
<link href="../images/css.css" rel="stylesheet" type="text/css">
<!--#include file="../conn.asp" -->
</head>

<body>
<div class="div1">
<table width="100%" border="0" cellspacing="1">
  <tr class="tb_title">
    <td colspan="7">总裁信箱</td>
  </tr>
  <tr class="tb_head">
    <td width="56" align="right">&nbsp;</td>
    <td width="169" align="center">问题类型</td>
    <td width="88" align="center">姓名</td>
    <td width="169" align="center">联系电话</td>
    <td width="137" align="center">信箱</td>
    <td width="163" align="center">是否查看过</td>
    <td width="157" align="center">操作</td>
  </tr>
  <%
  	sql="select * from advice where 1=1 order by id desc"
  	set rs=server.CreateObject("adodb.recordset")
	rs.open sql,conn,1,1
	currentPage=Request.QueryString("page")
	if not isnumeric(currentPage) then
		currentPage=1
	end if
	currentPage=cint(currentPage)
	if currentPage<1 then
		currentPage=1
	end if
	if currentPage>rs.pagecount then
		currentPage=rs.pagecount
	end if
	PageCounts=rs.pagecount
	recordCounts=Rs.RecordCount
	if not rs.eof then
		rs.absolutepage=currentPage
	for i=1 to rs.recordcount
	if rs.eof then exit for
  %>
  
  <tr class="tr_list1">
    <td align="right">&nbsp;</td>
    <td><%=rs("stype")%></td>
    <td><%=rs("userName")%></td>
    <td><%=rs("phone")%></td>
    <td><%=rs("email")%></td>
    <td align="center"><%if rs("isview")=1 then%>
是
  <%else%>
否
<%end if%></td>
    <td align="center"><a href="adviceview.asp?id=<%=rs("id")%>">查看</a> <a href="adviceDel.asp?id=<%=rs("ID")%>">删除</a></td>
  </tr>
  <%
  	rs.movenext
	next
	rs.close
  %>
  <tr class="tr_list1">
    <td colspan="7" align="right"><!--#include file="../turnpage.asp" --></td>
  </tr>
  
 <%else%>
  <tr class="tr_list1">
    <td colspan="7" align="center">没有检索到数据</td>
  </tr>
 <%end if%>
</table>
</div></body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -