about summary refs log tree commit diff
path: root/page.php
diff options
context:
space:
mode:
Diffstat (limited to 'page.php')
-rw-r--r--page.php24
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() )