Ok, so i have a log in and a register script. Today i put a md5() encoding mechanism on it so it encodes the password when it is sent to the database. Now, how do i encode all of the passwords that were already inside the database? if anybody could help i would be extremely appreciative
tcollins412
0
Junior Poster
Recommended Answers
Jump to PostJust run a query to update them:
UPDATE table SET password_column = MD5(password_column)
Don't forget to backup first, just in case...
Jump to PostWhat if you do
SELECT * FROM $tbl_name WHERE username='$myusername' and password=MD5('$mypassword')
All 7 Replies
pritaeas
2,130
¯\_(ツ)_/¯
Moderator
Featured Poster
tcollins412
0
Junior Poster
pritaeas
2,130
¯\_(ツ)_/¯
Moderator
Featured Poster
tcollins412
0
Junior Poster

diafol
tcollins412
0
Junior Poster

diafol
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.