File Manager

<form  name="form1"  Action = "index_course.asp" method="post">
<%

id_course=request.form("id_course")

course_th=request.form("course_thai")
  course_eng = request.form("course_eng") 
  credit=request.form("credit")

<%
sql_data="select * from course where id_course='"&id_course&"' "
	 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 "���ʫ��"&id_lecturer
		response.write"alert('�ѹ�֡��������Ԫҫ��');"
		response.write "window.location.href='index_course.asp';"
%>
		-->
		</SCRIPT>
		
		<%
else

sqldata="insert into course(id_course,course_thai,course_eng,credit)  values('"&id_course&"','"&course_th&"','"&course_eng&"',"&credit&")"

set orsdata = Server.CreateObject("adodb.recordset")
 orsdata.open sqldata,conn,1,3
'response.write sqldata
%>
<SCRIPT LANGUAGE="JavaScript">
<%
response.write "alert('�ѹ�֡����������Ԫ����º�������Ǥ��');"
		response.write "window.location.href='index_course.asp';"
		%>
	
		</SCRIPT>
		<%

end if
'end if
 set conn = nothing
'ors_data.close

</FORM>

File Manager

Editing: grade/add_course.asp.bak