📄 userdet.asp
字号:
<%@ language="vbscript" %>
<%if request("username")="" then
response.write "??óD???¨ó??§"
response.end
else
DbPath = SERVER.MapPath("db1.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sql="select * from user_info where username='"&trim(request("username"))&"' "
rs.open sql,conn
if rs.bof and rs.eof then
response.write "?ò2?μ??a??è?"
rs.close
conn.close
set rs=nothing
set conn=nothing
response.end
else
%>
<html>
<head>
<title>Untitled Document</title>
<style type="text/css">
<!--
p,a,td{font-size:12px;font-family:宋体,sans-serif;line-height:1.4}
.12{font-size:12px;font-family:宋体,sans-serif}
A:link {text-decoration: none}
A:visited {text-decoration: none}
A:active { text-decoration: underline}
A:hover {text-decoration: underline}
-->
</style>
</head>
<body bgcolor="#FCF0C2">
<table width="62%" border="1" align="center" bordercolorlight="#000000"
bordercolordark="#FFFFFF" cellspacing="0" cellpadding="3">
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">姓 名 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("username")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">E-mail </td>
<td width="59%" bgcolor="#E2E2C7"> <a href="mailto:<%=rs("email")%>"><%=rs("email")%></a></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">性 别 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("sex")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">出生年月 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("born")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">竹 叶 </td>
<td width="59%" bgcolor="#E2E2C7"><a href="<%=rs("homepage")%>" target="_blank"> <%=rs("homepage")%></a></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">来 自 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("city")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">CALL / ICQ </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("phone")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">注册时间 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("regtime")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">最近登录 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("newregtime")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">发表文章数 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("articlenum")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">登录次数 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("logonnum")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">积 分 </td>
<td width="59%" bgcolor="#E2E2C7"> <%=rs("lives")%></td>
</tr>
<tr>
<td width="41%" bgcolor="#BFBFFF"><p align="center">签 名 </td>
<td width="59%" bgcolor="#E2E2C7"> </td>
</tr>
<tr bgcolor="#E2E2C7">
<td colspan="2"> <%=replace(rs("signs"),chr(13)&chr(10),"<br>")%></td>
</tr>
</table>
<a Href="Javascript:history.go(-1)">
<p align="center">返回前页</a> </p>
</body>
</html>
<%rs.close
conn.close
set rs=nothing
set conn=nothing
end if
end if
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -