Re: reverse MD5 ???

William Stokes wrote: > Hello, > > I have a system that uses certain id info. This info is stored in a session > cookie in MD5 format. At certain parts of the code I need to update or > insert to MySQL DB with that id info value in cleartext. Is this possible? > > If so, how to put this to a sql query? > > $sqlquery = "insert into x_table (team_id,number,) values > ('$team_id','$number') > > $team_id is the MD5 formatted cookie value and I need to put it to the > x_table column team_id in cleartext. > > Thanks a lot > -Will Any information that you wouldn't want in the script in plain text, you probably don't want in the database in clear text. Moreover MD5 is a one way hash and although it is broken, you probably don't want to spend the processing time needed to reverse it. Instead, I would just suggest that you try to use the hashed value of the id for whatever purpose you need. If you show some code that relates to how you need the id then maybe we can suggest to you how you can do that. -- Teach a man to fish... NEW? | http://www.catb.org/~esr/faqs/smart-questions.html STFA | http://marc.theaimsgroup.com/?l=php-general&w=2 STFM | http://php.net/manual/en/index.php STFW | http://www.google.com/search?q=php LAZY | http://mycroft.mozdev.org/download.html?name=PHP&submitform=Find+search+plugins

Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc