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">
        <p>�š�ä��ҹ��Ե</p>
        <p><TABLE>
		<%
		search_name=request.form("keyword1")
		type_search=request.form("type_search")
	'.............................
		if type_search="2" then
			sqlname="select * from student where sur_stu like '%"&search_name&"%'"
			'response.write sqlname
			set orsname=server.CreateObject("adodb.recordset")
			orsname.open sqlname,conn,1,3
					
		elseif type_search="1" then
			sqlname="select * from student where name_stu like '%"&search_name&"%'"
			'response.write sqlname
			set orsname=server.CreateObject("adodb.recordset")
			orsname.open sqlname,conn,1,3
		elseif type_search="3" then
			sqlname="select * from student where id_stu like '%"&search_name&"%'"
			'response.write sqlname
			set orsname=server.CreateObject("adodb.recordset")
			orsname.open sqlname,conn,1,3
		elseif type_search="4" then
			sqlname="select * from student where nickname like '%"&search_name&"%'"
			'response.write sqlname
			set orsname=server.CreateObject("adodb.recordset")
			orsname.open sqlname,conn,1,3
		end if
		if not orsname.eof then
					%>

<TD div align="center" bgcolor="#FFCCFF">��Ͷ��/email</TD>

<%a=0
orsname.movefirst
do while not orsname.eof 
		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>"
			response.write "[<a href=detail_stu.asp?id_stu="&orsname("id_stu")&">"&orsname("id_stu")&"</a>]"
			response.write "<td>"
			response.write orsname("name_stu")&" "&orsname("sur_stu")
			'response.write "<br>("&orsname("nickname")&")"
			response.write "<td>"
			'response.write orsname("id_stugroup")
			'�������������´���
			 sql_all="select * from student_group where id_stugroup='"&orsname("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("tell_mobile")&"<br>"&orsname("email_stu")
			'response.write "<td>"
			'response.write orsname("email_stu")

response.write "<td>"
			'response.write orsname("email_stu")&"<br>"
			'id_curriculum=orsall("id_curriculum")
			if id_curriculum="2" then
			response.write "[<a href=qe_regis.asp?id_stu="&orsname("id_stu")&">QE</a>]"
			end if
			response.write "[<a href=edit_thesis_stu_form.asp?id_stu="&orsname("id_stu")&">thesis</a>]"
					id_status_edu=orsname("id_status_edu")
			response.write "<br>"
					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="&orsname("id_stu")&">"&ors3("status_edu")&"</a>]"
						else 
							response.write ors3("status_edu")
						end if
					end if
			
			orsname.movenext
			loop

<%
		else
					response.write "<tr><td colspan=6>��辺�����ŷ�����<br>"&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_stu.asp.bak