📄 adminscorechapter.asp

📁 该系统测试用户信息主要由数据库直接输入
💻 ASP
字号:
<!--#include file="conn.asp"-->
 <%
  if session("adminname")="" then
  response.redirect "relogin.asp"
  end if
  
  
userid=request("userid")
  sql="SELECT * from tbuser where userid="&userid
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2

username=rs("username")
kcid=request("kcid")

nianji=rs("nianji")
banji=rs("banji")
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查看练习成绩</title>
<link rel="stylesheet" type="text/css" href="css.css">
  
</head>

<body> <center><b><%=nianji%>级--<%=banji%>——<%=username%></b></center>


<%




sql1="SELECT  distinct  chapter,istest   FROM tbistest   where   kao=0 and kcid="&kcid&" and username='"&username&"'"
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,conn,3,2

 sql2="select * from tbkc where kcid="&kcid
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,3,2
%><%
 



%><p>
<br>
</p>
<center>
<table border="1" cellspacing="1" style="border-collapse: collapse" bordercolor="#799AE1" id="AutoNumber2" width="100%" height="50">
  <tr class="trh">
    <td height="22" width="55" bgcolor="#799AE1"></td>
    <td bgcolor="#799AE1" width="333">
    <p align="center"><font color="#FFFFFF"><b><%=rs2("kcm")%>——练习部分</b></font></td>
    <td bgcolor="#799AE1" width="244">
    <p align="center"><font color="#FFFFFF"><b>操作</b></font></td>
  </tr>
 <%
 i=1
 do while not rs1.eof
 %>
  <tr class="trh1">
    <td align="center" height="26" width="55"  ><%=i%></td>
    <td   width="333">
    <p align="center">第<%=rs1("chapter")%>章</td>
    <td   width="244">
    <p align="center">
    
    
            <%
 
    if rs1("istest")=1 then 
    
    
    %>
    
    <a href="admin_cx_type.asp?kcid=<%=kcid%>&chapter=<%=rs1("chapter")%>&userid=<%=userid%>">练习成绩</a>
    
     
    <%
 else
    %>
对不起，您还没有进行练习
    <%
    end if 
    %>

    
    
    
    </td>
  </tr>
  <%

rs1.movenext
i=i+1
loop

 
%>
</table>
 </center>

<p align="center">  <INPUT class="s02" onclick="window.location='adminscoreedit.asp?userid=<%=userid%>'" type=button value=返回 name=close><span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>  
        <input type="button" value="关闭窗口" name="B2" onclick="self.close()" class="s02"></p>

</body>

</html>
⌨️ 快捷键说明

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