}
$db = null;
} catch (PDOException $e) {
echo 'Exception: ' . $e->getMessage();
}
echo "Current privacy setting: " . $isPrivate;
}
?>
<hr>
<h3>Recently Uploaded:</h3>
<?php
$query = "select * from Song as S natural join (select title, artist, songUploader, count(starringUsername) as score from Starred group by title, artist, songUploader) where uploader=\"{$user}\" order by uploadTimeStamp desc limit 15;";
try {
$db = new PDO("sqlite:../database/noiseFactionDatabase.db");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$statement = $db->prepare($query);
$result = $statement->execute();
while ($row = $statement->fetch()) {
echo generateSongPlayer($row);
}
} catch (PDOException $e) {
echo 'Exception: ' . $e->getMessage();
}
?>
</div>
</body>
</html>
function printPlayList($pname, $owner)
{
try {
// This is for cases when we're using this method in a deeper page
// e.g.: /account/index.php
// It's also completely atrocious
try {
$db = new PDO("sqlite:/database/noiseFactionDatabase.db");
} catch (PDOException $e) {
$db = new PDO("sqlite:../database/noiseFactionDatabase.db");
}
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$statement = $db->prepare("select * from playlistcontainssong where playlistname = ? and owner = ? ;");
$result = $statement->execute(array($pname, $owner));
echo "<div> <h3> {$pname} - {$owner} </h3>";
while ($row = $statement->fetch()) {
echo generateSongPlayer($row);
}
echo '</div>';
$db = null;
} catch (PDOException $e) {
echo 'Exceptions: ' . $e->getMessage();
}
}
