I am using a php script for sending email alerts to a list of recipients that I have in MySQL. I want to automate the unsubscribe process for recipients because right now I have a static page where they have to manually enter their info. Since anyways I am calling out the variables in my script for each individual recipient to send emails, I can perhaps also customize the unsubscribe url for each that can have info about their email and keyword that they had initial signed up for. Do you guys think it is possible to auto populate my form fields using this method? Or would you recommend any other method? Here's a brief code
$rr=$row["keyword"];
$tt=$row["emailid"];
$to= $tt;
$subject = 'New updates for '.$rr;
$message='<html><body><b>Alerts for '.$rr.'</b><br><br>';
$message.='<b>'.$total.' updates found</b><br>';
$i=1;
while ($row= mysql_fetch_array($query))
{
$message.='<br><span style="font-size:13px"><b>';
$message.=$i.') '.$row["title"].'</b></span><br>';
$message.=' '.$row["link"].'<br>';
$i=$i+1;
}
$message.='<br><br><br>Thanks for setting up alerts ';
$message.='To unsubscribe from daily alerts, please click the link below,<br>';
$message.='<a href="http://www.domain.com/alert_unsubcribe.php">Unsubscribe</a>';
$message.='</body></html>';
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";