function getPlaylists()
{
$playlists = getAllPlaylists();
foreach ($playlists as $playlist) {
$user = $playlist["username"];
echo "<a href='info.php?playlist={$user}'><div class='album'>" . "<img src='Images/album-cover.png' alt='Song Cover'/>" . "<p>{$user}</p>" . "</div></a>";
}
}
<?php
function getAllPlaylists($userID)
{
$db_connection = new mysqli('stardock.cs.virginia.edu', 'cs4750ams5daa', 'music', 'cs4750ams5da');
if (mysqli_connect_errno()) {
echo "Connection Error!";
return;
}
$defaultIcon = "images/default-playlist-artwork.png";
$stmt = $db_connection->stmt_init();
if ($stmt->prepare("SELECT * FROM Playlists")) {
$stmt->execute();
$stmt->bind_result($p1, $playlistname, $iconURL);
while ($stmt->fetch()) {
if (!isset($iconURL) || trim($iconURL) === '') {
$iconURL = $defaultIcon;
}
echo "<div class=\"content-grid\" style=\"width: 10%;\"><a href=\"#\" onClick=\"play(" . $p1 . ", '" . addslashes($playlistname) . "')\"><img src=\"" . $iconURL . "\" title=\"album-name\" /></a><h3>" . $playlistname . "</h3><ul><button id=" . $p1 . " type=\"button\" class=\"btn btn-info btn-sm\" onclick=\"editPlaylist(this.id, '" . addslashes($playlistname) . "')\"><i class=\"fa fa-pencil\"></i> Edit Me</button></ul></div>";
}
}
}
getAllPlaylists();
