-
Notifications
You must be signed in to change notification settings - Fork 2
/
getPlaylistInfo.php
70 lines (59 loc) · 3.18 KB
/
getPlaylistInfo.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
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');
header("Access-Control-Allow-Headers: *");
header('Content-Type: application/json');
require 'conn.php';
require 'getUsernameFromToken.php';
$token = $_GET['token'];
$username = getUsernameFromToken($token,$conn);
$playlistId = $_GET['playlistId'];
$respnse = [];
$respnse["songs"] = [];
$sql = mysqli_query($conn,"SELECT title FROM playlists WHERE id = '$playlistId'");
$title = mysqli_fetch_assoc($sql)['title'];
$id = mysqli_fetch_assoc($sql)['id'];
$respnse['title'] = $title;
$respnse['id'] = $id;
$sql = mysqli_query($conn,"SELECT songId FROM palylistsongs WHERE playlistId ='$playlistId' ");
while($row = mysqli_fetch_assoc($sql))
{
$songId = $row['songId'];
if($result = mysqli_query($conn,"SELECT * FROM songs WHERE id = '$songId' "))
{
while($row2=mysqli_fetch_assoc($result)){
// get song artist
$artistId = $row2['artist'];
$result2 = mysqli_query($conn,"SELECT name FROM artists WHERE id='$artistId'");
$artist = mysqli_fetch_assoc($result2)['name'];
//get song album
$albumId = $row2['album'];
$query = mysqli_query($conn,"SELECT title FROM albums WHERE id = '$albumId' ");
$album = mysqli_fetch_assoc($query)['title'];
//like by user or not
$isLiked = false;
$sql2 = mysqli_query($conn,
"SELECT uername FROM likedsongs WHERE uername= '$username' AND songId = '$songId' ");
if(mysqli_num_rows($sql2)==1)
{
$isLiked = true;
}
array_push($respnse["songs"], [
'id'=>$row2['id'],
'title'=>$row2['title'],
'artist'=>$artist,
'artistId'=>$artistId,
'albumId'=>$row2['album'],
"album"=> $album,
'songUrl'=>$row2['songUrl'],
'artPath'=>$row2['artPath'],
'duration'=>$row2['duration'],
'genre'=>$row2['genre'],
'likes'=>$row2['likes'],
'isLikedByUser'=>$isLiked,
]);
}
}
}
echo json_encode($respnse);
?>