Re: [PHP-DB] user need password
you can however not use the password function and use the encode and decode
function where you can specify your own encryption key. In that way you can
decode a password.
insert into user (password) values (encode('$password','$passkey'));
select decode($password,$passkey) from users where username = "$username";
I may have the variables backwards, but you get the idea.
Curtis
- Original Message -
From: "Paul Burney" <[EMAIL PROTECTED]>
To: "andrie" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 1:44 AM
Subject: Re: [PHP-DB] user need password
> on 5/16/01 10:44 PM, andrie at [EMAIL PROTECTED] wrote:
>
> > we know that every password in mysql was encryption using PASSWORD
> > function. i have case that make me to send user password bymail.
> > how can i get this user password ?
>
> You can't. It's a one way encryption. You'll need to log into MySQL as
> root and set the password to a new password that you can send to the user.
>
> Paul
>
>
> --
> PHP Database 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]
>
--
PHP Database 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]
Re: [PHP-DB] Something Stupid
I told you it was something stupid! That was it. Thank you. Its good to be
able to bounce this stuff off of someone. I'm surprised that doesn't
generate a parse error. Sometimes we just get so wrapped up in it, that it
takes another set of eyes to see the forest for the trees.
Curtis
- Original Message -
From: "Jason Beebe" <[EMAIL PROTECTED]>
To: "Curtis Maurand" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 1:57 AM
Subject: RE: [PHP-DB] Something Stupid
> drop the ; from the while. it is not parsing anything within the scope of
> the while loop because there is a ; saying the while loop ends w/o doing
> anything.
>
> -Original Message-
> From: Curtis Maurand [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 9:39 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Something Stupid
>
>
> I have got to be doien something stupid.
>
> consider the following code.
> hosts, usernames and passwords have been changed to protect the innocent.
>
>$mysql_link =
> mysql_connect("myhost.domain.com","some.user","some.password "
> $myquery = "select car_no,drv_name from cars order by car_no + 0";
> $myresult = mysql_db_query("topten", $myquery, $mysql_link);
> while($rows = mysql_fetch_array($myresult));
>{
> print("$rows[0]\n");
>}
> ?>
>
> I get no output and no errors. I use code almost identical to this all
over
> the place, yet this one doesn;t work.
> I've tried just a bare qery and I still get nothing. the connection is
> working as we can see from the log entry below. At this point, I'm lost.
> If the technique I'm using is considered bad practice, I'm open to
> suggestions. My code would normally print out a table, but for the sake
of
> trouble shooting, I reduced it to this which should print a single column
of
> numbers.
>
> Anyone have any ideas?
>
> the mysqld.log records the query.
>
> 010206 22:59:55 310 Connect[EMAIL PROTECTED] on
> 310 Init DBtopten
> 310 Query select car_no, drv_name from cars order
> by car_no + 0
> 310 Quit
>
>
--
PHP Database 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]
[PHP-DB] Something Stupid
I have got to be doien something stupid. consider the following code. hosts, usernames and passwords have been changed to protect the innocent. \n"); } ?> I get no output and no errors. I use code almost identical to this all over the place, yet this one doesn;t work. I've tried just a bare qery and I still get nothing. the connection is working as we can see from the log entry below. At this point, I'm lost. If the technique I'm using is considered bad practice, I'm open to suggestions. My code would normally print out a table, but for the sake of trouble shooting, I reduced it to this which should print a single column of numbers. Anyone have any ideas? the mysqld.log records the query. 010206 22:59:55 310 Connect[EMAIL PROTECTED] on 310 Init DBtopten 310 Query select car_no, drv_name from cars order by car_no + 0 310 Quit
