Send verification email with link 1

[Chomauk]

I have a site where a verification email is sent to the user after they've entered their info at my site. What I need to know is how do I email a link(with a unique ID) to which the user can click on to enter a page that will validate them on my database.
In essence:
I can already email the user(s) but how do I email a link so when it's clicked on it'll take the user to a page that will automically verify them on my MySQL DB?

Thanks

If you're going through hell, keep going.
--Sir Winston Churchill (1874 - 1965)

 

[sleipnir214]

Some mail clients will take something that looks like a well-formed URL and make it behave like a link, even in a text message. Others do not.

What I recommend is that you send an email that contains the text containing the link both in plaintext and HTML as separate parts of a multipart MIME message.

PHPMailer is a PHP class which can make the sending of complex email messages less difficult.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[MJB3K]

say the user id was 244.

the link would be something like

http://www.mysite.com/validateuser.php?uid=244

have a field called validated in ur table

validateuser.php

<?php
//do db connection

$uid = $_GET['uid'];

$q = mysql_query("UPDATE tblname SET validated = 'yes' WHERE uid = '$uid'") or die(mysql_error());

then when someone tries 2 login select the uid from the table then check if validated. something like:

$q = mysql_query("SELECT validated FROM tblname WHERE uid = '$uid' //presuming you got a uid from the login script

while(list($v) = mysql_fetch_row($q)){

if($v == "yes"){
echo "Validated";
}else{
echo "Click link in email";
}
}//end while loop

this might be a bit long winded. hope you understand!


Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[ingresman]

Looks ok to me, I would generate a non obvious key though e.g. put the 244 through MD5

 

[Chomauk]

Thanks for the info... I'll try your code MJB3K and let you know how it goes.

Thanks again all

If you're going through hell, keep going.
--Sir Winston Churchill (1874 - 1965)

 

[Chomauk]

Worked great! thanks again.

If you're going through hell, keep going.
--Sir Winston Churchill (1874 - 1965)