ENCODE(value, 'secret code')
DECODE(field name, 'secret code')
to record
" ... VALUES ( ... blahblah, ENCODE('$passord', 'secret code', ... BLAH
BHAL") ;
and to read the value
do like this
MYSQL_QUERY("SELECT DECODE(password, 'secret code') as password, id, BLAH
BLAH
----- Original Message -----
From: "Ben C." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 12:07 PM
Subject: Re: [PHP] Trying to e-mail password
> Is there not any way to reverse the crypted password before e-mailing??
>
> If not, how do I use ENCODE / DECODE?
>
>
> >
> > From: "rija" <[EMAIL PROTECTED]>
> > Date: 2002/11/12 Tue PM 07:32:28 EST
> > To: "php" <[EMAIL PROTECTED]>,
> > "Ben C." <[EMAIL PROTECTED]>
> > Subject: Re: [PHP] Trying to e-mail password
> >
> > You should do like this:
> >
> > $password = $row['password'];
> > This return weird crypted value of your password.
> >
> > Unless you want send the this weird password. The function
mysql_password is
> > irreversible, you cannot get back the value crypted by password. Use
ENCODE
> > and DECODE instead,
> >
> >
> >
> > ----- Original Message -----
> > From: "Ben C." <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, November 13, 2002 11:09 AM
> > Subject: [PHP] Trying to e-mail password
> >
> >
> > > I am trying to have a form that send a user their email and password
to
> > login. I am using the following:
> > >
> > > while ($row = mysql_fetch_array($result)) {
> > > $email = $row['email'];
> > > $password = $row['password(password)'];
> > >
> > > When I use the mail() function to send both $email and $password I
receive
> > an e-mail with a blank password.
> > >
> > > What am I doing wrong. Please help!
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
