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">
     <a href=search_stu_form.asp>���ҹ��Ե></a>
	  <div align="center">
	  
	  
	  <%
date0=request.form("date5")
date1=request.form("date6")
d1=left(date0,2)
m1=mid(date0,4,2)
y1=right(date0,4)
b1=left(date1,2)
b2=mid(date1,4,2)
b3=right(date1,4)
date0=y1+m1+d1
date1=b3+b2+b1
curri=request.form("curri")
stu_status=request.form("stu_status")	  
sqltt="select * from status_edu where id_status_edu='"&stu_status&"'"
set orstt=server.createobject("adodb.recordset")
orstt.open sqltt,conn,1,3
if not orstt.eof then
			status_edu=orstt("status_edu")
end if
%>
        <p>�š�ä���ʶҹй��Ե <%=status_edu%><br>�����ҧ�ѹ��� <%=d1&"/"&m1&"/"&y1%> �֧ <%=b1&"/"&b2&"/"&b3%></p>
        <p><TABLE>
		
		<%			sqlname="select * from student where id_status_edu='"&stu_status&"' and graduate_date between '"&date0&"' and '"&date1&"' order by graduate_date desc"
					'response.write sqlname
					set orsname=server.CreateObject("adodb.recordset")
					orsname.open sqlname,conn,1,3
		'response.write sqlname
		if not orsname.eof then
					%>

</TR>

<%
a=0
orsname.movefirst
do while not orsname.eof 
		'sqlts="select id_stu, id_thesis  from thesis where id_thesis='"&orsname("id_thesis")&"'"
		'set orsts=server.createobject("adodb.recordset")
		'orsts.open sqlts,conn,1,3
		'response.write sqlts
		'if not orsts.eof then
'.......
sqlchkg="select * from student where id_stu='"&orsname("id_stu")&"' "
set orschkg=server.createobject("adodb.recordset") 
orschkg.open sqlchkg,conn,1,3
'response.write sqlchkg
if not orschkg.eof then

sqlcurri="select * from student_group where id_stugroup='"&orschkg("id_stugroup")&"' and id_curriculum='"&curri&"'"

set orscurri=server.createobject("adodb.recordset")
		orscurri.open sqlcurri,conn,1,3
		'response.write sqlcurri&"<br>"
		if not orscurri.eof then
'Response.write "aaaa"
		a=a+1
		b=a mod 2
		if b=0 then
		bg1="#E9E9E9"
		else 
		bg1="#ffffff"
		end if
			response.write "<tr bgcolor="&bg1&">"
			response.write "<td>"&a
			response.write "<td>"
			response.write "[<a href=detail_stu.asp?id_stu="&orschkg("id_stu")&">"&orschkg("id_stu")&"</a>]"
			response.write "<td>"
			response.write orschkg("name_stu")&" "&orschkg("sur_stu")
			'response.write "<br>("&orsname("nickname")&")"
			response.write "<td>"
			'response.write orsname("id_stugroup")
			'�������������´���
			 sql_all="select * from student_group where id_stugroup='"&orschkg("id_stugroup")&"' "
		set ors_all=server.createobject("adodb.recordset")
		ors_all.open  sql_all,Conn,1,3
		if not ors_all.eof then
		response.write ""

sql_curri="select * from curriculum where id_curriculum='"&ors_all("id_curriculum")&"'"
		set ors_curri=server.createobject("adodb.recordset")
		ors_curri.open sql_curri,conn,1,3
		if not ors_curri.eof then
		id_curriculum=ors_all("id_curriculum")
		response.write  ors_curri("curriculum_full")&" "
		end if
sqlt="select * from type_curriculum where id_type_curri='"&ors_all("id_type_curri")&"'"
		   set orst=server.createobject("adodb.recordset")
		   orst.open sqlt,conn,1,3
		   if not orst.eof then
		response.write orst("type_curri_th")
			end if
		response.write  "  ��� "&ors_all("no_stugroup")
		'id_major=ors_all("id_major")
		'sql_major="select * from major  where id_major='"&id_major&"'"
		'set ors_major=server.createobject("adodb.recordset")
		'ors_major.open sql_major,conn,1,3
		'if not ors_major.eof then
		'response.write ors_major("major_th")&"</td>"
		'end if
		end if
		'����ù��ʹ����
			'response.write "<td>"
			
			'response.write "<td>"

'response.write "<td>"
			'response.write orsname("date1")&"/"&orsname("month1")&"/"&orsname("year1")
			'response.write "<td>"
			'response.write orschkg("tell_mobile")
response.write "<td>"
Response.write orschkg("d_finish_edu")&"/"&orschkg("m_finish_edu")&"/"&orschkg("y_finish_edu")
			response.write "<td>"

'response.write orschkg("email_stu")&"<br>"
			'id_curriculum=orsall("id_curriculum")
					if id_curriculum="2" then
			'response.write "[<a href=qe_regis.asp?id_stu="&orschkg("id_stu")&">QE</a>]"
			end if
			'response.write "[<a href=edit_thesis_stu_form.asp?id_stu="&orschkg("id_stu")&">thesis</a>]"
		id_status_edu=orschkg("id_status_edu")
		set ors3=server.createobject("adodb.recordset")
		sql3="select * from status_edu where id_status_edu='"&id_status_edu&"'"
		ors3.open sql3,Conn,1,3
			if not ors3.eof then
				if ors3("id_status_edu")=1 then
					'response.write "[<a href=register_sche_indi.asp?id="&orschkg("id_stu")&">"&ors3("status_edu")&"</a>]"
				else 
					response.write ors3("status_edu")
				end if
			end if
			
			end if 'orschkg.eof then
			end if 'orscurri.eof then
			'end if 'orsts.eof then
			orsname.movenext
			loop

<%
		else
					response.write "<tr><td colspan=6>��辺�����ŷ�����<br><a href=search_stu_form.asp>���ҹ��Ե</a>"&search_name
					
		end if
		
		response.write "</TABLE>"
		
		%></p>
      </div>
    </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: search_status_stu1.asp