diff user/unsubscribe.php @ 6:077b0a0a3e6d

remaining originals according to dependency walk
author Robert Boland <robert@markup.co.uk>
date Thu, 16 Feb 2017 22:29:02 +0000
parents
children 385ddd7c4b55 a67bf725e87b
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/user/unsubscribe.php	Thu Feb 16 22:29:02 2017 +0000
@@ -0,0 +1,21 @@
+<?PHP
+
+$email = strval($_GET['email']);
+
+include "../../private/db.php";  
+
+$query = "update userpref set ReceiveEmail = 0 where UserID in (select UserID from user where Email = '$email') ";
+$results = mysqli_query($link, $query);
+
+if ( $results )
+{
+	$redirectURL = "unsubscribe.html";
+	header("Location:$redirectURL");
+}
+else{
+	echo "<p>Error updating preferences. Please email <a href=\"mailto:feedback@yournextread.com?subject=Unsubscribe Problem\">feedback</a></p>";
+}
+
+mysqli_close($link);
+
+?>
\ No newline at end of file