From c72140a556834ae9494890f86c42bd967e35cfdd Mon Sep 17 00:00:00 2001
From: Zach DeCook <zachdecook@gmail.com>
Date: Sun, 4 Nov 2018 15:13:16 -0500
Subject: * Favorites: Add ability to "Favorite" a song

---
 index.php | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'index.php')

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.
-- 
cgit 1.4.1