File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>�к����ʹ�����͡�ú�����</title>
 
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<link href="bsri2006.css" rel="stylesheet" type="text/css">
<link href="image/favicon.ico" rel="shortcut icon" type="image/x-icon">
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0">
  <tr> 
    <td colspan="2"><div align="right"><img src="Image/head1.gif" width="800" height="61"></div></td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif"><div align="right"><font size="2" face="MS Sans Serif, Tahoma, sans-serif"><strong>| 
        <a href="http://www.swu.ac.th" target=_blank>SWU</a> | <a href="http://bsri.swu.ac.th" target=_blank>BSRI</a> 
        |<a href="chaPW.asp"><strong>Change 
        Password</strong></a>|<a href="log_out.asp">Log Out </a></strong></font>|</div></td>
  </tr>
  <tr> 
    <td width="20%" align="left" valign="top" bgcolor="#FFCCCC"></td>
    <td width="77%" align="left" valign="top">
 	  <table width="100%" border="0" cellspacing="0">
     <%
'*****************************************************************

session("tb_name")="course"
%>

<%
'*****************************************************************
  if session("tb_preview") <> 1 or session("tb_preview")=1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

%>
	  
        <tr> 
          <td colspan="3"> </td>
        </tr>
        <tr> 
          <td width="892" align="left" valign="top"><div align="center">
		  <%if session("tb_edit")=2 then %>
		  [ <a href="add_course_form.asp">+��������Ԫ�+</a>][<a href=manage_course_category.asp>+�Ѵ��Ǵ����Ԫ�+</a>]<%end if%><br><strong>
              ����Ԫ����ѡ�ٵ�<br></div>
              <br><div align=center>
			  <FORM METHOD=POST ACTION="index_course.asp">
			  
			  
			  ���͡�ա���֡�ҷ��١��Ѻ��ا<SELECT NAME="year_edu" style="font-size=16px">

<%
sqlcy="select distinct year_edu from course order by year_edu desc"
set orscy=server.createobject("adodb.recordset")
orscy.open sqlcy,conn,1,3
if not orscy.eof then
orscy.movefirst
do while not orscy.eof
response.write "<option value="&orscy("year_edu")&">"&orscy("year_edu")&"</option>"

orscy.movenext
loop
else
end if

%>
</SELECT>
<input type="submit" name="Submit" value="Submit" style="font-size=16px">
</FORM>
</div>
              <table align=center>
                <tr bgcolor=#99CC00> 
				<td align=center><strong>���</td>
                  <td align=center><strong>��������Ԫ�</td>
                  <td  width=300><div align="center"><strong>����</td>
                  <td align=center><strong>˹��¡Ե</td>
				  <td align=center><strong>�ա���֡��</td>
				  <%if session("tb_edit")=2 then%>
				  <td align=center><strong>Edit</td>
				  <%end if%>
				  <td align=center><strong>����͹</td>
                  <%
'027891000
year_edu=request.form("year_edu")
sqlall="select * from course where year_edu= '"&year_edu&"'"
set orsall=server.createobject("adodb.recordset")
orsall.open sqlall,conn,1,3
sum1=0
if not orsall.eof then
orsall.movefirst
do while not orsall.eof
sum1=sum1+1
			
			if sum1 mod 2 = 0 then
			bg1="#EEEEEE"
			else
			bg1="ffffff"
			end if

'id_ccourse_th=orsall("id_course_th")

' sql_o_po="select * from course where id_course_th='"&id_course_th&"'"

'	  set ors_o_po=server.createobject("adodb.recordset")
'	  ors_o_po.open sql_o_po,conn,1,3
response.write "<tr bgcolor="&bg1&">"
response.write "<td>"&sum1&"<td>[<a href=detail_course.asp?id_course="&orsall("id_course")&">"&orsall("id_course_th")&"</a>]</td>"

response.write "<td width=300>"

response.write orsall("course_th")&"</td>"
		response.write "<td>"&orsall("credit")&"</td>"	
		response.write "<td>"&orsall("year_edu")&"</td>"

if session("tb_edit") =2 then
response.write "<td>[<a href=edit_course_form.asp?id_course="&orsall("id_course")&">Edit</a>]</td>"
end if
response.write "<td>[<a href=course_lec.asp?id_course="&orsall("id_course")&">����͹</a>]</td>"
response.write "</tr><tr bgcolor="&bg1&"><td><td>"
response.write orsall("id_course_eng")
response.write "<td width=300>"&orsall("course_eng")&"</td></tr>"

orsall.movenext
loop
conn.close

else
response.write "<tr><td colspan =6>No Course</td></tr>"
end if
%>
                </tr>
              
            </div></td>
        </tr></table>
		 <%	else '���Է�
	response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է�
	end if '���Է�
%>
      </table>

</td>
  </tr>
  <tr> 
    <td colspan="2" background="Image/bghead1.gif">Contact Admin:: wassanaw@swu.ac.th 
      tel.02-649-5000 ext 17600</td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: index_course.asp