如果用户点击他/她的电子邮件内容中的任何链接，那么更新数据库意味着是否有任何条目？

Question

When a user subscribes to my newsletter via their email address, using php, how would I send them an 'Activation Link' via email to confirm it is their email address and not a fake one.

so at the moment I have

PHP:

<?php
 $to = "[e-mail]";
 $subject = "Hi!";
 $body = "Hi,

How are you?";
 if (mail($to, $subject, $body)) {
   echo "<p>Message successfully sent!</p>";
  } else {
   echo "<p>Message delivery failed...</p>";
  }
 ?>

I guess i would change the $body to this:

$body = "Please click the link to activate your email 

http://www.activationlink.com?";

How would I make it so that if a user clicked that link it would add their details to the Mysql database recognising they are a legitimate subscriber?

Any help or suggestions appreciated. Thanks

Answer 1

Quick google search result

http://www.learnphponline.com/scripts/email-activation-for-php-forms

basically you need to create a subscriber table and have a boolean flag call verified, of coz store the email address in that table