Backend for songs.zachdecook.com
* Add simple page to view favs
| -rw-r--r-- | favs.php | 16 | ||||
| -rw-r--r-- | page.php | 2 |
2 files changed, 17 insertions, 1 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>"; +} @@ -198,7 +198,7 @@ function renderFavorite( $number ) if ( $favd ) { $favd = strip_tags( $favd ); - return "Song in favorites for $favd"; + return "Song in <a href='favs.php?name=$name'>favorites for $favd</a>"; } else { |