-
Notifications
You must be signed in to change notification settings - Fork 1
/
_l_config.php
139 lines (131 loc) · 4.54 KB
/
_l_config.php
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
<?php
$qld = array(
'HOST' => 'http://localhost/qld/'
);
class _l_clsKetnoi{
private $user='sa';
private $pass='system';
// Create connection to Oracle
function ketnoi(){
$conn = @oci_connect($this->user, $this->pass, '//127.0.0.1/orcl:qlkqht');
return $conn;
}
function checklogin($us, $pa){
$pa = md5($pa);
$conn = $this->ketnoi();
$sql = "
SELECT sv.MASV, 'sinhvien' as LOAI FROM SV sv where (sv.MASV = :svMa OR sv.EMAILSV = :svMail) and sv.MATKHAU = :svMk
UNION
SELECT gv.MAGV, 'giaovien' as LOAI FROM GV gv WHERE (gv.MAGV = :gvMa OR gv.EMAILGV = :gvMail) and gv.MATKHAU = :gvMk
UNION
SELECT pdt.MACBPDT, 'phongdaotao' AS LOAI FROM CBPDT pdt WHERE (pdt.MACBPDT = :pdtMa OR pdt.EMAILCBPDT = :pdtMail) and pdt.MATKHAU = :pdtMk
UNION
SELECT qt.MANQT, 'quantri' AS LOAI FROM NQT qt WHERE (qt.MANQT = :qtMa OR qt.EMAILNQT = :qtMail) AND qt.MATKHAU = :qtMk";
$p_sql = oci_parse($conn,$sql);
oci_bind_by_name($p_sql, ":svMa", $us);
oci_bind_by_name($p_sql, ":svMail", $us);
oci_bind_by_name($p_sql, ":svMk", $pa);
oci_bind_by_name($p_sql, ":gvMa", $us);
oci_bind_by_name($p_sql, ":gvMail", $us);
oci_bind_by_name($p_sql, ":gvMk", $pa);
oci_bind_by_name($p_sql, ":pdtMa", $us);
oci_bind_by_name($p_sql, ":pdtMail", $us);
oci_bind_by_name($p_sql, ":pdtMk", $pa);
oci_bind_by_name($p_sql, ":qtMa", $us);
oci_bind_by_name($p_sql, ":qtMail", $us);
oci_bind_by_name($p_sql, ":qtMk", $pa);
oci_execute($p_sql);
$dem = 0;
$loai = "khong";
while ($row = oci_fetch_array($p_sql)) {
$dem++;
$loai = $row[1];
}
oci_free_statement($p_sql);
oci_close($conn);
return $loai;
}
function checkmail($us){
$conn = $this->ketnoi();
$sql = "
SELECT 'sinhvien' as LOAI FROM SV sv where (sv.EMAILSV = :svMail)
UNION
SELECT 'giaovien' as LOAI FROM GV gv WHERE (gv.EMAILGV = :gvMail)
UNION
SELECT 'phongdaotao' AS LOAI FROM CBPDT pdt WHERE (pdt.EMAILCBPDT = :pdtMail)
UNION
SELECT 'quantri' AS LOAI FROM NQT qt WHERE (qt.EMAILNQT = :qtMail)";
$p_sql = oci_parse($conn,$sql);
oci_bind_by_name($p_sql, ":svMail", $us);
oci_bind_by_name($p_sql, ":gvMail", $us);
oci_bind_by_name($p_sql, ":pdtMail", $us);
oci_bind_by_name($p_sql, ":qtMail", $us);
oci_execute($p_sql);
$dem = 0;
$loai = "khong";
while ($row = oci_fetch_array($p_sql)) {
$dem++;
$loai = $row[0];
}
oci_free_statement($p_sql);
oci_close($conn);
return $loai;
}
function capnhatmatkhau($dcmail, $loai, $matkhau){
switch ($loai) {
case 'sinhvien':
// gửi mail quên mật khẩu cho sinh viên
$conn = $this->ketnoi();
$sql = "UPDATE SV SET MATKHAU=:mk WHERE EMAILSV=:mail";
$p_sql = oci_parse($conn, $sql);
oci_bind_by_name($p_sql, ":mk",$matkhau);
oci_bind_by_name($p_sql, ":mail",$dcmail);
oci_execute($p_sql);
$r_sql = oci_num_rows($p_sql);
if ($r_sql > 0)
return true;
return false;
break;
case 'giaovien':
// gửi mail quên mật khẩu cho giáo viên
$conn = $this->ketnoi();
$sql = "UPDATE GV SET MATKHAU=:mk WHERE EMAILGV=:mail";
$p_sql = oci_parse($conn, $sql);
oci_bind_by_name($p_sql, ":mk",$matkhau);
oci_bind_by_name($p_sql, ":mail",$dcmail);
oci_execute($p_sql);
$r_sql = oci_num_rows($p_sql);
if ($r_sql > 0)
return true;
return false;
break;
case 'phongdaotao':
// gửi mail quên mật khẩu cho PDT
$conn = $this->ketnoi();
$sql = "UPDATE CBPDT SET MATKHAU=:mk WHERE EMAILCBPDT=:mail";
$p_sql = oci_parse($conn, $sql);
oci_bind_by_name($p_sql, ":mk",$matkhau);
oci_bind_by_name($p_sql, ":mail",$dcmail);
oci_execute($p_sql);
$r_sql = oci_num_rows($p_sql);
if ($r_sql > 0)
return true;
return false;
break;
case 'quantri':
// gửi mail quên mật khẩu cho NQT
$conn = $this->ketnoi();
$sql = "UPDATE NQT SET MATKHAU=:mk WHERE EMAILNQT=:mail";
$p_sql = oci_parse($conn, $sql);
oci_bind_by_name($p_sql, ":mk",$matkhau);
oci_bind_by_name($p_sql, ":mail",$dcmail);
oci_execute($p_sql);
$r_sql = oci_num_rows($p_sql);
if ($r_sql > 0)
return true;
return false;
break;
}
}
}
?>