-
Notifications
You must be signed in to change notification settings - Fork 0
/
UserDbModel.php
71 lines (60 loc) · 1.9 KB
/
UserDbModel.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
<?php
require_once("DBConnection.php");
class UserDbModel
{
public static function AddUser($email, $password)
{
$sql = "INSERT INTO `users` (`user_id`, `email`, `password`) VALUES (NULL, '$email', '$password')";
$db = new DBConnection();
$res = $db->Execute($sql);
return $res;
}
public static function FindUser($email)
{
$sql = "SELECT * FROM users WHERE email = '$email'";
$dbConnection = new DBConnection();
$result = $dbConnection->Select($sql);
if (count($result) == 0) {
return null;
}
$user = $result[0];
return $user;
}
public static function FindUserById($id)
{
$sql = "SELECT * FROM users WHERE user_id = '$id'";
$dbConnection = new DBConnection();
$result = $dbConnection->Select($sql);
if (count($result) == 0) {
return null;
}
$user = $result[0];
return $user;
}
public static function UpdateUser($user)
{
$sql = "UPDATE users SET users.email = '$user->email', users.password = '$user->password' WHERE users.user_id = '$user->user_ID'";
$db = new DBConnection();
$db->Execute($sql);
return $user;
}
public static function GetAllUsers()
{
$sql = "SELECT * FROM users WHERE `user_id` <> 1";
$dbConnection = new DBConnection();
$result = $dbConnection->Select($sql);
if (count($result) == 0) {
return null;
}
return $result;
}
public static function DeleteUserById($id)
{
$dbConnection = new DBConnection();
$sql = "DELETE FROM users WHERE `user_id`= $id";// AND `userId` = $userId";
$result = $dbConnection->Execute($sql);
$sql = "DELETE FROM operations WHERE `userId` = $id";
$dbConnection->Execute($sql);
return $result;
}
}