RE: [PHP-DB] PASSWORD('xxxxx') and PHP
| From: | Matt Williams | Date: | Fri, 20 Jul 2001 08:58:44 +0000 |
| Subject: | RE: [PHP-DB] PASSWORD('xxxxx') and PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10598@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Is there a way to encode a string in PHP exactly like MySQL does it
> in its PASSWORD() Function?
>
> Reason being Is I have a table with PASSWORD() encoded fields
> that I need to
> compare from PHP.
just include PASSWORD() in your query ie.
SELECT * FROM wherever WHERE
password_field=PASSWORD('secretpassword')
HTH
M@
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBO1fywqW0/zC+QxWwEQJyYACgjjRSID3QJimCM/yjCiEW+jMbR3EAn1OV
gr7RzYMqC766L7q92EopaEIp
=G01U
-----END PGP SIGNATURE-----