TalkPHP - View Single Post

Wildhoney · 11-23-2007, 02:24 PM

You use it just like I used it in the MySQL

sql Code:

SELECT
    username
FROM
    members
WHERE
    password = MD5(CONCAT(salt, 'buddha'))

Essentially it calls the MD5 function which says, "Aha! I need to concatenate the salt with the word buddha before I MD5 them." It then sticks the 2 together and proceeds to MD5 them together. Then when matching the password, just include the salt again which should be stored as plain-text in another column.

11-23-2007, 02:24 PM	#12 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	You use it just like I used it in the MySQL sql Code: SELECT username FROM members WHERE password = MD5(CONCAT(salt, 'buddha')) Essentially it calls the MD5 function which says, "Aha! I need to concatenate the salt with the word buddha before I MD5 them." It then sticks the 2 together and proceeds to MD5 them together. Then when matching the password, just include the salt again which should be stored as plain-text in another column. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.