-
Notifications
You must be signed in to change notification settings - Fork 0
/
teachUpdate.asp
148 lines (136 loc) · 6.42 KB
/
teachUpdate.asp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!-- #include file="Assets/inc/conn.asp" -->
<!-- #include file="Assets/inc/system.asp" -->
<!-- #include file="Assets/inc/userControl.asp" -->
<%if user("Yetki")<>0 then response.Redirect("default.asp")%>
<%
Function Temizleyici(TMZ)
TMZ = replace(TMZ, ",", "'")
Temizleyici = TMZ
End Function
if isnumeric(Temizleyici(request.QueryString("userID")))=false then
response.redirect "start.asp"
response.End
end if
if request.QueryString("userID")<>"" and isnumeric(request.QueryString("userID")) then
userID = request.QueryString("userID")
else
%>
<script language="javascript" type="text/javascript">
alert("Hatalı giriş. Lütfen bilgilerin doğruluğundan emin olun.");
location.href="start.asp";
</script>
<%
end if
sql="Select * From de_User WHERE Yetki=1 and userID="&userID&""
Set teachers = conn.Execute(sql)
if teachers.eof then
response.redirect "start.asp"
response.End()
end if
if request.ServerVariables("REQUEST_METHOD")="POST" then
if request.Form("ad")<>"" and request.Form("soyad")<>"" and request.Form("password")<>"" and request.Form("mail")<>"" and request.Form("kota")<>"" then
set YeniOgr = server.createobject("adodb.recordset")
sql="Select * From de_User WHERE userID=" & userID
YeniOgr.open sql,conn,1,3
set studentsTT = server.createobject("adodb.recordset")
sql="Select * From de_User WHERE teachersID=" & userID
studentsTT.open sql,conn,1,3
YeniOgr("ad")=request.Form("ad")
YeniOgr("soyad")=request.Form("soyad")
YeniOgr("password")=request.Form("password")
YeniOgr("mail")=request.Form("mail")
YeniOgr("kota_k")=request.Form("kota") - studentsTT.recordcount
YeniOgr("kota")=request.Form("kota")
YeniOgr.Update
%>
<script type="text/javascript">
alert("Başarıyla güncellendi.");
location.href="teachers.asp";
</script>
<%
else
%>
<script type="text/javascript">
alert("Lütfen tüm alanları doldurun.");
location.href="teachUpdate.asp?userID=<%=userID%>";
</script>
<%
end if
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Değerler Eğitimi - Öğretmenler</title>
<link href="Assets/css/main.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" language="javascript">
function onlyNum(obj){
var kelime = obj.value;
obj.value = kelime.replace(/[(<>"'*\-+!\\"^\/_$çÇğĞıİöÖ şŞü.Ü{}\[\]¼#²¹¬<>|~%&'()=?,&A-z]/g,'') //Sayı kontrol
}
function onlyEN(obj){
var kelime = obj.value;
obj.value = kelime.replace(/[(<>"'*\-+!\\"^\/$çÇğĞıİöÖ şŞü.Ü{}\[\]¼#²¹¬<>|~%&'()=?]/g,'') //Rumuz kontrol
}
</script>
</head>
<body>
<div id="main">
<!-- #include file="Assets/inc/sidebar.asp" -->
<div id="panel">
<!-- #include file="Assets/inc/userbar.asp" -->
<div id="maincontent">
<!-- //ContentBox1 -->
<div class="contentpanel">
<div class="contenttitle">
<table width="698" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="349" align="left" valign="middle">Öğretmen Düzenle</td>
<td width="349" align="right" valign="middle"><a href="teachers.asp" class="backlink">Öğretmenler</a></td>
</tr>
</table>
</div>
<div class="contentbox">
<form action="" method="POST">
<table width="696" border="0" cellspacing="1" cellpadding="0">
<tr bgcolor="#DFF4FF">
<td width="200" height="30" align="right" valign="middle"><span style="font-size:14px;">Ad:</span></td>
<td width="493" height="30" align="left" valign="middle"><input type="text" name="ad" class="formtext" value="<%=teachers("ad")%>" /></td>
</tr>
<tr bgcolor="#CAEDFF">
<td height="30" align="right" valign="middle"><span style="font-size:14px;">Soyad:</span></td>
<td height="30" align="left" valign="middle"><input type="text" name="soyad" class="formtext" value="<%=teachers("soyad")%>" /></td>
</tr>
<tr bgcolor="#DFF4FF">
<td width="200" height="30" align="right" valign="middle"><span style="font-size:14px;">Kullanıcı Adı:</span></td>
<td width="493" height="30" align="left" valign="middle"><input type="text" name="username" class="formtext" onKeyUp="onlyEN(this);" value="<%=teachers("username")%>" disabled="disabled" /></td>
</tr>
<tr bgcolor="#CAEDFF">
<td height="30" align="right" valign="middle"><span style="font-size:14px;">Parola:</span></td>
<td height="30" align="left" valign="middle"><input type="password" name="password" class="formtext" value="<%=teachers("password")%>" /></td>
</tr>
<tr bgcolor="#DFF4FF">
<td width="200" height="30" align="right" valign="middle"><span style="font-size:14px;">E-Posta:</span></td>
<td width="493" height="30" align="left" valign="middle"><input type="text" name="mail" class="formtext" value="<%=teachers("mail")%>" /></td>
</tr>
<tr bgcolor="#CAEDFF">
<td height="30" align="right" valign="middle"><span style="font-size:14px;">Kota:</span></td>
<td height="30" align="left" valign="middle"><input type="text" name="kota" class="formtext" onKeyUp="onlyNum(this);" value="<%=teachers("kota")%>" /></td>
</tr>
<tr>
<td height="30" align="right" valign="middle"> </td>
<td height="30" align="left" valign="middle"><input type="submit" value="Güncelle" class="formadd" /></td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
<div id="clear"></div>
<!-- #include file="Assets/inc/footer.asp" -->
</div>
</body>
</html>