Zach's git repos / prosongsa
Backend for songs.zachdecook.com
* Don't show form if song is already fav'd
Browse Source
Zach DeCook 2018-11-04
parent fe627f5 · commit 1ae9121
Diffstat
-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() )