Subscribe to our newsletter Form with unsubscribe feature
$10-30 USD
Complété
Publié il y a plus de 9 ans
$10-30 USD
Payé lors de la livraison
I need to add an option to subscribe to our newsletter on our website.
Important: The DIV has to match the design of our website. (so developer should have design skills)
Subscribe, unsubscribe features are required. Submitting of form and form validation should be ajax. When an email is added to the database; status=1 , when email is unsubscribed status is updated to null, if a user wants to subscribe again, then status will be updated from null to 1;
table structure is below. Email can not be duplicate
Developer should also provide a link that we will embed inside the newsletter that is sent to our users. this link will be:
If you want to unsubscribe from Veritec mailing list, click here
(so when user clicks on it, they will be unsubscribed from our mailing list)
CREATE TABLE IF NOT EXISTS `newsletter_subscriptions` (
`tid` int(9) NOT NULL AUTO_INCREMENT,
`email` varchar(255) NOT NULL,
`status` varchar(1) NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;