Mercurial > hg > ywww
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