[url removed, login to view]
I would like all of these form fields to be entered to the database.
Please insert IP address and date submitted to the database as well.
1) When this form is submitted, the visitor will see a message saying "We have sent you an e-mail with confirmation link." and an e-mail will be sent to the visitor with a confirmation link. Also, an e-mail with all fields posted will be sent to a specific e-mail address. Need to make sure that the e-mail address does not already exist in the system. When the visitor is typing their e-mail address in, email address field will use AJAX to check the database with each letter pressed to see if it is already in the database. If found, it will display "E-mail address already in use. Please contact us."
2) Once the visitor clicks on the confirmation link, a page saying "Your e-mail has been confirmed will appear." and that newsletter field will be marked as yes or 1 in the database.
3) We will need to create a page to unsubscribe. The user will enter their e-mail address and click send. They will see a message saying "We have sent you an e-mail confirmation link." Once the visitor clicks the link they received in e-mail, they will see a message saying "you have successfully unsubscribed" and the newsletter field in the database will be set to no or 0.