-
Notifications
You must be signed in to change notification settings - Fork 1
/
SharedLists.cls.php
111 lines (95 loc) · 2.66 KB
/
SharedLists.cls.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
<?php
class SharedLists{
private $id;
private $user_id;
private $list_id;
function __construct($id = null, $user_id = null, $list_id = null) {
$this->id = $id;
$this->user_id = $user_id;
$this->list_id = $list_id;
}
/**
* @return string
*/
public function getId()
{
return $this->id;
}
/**
* @return string
*/
public function getUser_id()
{
return $this->user_id;
}
/**
* @return string
*/
public function getList_id()
{
return $this->list_id;
}
/**
* @param string $id
*/
public function setId($id)
{
$this->id = $id;
}
/**
* @param string $user_id
*/
public function setUser_id($user_id)
{
$this->user_id = $user_id;
}
/**
* @param string $list_id
*/
public function setList_id($list_id)
{
$this->list_id = $list_id;
}
public function create($connection){
$user_id = $this->user_id;
$list_id = $this->list_id;
$sqlstmt = "INSERT INTO user_list (user_id, list_id) VALUES ($user_id, $list_id)";
$result = $connection->exec($sqlstmt);
return $result;
}
public function delete($connection){
$sqlStmt = "DELETE from user_list WHERE user_id = $this->user_id AND list_id = $this->list_id";
return $connection->exec($sqlStmt);
}
public function getUserIdByListId($connection){
$sqlStmt = "SELECT user_id FROM user_list WHERE list_id=:list_id";
$prepare = $connection->prepare($sqlStmt);
$prepare->bindValue(":list_id", $this->list_id);
$prepare->execute();
$result = $prepare->fetchAll();
if (sizeOf($result) > 0){
return $result;
}
}
public function getListIdByUserId($connection){
$sqlStmt = "SELECT list_id FROM user_list WHERE user_id=:user_id";
$prepare = $connection->prepare($sqlStmt);
$prepare->bindValue(":user_id", $this->user_id);
$prepare->execute();
$result = $prepare->fetchAll();
if (sizeOf($result) > 0){
return $result;
}
}
public function getSharedLists($connection){
$sqlStmt = "SELECT * FROM user_list WHERE list_id=:list_id AND user_id=:user_id";
$prepare = $connection->prepare($sqlStmt);
$prepare->bindValue(":list_id", $this->list_id);
$prepare->bindValue(":user_id", $this->user_id);
$prepare->execute();
$result = $prepare->fetchAll();
if (sizeOf($result) > 0){
return $result;
}
}
}