userinfo.asp

基于asp的 班级同学录主页源代码

<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<%if session("user")="" then
response.redirect "err.asp"
end if%>
<!--#include file="top.asp"-->
<!--#include file="bbs/process.asp"-->
<%
user=trim(request("user"))
err=flase
'取用户资料
set rs=server.createobject("ADODB.recordset")
sql="select * from user where user='"&user&"'"
rs.open sql,conn,1,1
if rs.bof or rs.eof then
err=true
errstr="<br><br><br><br><br><br><b>对不起，找不到该用户"
else
realname=rs("realname")
sex=rs("sex")
if sex="1" then
sex="男"
else
sex="女"
end if
id=rs("id")
birthday=rs("byear")&"年"&rs("bmonth")&"月"&rs("bday")&"日"
age=year(now())-rs("byear")
address=rs("address")
telephone=rs("telephone")
mobile=rs("mobile")
bp=rs("bp")
qq=rs("qq")
workshop=rs("workshop")
homeaddr=rs("homeaddr")
email=rs("email")
bbscount=rs("bbscount")
photocount=rs("photocount")
logincount=rs("logincount")
money=rs("usermoney")
if money>10000 then
level="<img src=image/level7.gif>"
elseif money>8000 then
level="<img src=image/level6.gif>"
elseif money>5000 then
level="<img src=image/level5.gif>"
elseif money>1000 then
level="<img src=image/level4.gif>"
elseif money>500 then
level="<img src=image/level3.gif>"
elseif money>200 then
level="<img src=image/level2.gif>"
else
level="<img src=image/level1.gif>"
end if
userimage="<img src="&rs("userimage")&">"
addinfo=rs("addinfo")
rs.close
end if%>
<% if err=true then%>
<table width=100%>
<tr><td align=center><%=errstr%>
</td></tr></table>
<% else%>
<DIV align=center>
<CENTER>
<TABLE border=0 cellPadding=0 cellSpacing=0 height="69%" width=100% class=bk>
<TBODY>
<TR>
<TD bgColor=#ffffff colSpan=2 height=344 vAlign=top width=100%>
<TABLE border=0 cellPadding=0 cellSpacing=0 height="27%"
width="100%" background="image/grid.gif">
<TBODY>
<TR>
<TD bgColor=#e1e1e1 height=363 vAlign=top width="150"><IMG border=0 height=110
src="image/menu0.gif" width=150><br>
<div align=center><table width=95%><tr><td align=center><%=userimage%></td></tr>
<tr><td align=center><%=level%></td></tr>
<tr><td align=left>上传图片:<%=photocount%>张</td></tr>
<tr><td align=left>上站次数:<%=logincount%>次</td></tr>
<tr><td align=left>发表贴子:<%=bbscount%>份</td></tr>
<tr><td align=left>总共积分:<%=money%>分</td></tr>
</table></div></TD>

<TD rowSpan=2 vAlign=bottom width="28">
<DIV align=left> <img border=0
height=147 src="image/bottompic.gif"
width=30></DIV>
</TD>

<TD rowSpan=2 vAlign=top width="581">
<table border=0 cellpadding=0 cellspacing=0 height=394
width="100%">
<tbody>
<tr>
<td height=402 rowspan="2">&nbsp;</td>

<td height=10 width="98%" valign="top">
<div align=center><br>
<img border=0 height=8 src="image/tt1.gif"
width=103>&nbsp;<font color="#ff6808">用户详细资料</font> <img border=0 height=11
src="image/tt2.gif" width=117></div>
</td>
</tr>
<tr>

<td valign=top align="center">
<table width="90%" border="0" cellspacing="0" cellpadding="0" class=bk bgcolor=#ffffff>
<tr>
<td height="20" width="15%" class=xy bgcolor="#FFECEC">用户网名：</td>
<td class=xy>&nbsp&nbsp<%=user%></td>
<td width="15%" class=xy bgcolor="#FFECEC">真实姓名：</td>
<td  class=x>&nbsp&nbsp<%=realname%></td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">性别：</td>
<td class=xy>&nbsp&nbsp<%=sex%></td>
<td class=xy bgcolor="#FFECEC">年龄：</td>
<td class=x>&nbsp&nbsp<%=age%></td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">电话：</td>
<td class=xy>&nbsp&nbsp<%=telephone%>&nbsp</td>
<td class=xy bgcolor="#FFECEC">手机：</td>
<td class=x>&nbsp&nbsp<%=mobile%>&nbsp</td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">传呼：</td>
<td height="20" class=xy>&nbsp&nbsp<%=bp%></td>
<td height="20" class=xy bgcolor="#FFECEC">OICQ：</td>
<td height="20" class=x>&nbsp&nbsp<%=qq%></td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">工作地点：</td>
<td height="20" class=xy>&nbsp&nbsp<%=workshop%></td>
<td height="20" class=xy bgcolor="#FFECEC">电子邮箱：</td>
<td height="20" class=x>&nbsp&nbsp<a href="javascript:popwin3('bbs/email.asp?user=<%=user%>')"><%=email%></a></td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">联系地址：</td>
<td height="20" colspan="3" class=x>&nbsp&nbsp<%=address%></td>
</tr>
<tr>
<td height="20" class=xy bgcolor="#FFECEC">家庭地址：</td>
<td height="20" colspan="3" class=x>&nbsp&nbsp<%=homeaddr%></td>
</tr>
<tr>
<td height="103" valign="top" class=xy bgcolor="#FFECEC">个人说明：</td>
<td height="100" colspan="3" class=x valign=top><%=ubbcode(addinfo)%></td>
</tr>
<tr>
<td height="20" class=y>&nbsp;</td>
<td height="20" colspan="3">&nbsp;</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</TD>
<TD bgColor=#e1e1e1 rowSpan=2 width=2><IMG border=0 height=1
src="image/spacer.gif" width=2></TD>
</TR>
<TR>
<TD bgColor=#e1e1e1 height=2 vAlign=bottom width="150"><IMG border=0
height=35 src="image/menu88.gif"
width=150></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</CENTER></DIV>
<% end if%>
<!--#include file="end.asp"-->