Zach's git repos / prosongsa
Backend for songs.zachdecook.com
* Favorites: Add ability to "Favorite" a song
Browse Source
Zach DeCook 2018-11-04
parent dc869d7 · commit c72140a
Diffstat
-rw-r--r--db/.gitignore1
-rwxr-xr-xindex.php12
-rw-r--r--page.php11
3 files changed, 24 insertions, 0 deletions
diff --git a/db/.gitignore b/db/.gitignore
new file mode 100644
index 0000000..98e6ef6
--- /dev/null
+++ b/db/.gitignore
@@ -0,0 +1 @@
+*.db
diff --git a/index.php b/index.php
index 241cd4a..9664b02 100755
--- a/index.php
+++ b/index.php
@@ -4,6 +4,18 @@ if ( isset( $_GET['theme'] ) ){
$theme = $_GET['theme'];
setcookie( 'theme', $theme, time()+60*60*24*30 );
}
+if ($_POST['song'] && $_POST['name'])
+{
+ $song = str_replace( "'", "", $_POST['song'] );
+ $name = str_replace( "'", "", $_POST['name'] );
+ $file_db = new SQLite3('db/favs.db');
+ $file_db->exec( "CREATE TABLE IF NOT EXISTS favorites ( name TEXT, song TEXT );" );
+ $query = "INSERT INTO favorites VALUES( '$name', '$song' );";
+ $file_db->exec( $query );
+ $file_db = NULL;
+ setcookie( 'name', $name, time()+60*60*24*356 );
+ $_COOKIE['name'] = $name;
+}
?>
<!--
index.php contains the main html used for creating the page.
diff --git a/page.php b/page.php
index be629d3..ba30fe1 100644
--- a/page.php
+++ b/page.php
@@ -180,11 +180,22 @@ function load_song( $number, $transp = 0 )
return
renderNavButtons( $number )
. renderEasyTransp( $transp, $number, $songKeys )
+ . renderFavorite( $number )
. "<pre>" . $song . "</pre>\n"
. renderNavButtons( $number )
. renderSS($suggestedSong, $songKeys, $transp);
}
+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>";
+}
+
function renderEasyTransp( $transp, $num, $songKeys = array() )
{
$s = '';