whichever way the original password was encrypted, encrypt the incoming password the same way, ie. if the original was encrypted in php, encrypt the incoming password in php before passing it to the sql statement, similarly if the original password was encrypted using mysql.
Martin -----Original Message----- From: Antonio S. Martins Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 6:47 AM To: Hawk Cc: [EMAIL PROTECTED] Subject: Re: [PHP] ok, I ask again.. how to encrypt to be able to match database info? On Mon, 21 Jan 2002, Hawk wrote: > I've asked this several times but it doesn't seem like anyone understands my > problem, the passwords are encrypted in the database, but I don't know how > to match an unencrypted password from the login form with the database? > is it possible to encrypt the password I sent from the form in php or does > that have to be done in mysql? > in any case, how do I do it? > If you don't have anything bright to say, don't, in some of the replys I've > had earlier it sounds like you think I'm an idiot... > And even if I am, I don't want to be refered as one ;) How you had encrypted your password? with MySQL 'password' function? if yes, try: select user, ... from table where user = "$user" and passwd = password("$passwd") I think you get the idea :) hope this helps, Antonio. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | Antonio S. Martins Jr. - System Analist | "Only The Shadow Knows | | WorldNet Internet Maringa - PR - Brasil | what evil lurks in the | | E-Mail: [EMAIL PROTECTED] | Heart of Men!" | | [EMAIL PROTECTED] | !!! Linux User: 52392 !!! | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ This e-mail message is 100% Microsoft free! /"\ \ / CAMPANHA DA FITA ASCII - CONTRA MAIL HTML X ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL / \ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
