File Manager

if( document.form1.link_file.value == "" )
	{
		alert("��سҡ�͡ URL �ͧ�����ѡ�ٵ�����")
		document.form1.link_file.focus()
			return false;
	}

}
		</script>

<!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_edit") <> 1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<tr>

<td width="892" align="left" valign="top"><div align="center">
	<%if session("tb_edit")=2 then %><strong>��������´��û�Ѻ��ا��ѡ�ٵ�<br>
<table align=center>
<tr bgcolor=#00CCFF align=center><td> �ա���֡�� <td>��ѡ�ٵ�<td>�Ң�<td>File<td>Action

<%
set ors_e=server.createobject("adodb.recordset")
	 sql_e="select * from adjust_curriculum order by year_adjust, id_curriculum"
	 ors_e.open sql_e,Conn,1,3
	 if not ors_e.eof then
	ors_e.movefirst
	do while not ors_e.eof
			response.write "<tr><td>"&ors_e("year_adjust")
			id_curriculum=ors_e("id_curriculum")
					 set orsc=server.createobject("adodb.recordset")
	 sqlc="select * from curriculum where id_curriculum='"&id_curriculum&"'"
	 orsc.open sqlc,Conn,1,3
			if not orsc.eof then
			response.write "<td>"&orsc("curriculum_full")
			end if
			set orsm=server.createobject("adodb.recordset")
	 sqlm="select * from major where id_major='"&ors_e("id_major")&"'"
	 orsm.open sqlm,Conn,1,3
			if not orsm.eof then
			response.write "<td>"&orsm("major_th")
			end if
			if ors_e("link_file")= "" then
				response.write "<td>"
			else
				response.write "<td>[<a href="&ors_e("link_file")&">View</a>]"
				end if	
				response.write "<td>"

%>
			[<a href=del_adjust_curri.asp?id=<%=ors_e("id_adjust")%> onclick="return confirm('�س��ͧ���ź?');">Del</a>]

<%
		
ors_e.movenext
		loop
	end if
%>

</table>

<%
response.write "<tr><td><div align=right>�ա���֡��::</td><td >"
%>

<input type=text name=year_adjust onkeypress='if (event.keyCode < 46 || event.keyCode >57 ) event.returnValue=false;' maxlength="4"> </td></tr>

<%
			  response.write "<tr><td align= right>��ѡ�ٵ� ::<td><select name=id_curriculum>"

set ors_o=server.createobject("adodb.recordset")
	 sqlmark_o="select * from curriculum"
	 ors_o.open sqlmark_o,Conn,1,3
	ors_o.movefirst
	do while not ors_o.eof
			response.write "<option value="&ors_o("id_curriculum")&">"&ors_o("curriculum_full")&" </option>"
		ors_o.movenext
		loop
		%>
			  </select>
<tr> 
              <td><div align="right">�Ң� ::</div></td><td>
			  <select name="id_major">
<% 
			  set ors5=server.createobject("adodb.recordset")
	 sql5="select * from major where own='1'"
	 ors5.open sql5,Conn,1,3
	ors5.movefirst
	do while not ors5.eof
		response.write "<option value="&ors5("id_major")&">"&ors5("major_th")&"</option>"
		ors5.movenext
		loop
		%>
			  </select>
			  
            </tr>

<%
response.write "<tr><td><div align=right>��������͡���::</td><td><input type=text name=link_file> </td></tr>"

'response.write "<tr><td><div align=right>��������Ԫ�(��)::</td><td><input type=text name=course_th size=50></td></tr>"

'response.write "<tr><td><div align=right>��������Ԫ�(Eng)::</td><td><input type=text name=course_eng size=50></td></tr>"
'response.write "<tr><td><div align=right>˹��¡Ե::</td><td><input type=text name=credit></td></tr>"
'response.write "<tr><td><div align=right>�շ���Ѻ��ا::</td><td><input type=text name=year_edu size=50></td></tr>"

'response.write "<tr><td><div align=right>��͸Ժ������Ԫ�::</td><td><textarea cols=50 rows=8 name=detail_course></textarea></td></tr>"

conn.close

<br>
  
  </tr></table>
    <%	else '���Է�
	response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��"
response.write "<meta http-equiv=refresh content =4;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: adjust_curri.asp.bak