File Manager

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

<title>�к����ʹ�����͡�ú�����</title>
<script language="javascript">	
		function doSubmit()
{
	if( document.form1.academic_year.value == "" )
	{
		alert("��سҡ�͡�ա���֡�ҷ���ͺ")
		document.form1.academic_year.focus()
			return false;
	}

if( document.form1.thesis_th.value == "" )
	{
		alert("��سҡ�͡���ͻ�ԭ�ҹԾ���")
		document.form1.thesis_th.focus()
			return false;
	}
if( document.form1.thesis_eng.value == "" )
	{
		alert("Input your Thesis Name")
		document.form1.thesis_eng.focus()
			return false;
	}
if( document.form1.id_course.value == "" )
	{
		alert("Input your Course Name")
		document.form1.id_course.focus()
			return false;
	}

}
		</script>
 
<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">
      <%	id_stu=request("id_stu") %>
	  <form name="form1" method="post" action="add_thesis_stu.asp?id_stu=<%=id_stu%>" onsubmit="return doSubmit();">
        <table width="100%" border="0">
		<tr ><td colspan=2 align=left><a href=edit_thesis_stu_form.asp?id_stu=<%=id_stu%>>��ԭ�ҹԾ��������</a>></td></tr>
          <tr bgcolor="#CCCCCC"> 
            <td colspan="2"><div align="center"><strong>������ԭ�ҹԾ���</strong></div></td>
          </tr>
          <tr> 
            <td width="23%"><strong>���Ե</strong></td>
            <td width="77%">
			<%
		
	sqls="select * from student where id_stu='"&id_stu&"'"
	set orss=server.createobject("adodb.recordset")
	orss.open sqls,conn,1,3
				if not orss.eof then
					response.write orss("id_stu")&"<strong> "&orss("name_stu")&" "&orss("sur_stu")&"</strong> "

set ors4=server.createobject("adodb.recordset")
									 sql4="select * from student_group where id_stugroup='"&orss("id_stugroup")&"'"
									 ors4.open sql4,Conn,1,3
									 if not ors4.eof then
									year_edu=ors4("year_edu")
									sqlc="select * from curriculum where id_curriculum='"&ors4("id_curriculum")&"'"
									set orsc=server.createobject("adodb.recordset")
									orsc.open sqlc,conn,1,3
									if not orsc.eof then
										   sqlt="select * from type_curriculum where id_type_curri='"&ors4("id_type_curri")&"'"
										   set orst=server.createobject("adodb.recordset")
										   orst.open sqlt,conn,1,3
										   if not orst.eof then
										   'response.write ors4("id_stugroup")
									%>

<%  =orsc("curriculum_sum")%> Ẻ <%=orst("type_curri_th")%> ��� <%=ors4("no_stugroup")%>
										<%
										end if
								end if
								end if
end if

%>
			</td>
          </tr>
          <tr bgcolor="#FCFCD9"> 
            
            <td><strong>�Ҥ���¹����ͺ<td><select name="id_academic_semeter">
<% 
			  set ors_=server.createobject("adodb.recordset")
	 sqlmark_="select * from academic_semeter"
	 ors_.open sqlmark_,Conn,1,3
	ors_.movefirst
	do while not ors_.eof
		response.write "<option value="&ors_("id_academic_semeter")&">"&ors_("academic_semeter")&"</option>"
		ors_.movenext
		loop
		%>
			  </select>
<strong>�ա���֡���ͺ
<%								y=year(now())
									y=543+y

%>
                <input name="academic_year" type="text" id="academic_year" onKeyPress='if (event.keyCode < 46 || event.keyCode >57 ) event.returnValue=false;' size="10" maxlength="4" value=<%=y%>>
                            </td>
          </tr>
          <tr> 
            <td><strong>����������</strong></td>
            <td><textarea name="thesis_th" cols="60"  rows="5"></textarea></td>
          </tr>
          <tr bgcolor="#FCFCD9"> 
            <td><strong>���������ѧ���</strong></td>
            <td><textarea name="thesis_eng" cols="60" rows="5"></textarea></td>
          </tr>
          <tr> 
            <td><strong>�����Ԫ�</strong><%=year_edu%></td>
            <td><% sql_course="select * from course_category where id_category=5 or id_category=6"
					   set ors_course=server.createobject("adodb.recordset")
					   ors_course.open sql_course,conn,1,3
							if not ors_course.eof then
								response.write "<select name=id_course>"
								response.write "<option value=>���͡����Ԫ�</option>"
									ors_course.movefirst
									do while not ors_course.eof
									sqlc="select * from course where id_course='"&ors_course("id_course")&"' and year_edu='"&year_edu&"'"
									set orsc=server.createobject("adodb.recordset")
									orsc.open sqlc,conn,1,3
									if not orsc.eof then
										response.write "<option value="&orsc("id_course")&">"&orsc("id_course_th")&" "&orsc("course_th")&" "&orsc("id_course")&"</option>"
									end if

'	end if
						ors_course.movenext
						loop
						end if
                       response.write "</select>"
					   %>
         </td>
		  </tr>
          
          <tr> 
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
          <tr bgcolor="#FCFCD9"> 
            <td colspan="2"><div align="center"> <input name="id_stu" type="hidden" value=<%=id_stu%>>
                <input type="submit" name="Submit" value="Submit" >
              </div></td>
          </tr>
        </table>
      </form>
      </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: add_thesis_stu_form.asp