-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathforyou.php
134 lines (105 loc) · 4.2 KB
/
foryou.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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
require_once('frame_header.php');
verifyUserSession();
$userid = $_SESSION["loginUsername"];
echo "<input type='hidden' class='userid' value='$userid'>";
//below are SQL queries
$query_recentrack="SELECT t.trackname, ar.artistitle, t.trackid
FROM ((user u natural join likes l ) natural join track t) natural join albumcontent ac natural join album a natural join artist ar
WHERE u.username='{$userid}'
ORDER BY a.albumreleasedate DESC
LIMIT 10";
$query_recentlist="SELECT p.pid, p.ptitle, p.pdate, p.powner
FROM follows f join playlist p on f.username=p.powner
WHERE f.follower='{$userid}' AND p.public != 0
GROUP BY p.powner, p.pdate DESC
LIMIT 10;";
$query_recentplay="SELECT DISTINCT t.trackname, a.artistitle, t.trackid
FROM play p natural join track t natural join artist a
WHERE p.username='{$userid}'
ORDER BY p.playtime DESC
LIMIT 10;";
?>
<div class="container-fluid">
<div class="row">
<div class="col-md">
<h3 class="text-danger">Latest Track by liked Artists</h3>
<div>
<?php
$result=mysqli_query($conn,$query_recentrack);
if(mysqli_num_rows($result)>0){
while ($row=mysqli_fetch_assoc($result)) {
// find artistid from trackid
$trackid=$row["trackid"];
$a = mysqli_query($conn,"SELECT artistid FROM track where trackid = '$trackid' limit 1");
$b=mysqli_fetch_assoc($a);
$artistid=$b["artistid"];
echo "<div class='row listitem'>
<div class='col-md-7'>
<input type='hidden' class='td trackId' value='$trackid'>
<span class='trackName t'>".$row["trackname"]."</span>
</div>
<div class='col-md-5'>
<a href='artist.php?artistid=$artistid'>".$row["artistitle"]."</a>
<input type='hidden' class='ai' value='$artistid'>
<input type='hidden' class='trackId' value='$trackid'>
<img class='optionsButton' src='assets/images/icons/more.png' style='float:right' onclick='showOptionMenu(this)'>
</div>
</div><hr class='bg-danger'>";
}
}
?>
</div>
</div>
<div class="col-md">
<h3 class="text-primary">Latest Playlist from user followed</h3>
<div>
<?php
$result=mysqli_query($conn,$query_recentlist);
if(mysqli_num_rows($result)>0){
while ($row=mysqli_fetch_assoc($result)) {
echo "<div class='row listitem'>
<div class='col-md-8 playlistitle'>
<a href='playlist.php?pid=".$row["pid"]."'><b>".$row["ptitle"]."</b></a></div>
<div class='col-md-4 playlistowner'><a href='user.php?username=".$row["powner"]."'>".$row["powner"]."</a></div>
</div><hr class='bg-primary'>";
}
}
?>
</div>
</div>
<div class="col-md">
<h3 class="text-secondary">RECENT PLAY</h3>
<div>
<?php
$result=mysqli_query($conn,$query_recentplay);
if(mysqli_num_rows($result)>0){
while ($row=mysqli_fetch_assoc($result)) {
// find artistid from trackid
$trackid=$row["trackid"];
$a = mysqli_query($conn,"SELECT artistid FROM track where trackid = '$trackid' limit 1");
$b=mysqli_fetch_assoc($a);
$artistid=$b["artistid"];
echo "<div class='row listitem'>
<div class='col-md-7'>
<input type='hidden' class='td trackId' value='$trackid'>
<span class='trackName t'>".$row["trackname"]."</span>
</div>
<div class='col-md-5'>
<a href='artist.php?artistid=$artistid'>".$row["artistitle"]."</a>
<input type='hidden' class='ai' value='$artistid'>
<input type='hidden' class='trackId' value='$trackid'>
<img class='optionsButton' src='assets/images/icons/more.png' style='float:right' onclick='showOptionMenu(this)'>
</div>
</div><hr class='bg-secondary'>";
}
}
?>
</div>
</div>
</div>
</div>
<?php
require_once("includes/optionsMenu.php");
require_once('frame_footer.php');
?>