Retrive the md5 encripted data

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
upenk23
Forum Newbie
Posts: 1
Joined: Thu Aug 20, 2009 5:27 am

Retrive the md5 encripted data

Post by upenk23 »

Sir, help me how I can retrive my md5 encripted data stored in mySQL table
User avatar
mrvijayakumar
Forum Commoner
Posts: 58
Joined: Tue Aug 18, 2009 12:39 am
Location: Chennai city, India
Contact:

Re: Retrive the md5 encripted data

Post by mrvijayakumar »

Hello upenk23,
U cannot retrieve data which was encrypted by md5().
User avatar
jackpf
DevNet Resident
Posts: 2119
Joined: Sun Feb 15, 2009 7:22 pm
Location: Ipswich, UK

Re: Retrive the md5 encripted data

Post by jackpf »

What do you mean by "retrieve"?

You can't get the original data back, because MD5 is a one way hash, not an encryption. If you want to get the original data back, use something like base64 encryption.
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Retrive the md5 encripted data

Post by Ollie Saunders »

Use SELECT to retrieve any data from virtually any database whether encrypted or (in your case, with MD5) hashed. But you cannot unhash a hash, that's the whole point of a hash. Google for hashing and web app security for more about how to use hashes.
Post Reply