Encryption in MySQL and PHP

[Shubby27]

Hi I encrypted the passwords in MySQL by using this code and it worked but when used the passwords to login with a PHP website it didnt work. Could someone tell me what i am doin wrong?


INSERT INTO `customer` (`custID`, `surname`, `forename`, `address`, `password`, `gender`, `birthdate`)
VALUES
(1111, 'Dhillon', 'Sharanjit', 'Newcastle', des_encrypt('ShaDhil','somekey'), 'F', '1985-03-07'),
(1112, 'Smith', 'Michael', 'London', des_encrypt('MicSmit','somekey'), 'M', '1972-05-28');

[kovik]

Could someone tell me what i am doin wrong?

Until you have some idea what you are doing wrong, we have no idea what your asking.

Be more specific.

[nathj]

Hi Shuby27

Welcome to TSDN!

When the user supplied the login credentials do you encrypt the password to compare it against the encrypted data in the table?

nathj