-
Notifications
You must be signed in to change notification settings - Fork 0
/
controll.php
109 lines (100 loc) · 3.95 KB
/
controll.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
<?php
require('connect.php');
require 'PHPMailer/src/Exception.php';
require 'PHPMailer/src/PHPMailer.php';
require 'PHPMailer/src/SMTP.php';
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
class Controll{
public function SelectUser($stk)
{
# code...
global $conn;
$sql = "select * from t_account where stk = '$stk'";
$run = mysqli_query($conn, $sql);
$datarow = mysqli_num_rows($run);
return $datarow;
}
//funtion chọn pass
public function SelectPass($stk){
global $conn;
$sql = "select * from t_account where stk = '$stk'";
$run = mysqli_query($conn, $sql);
$data = array();
if($run){
while($rows=mysqli_fetch_array($run)){
$data[] = $rows;
}
}
return $data;
}
public function SelectEmail($email){
global $conn;
$sql = "select * from t_account where email = '$email'";
$run = mysqli_query($conn, $sql);
$data = array();
if($run){
while($rows=mysqli_fetch_array($run)){
$data[] = $rows;
}
}
return $data;
}
//function đổi mật khẩu
public function Update_pass($stk, $pass)
{
global $conn;
$sql = "update t_account set pass = '$pass' where stk = '$stk'";
$run = mysqli_query($conn, $sql);
return $run;
}
//function nạp tiền - chuyển tiền
public function Update_Balance($stk, $balance)
{
global $conn;
$sql = "update t_balance set balance = '$balance' where stk = '$stk'";
$run = mysqli_query($conn, $sql);
return $run;
}
//function kiểm tra số dư
public function Select_Balance($stk)
{
global $conn;
$sql = "select * from t_balance where stk = '$stk'";
$run = mysqli_query($conn, $sql);
$data = array();
if($run){
while($rows=mysqli_fetch_array($run)){
$data[] = $rows;
}
}
return $data;
}
//function gửi mail
public function SendMail($email, $receiver, $subject, $content)
{
$mail = new PHPMailer(true);
try {
$mail->isSMTP(); // using SMTP protocol
$mail->Host = 'smtp.gmail.com;smtp1.gmail.com;smtp2.gmail.com'; // SMTP host as gmail
$mail->SMTPAuth = true; // enable smtp authentication
$mail->Username = ''; // sender gmail host
$mail->Password = ''; // sender gmail host password
$mail->SMTPSecure = 'tls'; // for encrypted connection
$mail->Port = 587; // port for SMTP
$mail->CharSet = 'UTF-8';
$mail->Encoding = 'base64';
$mail->setFrom('[email protected]', "RiotBank"); // sender's email and name
$mail->addAddress($email, $receiver); // receiver's email and name
// $mail->Encoding = "utf-8";
$mail->Subject = $subject;
$mail->Body = $content;
//===============
$mail->send();
echo "<script>alert('Gửi mail thành công!')</script>";
} catch (Exception $e) { // handle error.
echo "<script>alert('Gửi mail thất bại!')</script>", $mail->ErrorInfo;
}
}
}
?>