Backend for songs.zachdecook.com
Diffstat (limited to 'favs.php')
| -rw-r--r-- | favs.php | 16 |
1 files changed, 16 insertions, 0 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>"; +} |