📄 index.asp

📁 免费实用家教网整站程序(奥运特别版) v1.5
💻 ASP
📖 第 1 页 / 共 3 页
字号:
上一页 1 23
rs.movenext
if rs.eof then exit for
next
rs.close
%>
                            <%
end if
%>
                        </table></TD>
                    </TR>
                  </TBODY>
                </TABLE></TD>
        </TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD height=10></TD></TR></TBODY></TABLE>
      </TD>
    <TD width=10>&nbsp;</TD>
    <TD vAlign=top>
      <TABLE cellSpacing=1 cellPadding=0 width="100%" bgColor=#cccccc 
        border=0><TBODY>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff height=200>
            <TABLE cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD height=10></TD></TR>
              <TR>
                <TD>
                  <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                    <TBODY>
                    <TR>
                      <TD width=440 bgColor=#f7941c>
                        <DIV align=center><SPAN class=white_link_9><STRONG>最 新 教 
                        师 信 息 库</STRONG></SPAN></DIV></TD>
                      <TD width=119 bgColor=#f7941c height=30><IMG height=30 
                        src="newimg/te1.gif" 
                        width=119></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD height=5></TD></TR></TBODY></TABLE>
            <TABLE cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD vAlign=top align=middle>
				<%
sql="select top 10 id,name,trade,cxz,fund,rdate,vip,province,city,xian from en_user  order by rdate desc"
rs.open sql,conn,1,1
if rs.eof or rs.bof then
           response.write "暂无教员信息！"
           rs.close
           else
%>
				<table border="0" width="544" cellspacing="0" cellpadding="0" id="table12" height="49">
                                  <tr>
                                    <td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="96" align="center"><p><b>教员姓名</b></td>
                                    <td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" align="center"><p><b>擅长科目</b></td>
                                    <td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="96" align="center"><b>&nbsp;教员身份</b></td>
                                    <td height="25" bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="151" align="center"><span style="font-weight: bold">服务区域</span></td>
                                    <td bgcolor="#FEEBD5" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="101" align="center"><span style="font-weight: bold">单价[元/小时]</span></td>
                                  </tr>
                                  <%
for ii=1 to 10
%>
                                  <tr>
                                    <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="96" height="25" align="center" background="images/bg1.gif"><a target =_blank  href="teacher.asp?id=<%=rs("id")%>"><%=left(rs("name"),1)%>教员</a>
                                    <%if rs("vip")=true then response.write "<font color='#FF0000'>[荐]</font>"%></td>
                                    <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" height="25" align="center" background="images/bg1.gif">『<font color=#ff0000><%=rs("cxz")%></font>』
                                    </td>
                                    <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="96" height="25" align="center" background="images/bg1.gif"><p align="center"><%=rs("trade")%></td>
                                    <td width="151" height="25" align="center" background="images/bg1.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; "> <%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from province where shengNo="&int(rs("province"))
rss.open sqls,conn,1,1
if rss.eof then

end if
if rs("province") =0 then
response.write "不详"
end if
               shengid=rss("id")
               sheng=rss("shengname")
                rss.close
                set rss=nothing
                %>
                                <%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from city where Shengid="&shengid&" and  shino="&int(rs("city"))
rss.open sqls,conn,1,1
if rss.eof then

end if

               shi=rss("shiname")
                rss.close
                set rss=nothing
                %>
                            <%=sheng%><%=shi%><%=rs("xian")%></td>
                                    <td width="101" height="25" align="center" background="images/bg1.gif" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; ">
									<%=rs("fund")%></td>
                                  </tr>
                                 <%
