phpMyAdmin > Insert > Function = PASSWORD

[inkfish]

Hello,

When I go into my phpMyAdmin and click INSERT in my "user tabel" i have id, username, password and email. When i come to password, i can choose "Password" in the function dropdown menu, and then phpMyAdmin encrypt it or something? but then when I go to my website and write in Username and password, my password is wrong. I know the thing i wrote in the phpmyadmin password input is just the same as i write on my page but becuase it encrypts it i have to do something more on the site, right?

What is it i have to do?

Im sorry if this sounds weird, tell me so and i'll try to make it alittle more simple to understand =P

Thanks for the help!

[jdh]

MySQL's Password function is a one way function, much like md5. There is no way to retreving the value of that field. What you can do though, is check and see if one matches, by comparing it to another one that has gone through the function too.

Ex:

// To check the password, lets run a query.
// pretend there is code before this, that has an input of the field password.

$sql_query = "SELECT * FROM users WHERE username = '$username' && password = PASSWORD('$password')";
$result = mysql_query($sql_query);

if (mysql_num_rows($result) == 0) {
echo "Wrong Password for $username";
}
else {
echo "Hi, $username";
}

[inkfish]

Hello,

Worked great but i wounder one more thing:

When i INSERT a new user and i want to add his password i want it to be added encrypted too, can i do like

INSERT INTO something ("password") VALUES ("PASSWORD($password)")

then?

Thanks!

[inkfish]

I should maybe put the PASSWORD($password) in a variabel and then put the variabel in there: VALUES ("$variabel") ???

[diego25]

INSERT INTO something ("password") VALUES ("PASSWORD($password)")

Remove the quotes:

INSERT INTO something (password) VALUES (PASSWORD($password))

I should maybe put the PASSWORD($password) in a variabel and then put the variabel in there: VALUES ("$variabel") ???

No. PASSWORD() is a MySQL function, not a PHP function.

Diego