File Manager

<%
'*****************************************************************

session("tb_name")="student"
%>

<%
'*****************************************************************
id_stu=request.form("id_stu")

if session("tb_edit") =2 or session("id_stu1")=id_stu  then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<form  name="form1"  method="post">
<%
'date0=request.form("date0")
'd_finish_edu=left(date0,2)
'm_finish_edu=mid(date0,4,2)
'y_finish_edu=right(date0,4)
'date1=request.form("date1")
'bdate_stu=left(date1,2)
'bmon_stu=mid(date1,4,2)
'byear_stu=right(date1,4)

id_sgroup=request.form("id_subgroup")
If id_sgroup="" Then
id_sgroup=0
End if
id_stu=request.form("id_stu")
id_stu1=session("id_stu1")
administor=request.form("id_administor")
  academic = request.form("academic") 
  other_position = request.form("other_position") 
 preface = request.form("preface") 
    name_stu = request.form("name_stu") 
   sur_stu =  request.form("sur_stu") 
    bdate_stu = request.form("bdate_stu") 
  bmon_stu = request.form("bmon_stu") 
  byear_stu=request.form("byear_stu")
   work_place=request.form("work_place")
    id_status_edu = request.form("id_status_edu") 
  id_stugroup = request.form("id_stugroup") 
  d_finish_edu=request.form("d_finish_edu")
    m_finish_edu=request.form("m_finish_edu")
	 y_finish_edu=request.form("y_finish_edu")
	  tell_mobile=request.form("tell_mobile")
	  tell_home=request.form("tell_home")
	  name_eng=request.form("name_eng")
	  sur_eng=request.form("sur_eng")
	  address_stu=request.form("address_stu")
   bd_stu=bdate_stu&"/"&bmon_stu&"/"&byear_stu
   nickname=request.form("nickname")
   username=session("username")
   date_mo=now
   email_stu=request.form("email_stu")
   work_position=request.form("work_position")
   f_edu_semeter=request.form("f_edu_semeter")
   f_edu_year=request.form("f_edu_year")
   f_edu=f_edu_year+f_edu_semeter
graduate_date=y_finish_edu+m_finish_edu+d_finish_edu

'sql_data="select * from student where id_stu='"&id_stu&"' "
'	 set ors_data=server.createobject("adodb.recordset")
'	 ors_data.open sql_data,conn,1,3

sql_edit_stu = "update student set id_administor='"&administor&"',id_academic='"&academic&"',id_other_position='"&other_position&"',id_preface= '"&preface&"',name_stu='"&name_stu&"',sur_stu='"&sur_stu&"',bdate_stu='"&bd_stu&"',id_status_edu='"&id_status_edu&"',id_stugroup='"&id_stugroup&"',d_finish_edu='"&d_finish_edu&"',m_finish_edu='"&m_finish_edu&"',y_finish_edu='"&y_finish_edu&"',tell_mobile='"&tell_mobile&"',tell_home='"&tell_home&"',address_stu='"&address_stu&"',email_stu='"&email_stu&"',username='"&username&"',date_mo='"&date_mo&"',name_eng='"&name_eng&"',sur_eng='"&sur_eng&"',work_place='"&work_place&"',work_position='"&work_position&"',nickname='"&nickname&"',graduate_date='"&graduate_date&"',f_edu_semeter='"&f_edu_semeter&"',f_edu_year='"&f_edu_year&"',f_edu='"&f_edu&"',id_sgroup="&id_sgroup&" where id_stu = '" & id_stu&"' "
response.write"��䢢������������º�������Ǩ��"
  set ors_edit_stu=server.createobject("adodb.recordset")
		ors_edit_stu.open sql_edit_stu,Conn,1,3
'response.write sql_edit_stu
 set conn = nothing

' end if
'response.write "hello"

'
%>
</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: save_edit_stu.asp.bak