-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfunc.php
More file actions
119 lines (101 loc) · 3.72 KB
/
func.php
File metadata and controls
119 lines (101 loc) · 3.72 KB
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
<?php
function uidExists($conn, $username, $email) {
$sql = "SELECT * FROM users WHERE uidUsers=? OR emailUsers=?;";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql)) {
echo json_encode(array('message' => 'SQL error'));
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;
echo json_encode(array('status' => 'Username or email already exists'));
}
else {
$result = false;
return $result;
echo json_encode(array('status' => 'success'));
}
mysqli_stmt_close($stmt);
}
function createUser($conn, $firstname, $lastname, $username, $password, $email) {
$sql = "INSERT INTO users (uidUsers, fnUsers, lnUsers, emailUsers, passUsers) VALUES (?, ?, ?, ?, ?);";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql)) {
echo json_encode(array('message' => 'SQL error'));
exit();
}
$hashedPwd = password_hash($password, PASSWORD_DEFAULT);
mysqli_stmt_bind_param($stmt, "sssss", $username, $firstname, $lastname, $email, $hashedPwd);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
echo json_encode(array('status' => 'success'));
exit();
}
function loginUser($conn, $username, $password) {
$uidExists = uidExists($conn, $username, $username);
if ($uidExists == false) {
echo json_encode(array('status' => 'Username or email does not exist'));
exit();
}
$hashedPwdCheck = password_verify($password, $uidExists['passUsers']);
if ($hashedPwdCheck == false) {
echo json_encode(array('status' => 'Password is incorrect'));
exit();
} else if ($hashedPwdCheck == true) {
echo json_encode(array('email' => $uidExists['emailUsers'], 'firstname' => $uidExists['fnUsers'], 'lastname' => $uidExists['lnUsers'],'pp' => $uidExists['uImage'],'points'=> $uidExists['uPoints'], 'solved'=>$uidExists['uSolved'] ,'status' => 'success', 'authenticated' => 'true'));
exit();
}
}
/*
function uploadImage($conn,$uid,$pp) {
$response = array();
$DIR = 'uploads/';
$urlServer = 'http://127.0.0.1/api';
if($pp)
{
$fileName = $pp["name"];
$tempFileName = $pp["tmp_name"];
$error = $pp["error"];
if($error > 0){
$response = array(
"status" => "error",
"error" => true,
"message" => "Error uploading the file!"
);
}else
{
$FILE_NAME = rand(10, 1000000)."-".$fileName;
$UPLOAD_IMG_NAME = $DIR.strtolower($FILE_NAME);
$UPLOAD_IMG_NAME = preg_replace('/\s+/', '-', $UPLOAD_IMG_NAME);
if(move_uploaded_file($tempFileName , $UPLOAD_IMG_NAME)) {
$response = array(
"status" => "success",
"error" => false,
"message" => "Image has uploaded",
"url" => $urlServer."/".$UPLOAD_IMG_NAME
);
$ppurl = $urlServer."/".$UPLOAD_IMG_NAME;
$sql = "UPDATE users SET uImage='$ppurl' WHERE uidUsers='$uid';";
mysqli_query($conn, $sql);
}else
{
$response = array(
"status" => "error",
"error" => true,
"message" => "Error occured"
);
}
}
}else{
$response = array(
"status" => "error",
"error" => true,
"message" => "File not found"
);
}
echo json_encode($response);
}
*/