rs.movenext
if rs.eof then exit for
next
rs.close
end if
%>	
                    </table></TD>
                <TD width=10>&nbsp;</TD>
                <TD width=50><IMG height=115 alt=专业教师 
                  src="newimg/sh_sml_3.jpg" width=50 
                  border=0></TD>
              </TR></TBODY></TABLE>
            <TABLE height=20 cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD vAlign=bottom>
                  <DIV align=right><A 
                  href="grqz2.asp"><IMG 
                  height=11 alt=更多专业教师 
                  src="newimg/mores.gif" width=37 
                  border=0></A></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD height=10></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD height=10></TD></TR></TBODY></TABLE>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD height=10></TD></TR></TBODY></TABLE>
      <TABLE borderColor=#cccccc cellSpacing=1 cellPadding=0 width="100%" 
      bgColor=#cccccc border=0>
        <TBODY>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff height=200>
            <TABLE cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD height=10></TD></TR>
              <TR>
                <TD>
                  <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
                    <TBODY>
                    <TR>
                      <TD width=438 bgColor=#ef1697>
                        <DIV align=center><SPAN class=white_link_9><STRONG>最 新 学 
                        员 信 息 库</STRONG></SPAN></DIV></TD>
                      <TD width=119 bgColor=#ef1697 height=30><IMG height=30 
                        src="newimg/te2.gif" 
                        width=119></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD height=5></TD></TR></TBODY></TABLE>
            <TABLE cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD vAlign=top align=middle>
				<%
sql="select top 10 id,name,sex,rdate,gzcs,zye,gzdd,zy,province,city,xian,vip from in_user where lock=false and name<>''  order by rdate desc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
rs.close
response.write "暂时没有学员用户！" 
else
%>       
				<table border="0" width="544" cellspacing="0" cellpadding="0" id="table12" height="49">
									<tr>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="82" align="center">
										<p>
									  <b>学员姓名</b></td>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="38" align="center">
										<p>
									  <b>性 别</b></td>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="68" align="center"><span style="font-weight: bold">辅导方式</span></td>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="78" align="center"><STRONG>辅导科目</STRONG></td>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="178" align="center"><strong>所在地区</strong></td>
										<td height="25" bgcolor="#DAE3DA" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" align="center"><STRONG>每小时支付[元]</STRONG></td>
									</tr>
<%
for ii=1 to 10
%>	
								<tr>
								  <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="82" height="25" align="center" background="images/bg1.gif"><a  target =_blank href="student.asp?id=<%=rs("id")%>"><%=left(rs("name"),1)%>学员</a><%if rs("vip")=true then response.write "<font color='#FF0000'>[荐]</font>"%></td>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="38" height="25" align="center" background="images/bg1.gif">
										[<%=rs("sex")%>]</td>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="68" height="25" align="center" background="images/bg1.gif">
										[<%=rs("zye")%>]</td>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="78" height="25" align="center" background="images/bg1.gif"><font color=#ff0000><%=rs("gzdd")%></font></td>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="178" height="25" align="center" background="images/bg1.gif"><%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from province where shengNo="&int(rs("province"))
rss.open sqls,conn,1,1
if rss.eof then

end if
if rs("province") =0 then
response.write "不详"
end if
               shengid=rss("id")
               sheng=rss("shengname")
                rss.close
                set rss=nothing
                %>
                                <%
                  set rss=server.createobject("adodb.recordset")
sqls="select * from city where Shengid="&shengid&" and  shino="&int(rs("city"))
rss.open sqls,conn,1,1
if rss.eof then

end if

               shi=rss("shiname")
                rss.close
                set rss=nothing
                %>
                              <%=sheng%><%=shi%><%=rs("xian")%></td>
										<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="100" height="25" align="center" background="images/bg1.gif"><%=rs("zy")%></td>
					    </tr>
<%
rs.movenext
if rs.eof then exit for
next
rs.close
%><%
end if
%>
				    </table></TD>
                <TD width=10>&nbsp;</TD>
                <TD width=50 bgColor=#FFFFFF><IMG height=115 alt=学员 
                  src="newimg/sh_sml_1.jpg" width=50 
                  border=0></TD>
              </TR></TBODY></TABLE>
            <TABLE height=20 cellSpacing=0 cellPadding=0 width="97%" border=0>
              <TBODY>
              <TR>
                <TD vAlign=bottom>
                  <DIV align=right><A 
                  href="qyzp.asp"><IMG height=11 
                  alt=更多学员信息 src="newimg/mores.gif" 
                  width=37 
      border=0></A></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
    <TD width=15>&nbsp;</TD></TR></TBODY></TABLE><!--************alimama广告2***************-->
<!--#include file="base.asp"-->
上一页 1 23
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -