-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsignupFunctions.inc.php
117 lines (88 loc) · 2.15 KB
/
signupFunctions.inc.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
<?php
function emptyInputSignup($name,$email,$username,$pwd,$pwdRepeat){
$result;
if( empty($name) || empty($email) ||
empty($username) || empty($pwd) ||
empty($pwdRepeat)){
$result = true;
}else{
$result = false;
}
return $result;
}
function invalidUid($username){
$result;
if(!preg_match("/^[a-zA-Z0-9]*$/", $username)){
$result = true;
}else{
$result =false;
}
return $result;
}
function invalidEmail($email){
$result;
if(!filter_var($email, FILTER_VALIDATE_EMAIL)){
$result = true;
}else{
$result =false;
}
return $result;
}
function pwdMatch($pwd,$pwdRepeat){
$result;
if($pwd !== $pwdRepeat){
$result = true;
}else{
$result =false;
}
return $result;
}
function uidExists($conn, $username,$email){
$sql = "SELECT * FROM users WHERE usersUid = ? OR usersEmail = ?;";
$stmt = mysqli_stmt_init($conn);
if(!mysqli_stmt_prepare($stmt,$sql)){
header("location: ../signup.php?error=stmtbrehfailed");
exit();
}
mysqli_stmt_bind_param($stmt,"ss", $username,$email);
mysqli_stmt_execute($stmt);
$resultData = mysqli_stmt_get_result($stmt);
if($row = mysqli_fetch_assoc($resultData)){
return $row;
}
else{
$result = false;
return $result;
}
mysqli_stmt_close($stmt);
}
function emptyInputLogin($username,$pwd){
$result;
if( empty($username) || empty($pwd)){
$result = true;
}else{
$result = false;
}
return $result;
}
function createUser($conn, $name, $email,$username, $pwd){
$sql = "INSERT INTO users (usersName,usersEmail,usersUid,usersPwd) VALUES(?, ?, ?, ?);";
$stmt = mysqli_stmt_init($conn);
if(!mysqli_stmt_prepare($stmt,$sql)){
header("location: ../signup.php?error=stmtfailed");
exit();
}
$hashedPwd = password_hash($pwd, PASSWORD_DEFAULT);
mysqli_stmt_bind_param($stmt,"ssss", $name,$email,$username,$hashedPwd);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
header("location: ../signup.php?error=none");
exit();
}
function certifyCaptcha($response){
if($response->success){
return false;
}
else
return true;
}