From 452b129ff5c30bc3a58cf69e0435b00d5975ab58 Mon Sep 17 00:00:00 2001
From: Zach DeCook <zachdecook@gmail.com>
Date: Sun, 4 Nov 2018 19:03:18 -0500
Subject: * Add simple page to view favs

---
 favs.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 favs.php

(limited to 'favs.php')

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>";
+}
-- 
cgit 1.4.1