Jump to content


Photo

How do I send the encrypted user password thru email? HELP!


  • Please log in to reply
2 replies to this topic

#1 eastcoastdubs

eastcoastdubs
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationAllentown, PA

Posted 15 February 2003 - 11:39 PM

I have finally made a perfectly functioning forgot password email script. Emails perfectly, subject, to, from, body. except. the this

The password field name in the database is userpassword. I AM using mysql\'s encryption method password(\'userpassword\') but how do I send it to the email? I have the select query doing thing.

$sql = \"SELECT userpassword, username, useremail FROM $user_tablename WHERE useremail = \'$email\'\";

it works fine. BUT the userpassword is not passed thru to the email with $userpassword.

anyhelp? thanks all, btw I have only been working with mysql for a week now so bear with me if this is a major brain fart.

Also, is there a better/easier encryption method? that will do what I am looking to do?
eastcoastdubs.com - the next generation of volkswagen enthusiasts

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 16 February 2003 - 12:06 AM

md5() is a better method... you will have to e-mail them the password before encrypting it, otherwise it will need to be reset.

i\'m not the auto enhancement type of guy, but great choice of car... :D
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 eastcoastdubs

eastcoastdubs
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationAllentown, PA

Posted 16 February 2003 - 04:24 AM

one more question. the database I\'m making is just for users having a profile of there cars. Do you really think it is necessary to even encrypt the passwords?
eastcoastdubs.com - the next generation of volkswagen enthusiasts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users