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">
</title>
<%
'*****************************************************************
'
session("tb_name")="course"
%>

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

<form  name="form1"  Action = "" method="post">
<%

'id_curriculum_manage=request.form("id_curriculum_manage")
year_adjust=request.form("year_adjust")
link_file=request.form("link_file")
 id_curriculum = request.form("id_curriculum") 
  id_major=request.form("id_major")

<%
sql_data="select * from adjust_curriculum where id_curriculum='"&id_curriculum&"' and id_major='"&id_major&"' and year_adjust='"&year_adjust&"' "
	 set ors_data=server.createobject("adodb.recordset")
	 ors_data.open sql_data,conn,1,3

if  not ors_data.eof  then
				%>
<SCRIPT LANGUAGE="JavaScript">
<%

response.write"alert('"&id_curriculum&"�ѹ�֡�����䢫��');"
		response.write "window.location.href='adjust_curri.asp';"
%>
		-->
		</SCRIPT>
		
		<%
else
sqln="select * from adjust_curriculum"
set orsn=server.createobject("adodb.recordset")
orsn.open sqln,conn,1,3
if not orsn.eof then
				orsn.movelast
				id=orsn("id_adjust")+1
else id=1
				end if
  sqldata="insert into adjust_curriculum(id_curriculum,id_major,link_file,year_adjust,id_adjust)  values('"&id_curriculum&"','"&id_major&"','"&link_file&"','"&year_adjust&"','"&id&"')"

set orsdata = Server.CreateObject("adodb.recordset")
orsdata.open sqldata,conn,1,3
response.write sqldata
response.write "<meta http-equiv='refresh' content ='1;url=adjust_curri.asp'>"
'response.write "<meta http-equiv='refresh' content ='1;url=detail_curri_manage.asp?id_curriculum_manage="&id_curriculum_manage&"'>"
end if

set conn = nothing
ors_data.close

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

File Manager

Editing: add_adjust_curri.asp