public static function remove($user_id, $song_id, $position)
{
$servername = "classroom.cs.unc.edu";
$username = "******";
$password = "******";
$dbname = "tklosedb";
$conn = new mysqli($servername, $username, $password, $dbname);
$delete = "DELETE FROM 1trainSongQueue WHERE user='******' AND id='{$song_id}' AND pos='{$position}'";
$result = $conn->query($delete);
if (!$result) {
echo "error removing song from queue database" . $conn->error;
}
return SongQueue::getUsersQueue($user_id);
}
if ($resource_type == 'home') {
header('HTTP/1.1 400 Bad Request');
print "Too many resources for home";
exit;
} else {
if ($resource_type == 'songinfo') {
$songid = $resource_components[2];
$song = Songs::getPostByID($songid);
$song = $song->getJSON();
header('Content-type: application/json');
print $song;
exit;
} else {
if ($resource_type == 'queue') {
$user = $resource_components[2];
foreach (SongQueue::getUsersQueue($user) as $idx => $song) {
$queue[] = array('user' => $song['user'], 'song' => $song['song'], 'title' => $song['title'], 'a_id' => $song['artist_id'], 'artist' => $song['artist'], 'art' => $song['art'], 'position' => $song['position']);
}
header('Content-type: application/json');
print json_encode($queue);
exit;
}
}
}
}
// header('Content-type: application/json');
// print(json_encode($queue));
// exit();
}
if (count($resource_components) == 4) {
if (isset($_REQUEST['delete'])) {