RE: [PHP] regarding password in mysql?
| From: | Don Read | Date: | Sat, 28 Jul 2001 13:56:41 +0000 |
| Subject: | RE: [PHP] regarding password in mysql? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-60044@lists.php.net to get a copy of this message | ||
On 28-Jul-2001 Balaji Ankem wrote:
> Hi dearest friends,
>
> while insertion of an employee number and password i am inserting
> like
>
> insert into employee values('$empid',PASSWORD('$passwd'));
>
> how to decrypt it while comparision during login.
>
You don't.
"select id from employee where id='$usrid' and
passwd=PASSWORD('$usrpass') ";
If you get a record back, the password matched.
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.