-
Notifications
You must be signed in to change notification settings - Fork 2
/
LikeAlbum.php
45 lines (38 loc) · 1.62 KB
/
LikeAlbum.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
<?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';
$data = file_get_contents('php://input');
$response = [];
$data = json_decode($data);
$data = objectToArray($data);
function objectToArray ($object) {
if(!is_object($object) && !is_array($object)){
return $object;
}
return array_map('objectToArray', (array) $object);
}
$data = $data['data'];
$token = $data['token'];
$albumId = $data['albumId'];
$username = getUsernameFromToken($token,$conn);
$sql = mysqli_query($conn,
"SELECT id FROM albumlikers WHERE username= '$username' AND albumId = '$albumId'");
if(mysqli_num_rows($sql)==1)
{
$query = mysqli_query($conn,"DELETE FROM albumlikers WHERE username= '$username' AND albumId = '$albumId' ");
mysqli_query($conn,"UPDATE albums SET likes = likes - 1 WHERE id = '$albumId' ");
$response['isLikedAlbum'] = false;
}else{
if($query = mysqli_query($conn,"INSERT INTO albumlikers(albumId,username) VALUES('$albumId','$username')"))
{
mysqli_query($conn,"UPDATE albums SET likes = likes + 1 WHERE id = '$albumId' ");
$response['isLikedAlbum'] = true;
}else{
$response['isLikedAlbum'] = false;
}
}
echo json_encode($response);