File Manager

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />

</head>

<body>
<table width="100%" border="0" cellspacing="0">
  <tr>
    <td><div align="center"><img src="image/head.jpg" width="800" height="191" /></div></td>
  </tr>
  <tr>
    <td>
      <div align="right">
<%
pern=session("usernamekm")
response.write pern
if pern="" then
%>
        [<a href="km_login_form.asp">LogiN</a>]
		
		<%
		else
		
		%>
		[<a href="add_km_stu_form.asp">����������</a>]
		[<a href="km_log_out.asp">LogouT</a>]
		<%end if%>
      </div></td></tr>
  <tr>
    <td align="center" valign="top">��¡�ú������ҡ���Ե<br />
      ʶҺѹ�Ԩ�¾ĵԡ�����ʵ��<br />
      <table width="100%" border="1" cellspacing="0" cellpadding="0">
        <tr>
          <td width="5%" height="23" bgcolor="#3366FF"><div align="center" class="style1">���</div></td>
          <td width="6%" bgcolor="#3366FF"><div align="center" class="style1">�����Ԫ�</div></td>
          <td width="22%" bgcolor="#3366FF"><div align="center" class="style1">��������ͧ</div></td>
          <td width="17%" bgcolor="#3366FF"><div align="center" class="style1">��</div></td>
          <td width="15%" bgcolor="#3366FF"><div align="center" class="style1">����͹</div></td>
          <td width="15%" bgcolor="#3366FF"><div align="center" class="style1">�ѹ��͹�շ���Ե</div></td>
          <td width="9%" bgcolor="#3366FF"><div align="center" class="style1">ip����Ե</div></td>
          <td width="11%" bgcolor="#3366FF"><div align="center" class="style1">Download</div></td>
        </tr>

<%
		c=1
sql="select * from km_abs where status_online='"&c&"' order by id_abs_km desc"
set ors=server.createobject("adodb.recordset")
ors.open sql,conn,1,3
'response.write sql
if not ors.eof then

a=1
ors.movefirst
do while not ors.eof
response.write "<tr align=left><td >"&ors("id_abs_km")&"</td>"
response.write "<td>"&ors("id_course_eng")&"</td>"
response.write "<td>"&ors("abs_km_name")&"</td>"
response.write "<td>"
						
response.write ors("author_km")
							
response.write "</td>"
response.write "<td>"
									sql1="select * from lecturer where id_lecturer='"&ors("id_lecturer")&"'"
											set ors1=server.createobject("adodb.recordset")
											ors1.open sql1,conn,1,3
											if not ors1.eof then
									
									response.write ors1("name_lec")&" "&ors1("sur_lec")
											end if
response.write "</td>"
response.write "<td>"&ors("datetime_mo")&"</td>"
response.write "<td>"&ors("ipcreate")&"</td>"
response.write "<td align=left>"
if ors("abs_file")<>"" then

response.write "[<a href=km_download.asp?id="&ors("id_abs_km")&">Preview</a>]"
			if pern<>""then
					response.write "[<a href=km_remove.asp?id="&ors("id_abs_km")&">Remove</a>]"
'else
'response.write "[<a href=km_up_form.asp?id="&ors("id_abs_km")&">UploadfilE</a>]"
end if
else 
						if pern<>""then
						response.write "[<a href=km_up_form.asp?id="&ors("id_abs_km")&">UploadfilE</a>]"
						end if
end if
response.write "��:<a href=km_hit.asp?id="&ors("id_abs_km")&">"&ors("hitc")&"</a>"
response.write "<td align=left>"

ors.movenext
a=a+1
loop
else

response.write "<tr><td colspan=8>No Abstract"
end if
		%>
      </table></td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: index_km_stu.asp.bak