[PHP] mail and mysql confirmation of that [double-opt in]
how is the best way to check if email address is valid: is this preg_match() OK? preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', $email); How can I make double opt-in mail system? My idea: 1.) I remember the email entered and user data and the sha1($email); in mysql db 2.) I send email with activation link of the sha1($email); 3.) I am not clear how to proceed when the link is activated. How to update the db and submit the necessary form to the marketing. Thanks in advance, -- When the sun rises I receive and when it sets I forgive -> http://users.skavt.net/~gleskovs/ All the Love, Grega Leskov'sek -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mail and mysql confirmation of that [double-opt in]
At 4:55 PM +0200 6/29/09, Grega Leskovsek wrote: how is the best way to check if email address is valid: is this preg_match() OK? preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', $email); How can I make double opt-in mail system? My idea: 1.) I remember the email entered and user data and the sha1($email); in mysql db 2.) I send email with activation link of the sha1($email); 3.) I am not clear how to proceed when the link is activated. How to update the db and submit the necessary form to the marketing. Thanks in advance, Double opt-in. 1. Have the user enter their email address via a form that let's them know they are subscribing to a service. You might want to check for a valid email address (many versions) and/or a CAPTCHA. additionally, you need to check if they have already registered OR in the process of registering. 2. After they submit their email address, then have your script create a unique token and record it coupled with the email address in your database. 3. Then send a confirmation email to that email address with the token appended as a link in the email -- with instructions for the receiver to either ignore the email (with apologies) or click the link and be taken back to your site where your script takes the confirmation token and checks your database for a token/email match. If there is one, then that completes the process and you have a confirmed double opt-in email address to use. If not, have them try again. Here's the script I wrote to do that: http://www.webbytedd.com/b/sub-email/index.php Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mail and mysql confirmation of that [double-opt in]
Grega Leskovsek wrote: > how is the best way to check if email address is valid: is this preg_match() > OK? > preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', > $email); filter_var($email, FILTER_VALIDATE_EMAIL) > > How can I make double opt-in mail system? My idea: > 1.) I remember the email entered and user data and the sha1($email); > in mysql db > 2.) I send email with activation link of the sha1($email); > 3.) I am not clear how to proceed when the link is activated. How to > update the db and submit the necessary form to the marketing. When the user clicks the activation link, mark the address active in the subscribers table, or move the entry from a pending table to a subscribers table. Then execute the email/whatever to marketing just as you would without using double opt-in. > > Thanks in advance, > > -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php