* Don't show form if song is already fav'd

1 files changed, 19 insertions, 5 deletions

diff --git a/page.php b/page.php
index ba30fe1..8a2805d 100644
--- a/page.php
+++ b/page.php
@@ -189,11 +189,25 @@ function load_song( $number, $transp = 0 )
 function renderFavorite( $number )
 {
 	$number = str_replace( "'", "", $number );
-	return "<form method='post'>"
-		. "<input type='hidden' name='song' value='$number'>"
-		. "<input name='name' placeholder='your name' value=" . ($_COOKIE['name'] ??  '') . ">"
-		. "<input type='submit' value='Add to Favorites' class='btn btn-F'>"
-		. "</form>";
+	$name = str_replace("'", "", $_COOKIE['name'] ?? '' );
+	if ( $name )
+	{
+		$file_db = new SQLite3('db/favs.db');
+		$favd = $file_db->querySingle( "SELECT name from favorites where name = '$name' AND song = '$number'");
+	}
+	if ( $favd )
+	{
+		$favd = strip_tags( $favd );
+		return "Song in favorites for $favd";
+	}
+	else
+	{
+		return "<form method='post'>"
+			. "<input type='hidden' name='song' value='$number'>"
+			. "<input name='name' placeholder='your name' value=" . ($name ??  '') . ">"
+			. "<input type='submit' value='Add to Favorites' class='btn btn-F'>"
+			. "</form>";
+	}
 }
 
 function renderEasyTransp( $transp, $num, $songKeys = array() )