* Add simple page to view favs

1 files changed, 16 insertions, 0 deletions

diff --git a/favs.php b/favs.php
new file mode 100644
index 0000000..ab1e751
--- /dev/null
+++ b/favs.php
@@ -0,0 +1,16 @@
+<a href=".">Go back</a>
+<?php
+$db = new SQLite3( "db/favs.db");
+$name = str_replace("'", "", $_GET['name'] );
+$res = $db->query("SELECT * FROM favorites where name='$name';");
+if ( $res )
+{
+	echo "<ul>";
+	while ( $ar = $res->fetchArray() )
+	{
+		$song = str_replace( "'", "", $ar['song'] );
+		$song = strip_tags( $song );
+		echo "<li><a href='./?song=$song'>$song</a>";
+	}
+	echo "</ul>";
+}