📄 default.asp
字号:
<%Option Explicit%><!--#include file="conn.asp"--><%
dim connpic
dim rs_user,rs_today,rs_lar,rs_new,rs_board,rs_boy,rs_girl
dim sql,records,today_records,rs_pic
dim i,j,k
if isempty(session("user_id")) then session("user_id")=1
'取得入会人数
Set rs_user = Server.CreateObject("ADODB.Recordset")
rs_user.open "user_reg",conn,1,1
records=rs_user.recordcount
rs_user.close:set rs_user=nothing
'取得当天入会人数
Set rs_today = Server.CreateObject("ADODB.Recordset")
rs_today.open "select * from user_reg where date=#" & cdate(date) & "#" ,conn,1,1
today_records=rs_today.recordcount
rs_today.close:set rs_today=nothing
'取得人气最高的网友（10位）
Set rs_lar = Server.CreateObject("ADODB.Recordset")
rs_lar.open "select * from larchives order by renqi desc",conn,1,1
'取得人气最高的男主角
Set rs_boy = Server.CreateObject("ADODB.Recordset")
sql="select * from larchives where photo>0 and sex like '" & "男" & "' order by renqi desc"
rs_boy.open sql,conn,1,1
'取得人气最高的女主角
Set rs_girl = Server.CreateObject("ADODB.Recordset")
sql="select * from larchives where photo>0 and sex like '" & "女" & "' order by renqi desc"
rs_girl.open sql,conn,1,1
'取得最新加入的网友（10位）
Set rs_new = Server.CreateObject("ADODB.Recordset")
rs_new.open "select * from larchives order by lar_id desc",conn,1,1
'取得寻友启事
Set rs_board = Server.CreateObject("ADODB.Recordset")
rs_board.open "select * from callboard order by id desc",conn,1,1
%>
<html>
<head>
<LINK href="pic/gufeng.css" rel=stylesheet>
<script language="JavaScript" src="pic/fade_image.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>..:味道网:..交友中心</title>
<SCRIPT language=JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
if (theURL != "fuckyou")
{ window.open(theURL,winName,features);}
}
//-->
</SCRIPT>
</head>
<body topmargin="0" leftmargin="0">
<div align="center"> </div>
<!--#include file="hand.htm" -->
<table border="0" cellpadding="0" cellspacing="0" width="777" height="412">
<tr>
<td width="174" height="1" bgcolor="#FFFFFF"> </td>
<td width="425" height="1" colspan="4"></td>
<td width="171" height="1" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td width="174" height="26" bgcolor="#FFFFFF">
<img border="0" src="pic/zuixinjia.GIF" width="150" height="22">
</td>
<td width="13" height="26"></td>
<td width="399" height="26" colspan="2"><img border="0" src="pic/changyuan.GIF" width="399" height="28"></td>
<td width="15" height="26"></td>
<td width="171" height="26" bgcolor="#FFFFFF" align="right"> <img border="0" src="pic/bbs.GIF" width="150" height="22"></td>
</tr>
<tr>
<td width="174" height="157" bgcolor="#FFFFFF">
<table border="1" cellpadding="0" cellspacing="0" width="87%" height="167" bgcolor="#FFF4C8" bordercolorlight="#000000" bordercolordark="#FFF4C8">
<tr>
<td width="100%" height="165" bgcolor="#FFF4C8" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" bgcolor="#FFF4C8">
<p align="center"><font color="#000000">性别</font></p>
</td>
<td width="61%" bgcolor="#FFF4C8">
<p align="center"><font color="#000000">网名</font></p>
</td>
<td width="19%" bgcolor="#FFF4C8"><font color="#000000">人气</font></td>
</tr>
<%i=1%>
<%do while not(rs_new.eof) and i<11%>
<tr>
<td width="20%" align="center"><%=rs_new("sex")%></td>
<td width="63%" align="left">
<p align="center"><a href="read.asp?user_id=<%=rs_new("user_id")%>"><%=rs_new("netname")%></a></td>
<td width="17%" align="center"><%=rs_new("renqi")%></td>
</tr>
<%i=i+1%>
<%rs_new.movenext%>
<%loop%>
<%rs_new.close%>
</table>
</td>
</tr>
</table>
</td>
<td width="13" height="172"></td>
<td width="197" height="172" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="183" valign="top">
<font color="#FFFFFF">1</font>
</td>
</tr>
<tr>
<td width="183" valign="top">
<%Set connpic = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("pic.mdb")
connpic.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
if rs_girl.eof and rs_girl.bof then%>
<table border="0" width="175" cellspacing="0" cellpadding="0">
<tr>
<td width="93" valign="top" rowspan="7"><img border="0" src="image/lanmang.gif" width="90" height="120"></td>
<td width="82"><font color="#FFFFFF"> </font></td>
</tr>
<tr>
<td width="82"></td>
</tr>
<tr>
<td width="82"><font color="black"> </font></td>
</tr>
<tr>
<td width="82"></td>
</tr>
<tr>
<td width="82"></td>
</tr>
<tr>
<td width="82"><font color="black"> </font></td>
</tr>
<tr>
<td width="82"><font color="black"> </font></td>
</tr>
</table>
<%else
Set rs_pic = Server.CreateObject("ADODB.Recordset")
sql="select * from pic where user_id=" & rs_girl("user_id")
rs_pic.open sql,connpic,1,1
%>
<table border="0" width="176" cellspacing="0" cellpadding="0">
<tr>
<td width="94" valign="top" rowspan="7"><a href='read.asp?user_id=<%=rs_girl("user_id")%>'><font color="black"><img border="0" src='display.asp?id=<%=rs_pic("id")%>' width="90" height="120"></font></a></td>
<td width="82"><font color="black"> </font></td>
</tr>
<tr>
<td width="82" bgcolor="white"><font color="black">性别:女</font></td>
</tr>
<tr>
<td width="82"><font color="black">网名:<%=rs_girl("netname")%></font></td>
</tr>
<tr>
<td width="82"><font color="black">年龄:<%=rs_girl("age")%></font></td>
</tr>
<tr>
<td width="82"><font color="black">学历:<%=rs_girl("education")%></font></td>
</tr>
<tr>
<td width="82"><font color="black">职业:<%=rs_girl("job")%></font></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -