TheFilmGod Posted March 29, 2010 Share Posted March 29, 2010 I'm creating an online application. A users who registered will have an email sent to them for account activation. Until they click on the provided link, they aren't "officially" in the database. I would like to provide the "unsubscribe" link in ALL of my emails, even those in which a user is not "officially" saved in my database. How would I go around providing users the ability to unsubscribe from my emails? Should I create a blacklist of unsubscribed emails as a table in mysql? And everytime I want to send an email, I would check against the database to see if that user's email is in the blacklist, and if it is, do not send the email. Does this seem like a logical way of doing it? How do you guys manage your "unsubscribed" users? Link to comment https://forums.phpfreaks.com/topic/196886-unsubscribe-users/ Share on other sites More sharing options...
ignace Posted March 29, 2010 Share Posted March 29, 2010 Add a field subscription_status VARCHAR(12) which can hold (subscribed, unsubscribed, pending, renewed, ..) probably don't need no explanation Link to comment https://forums.phpfreaks.com/topic/196886-unsubscribe-users/#findComment-1033726 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.