Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jul 2011
    Posts
    141
    Thanks
    8
    Thanked 0 Times in 0 Posts

    php-md5 encyption-mysql

    When a user registers on my site, I encrypt their data using md5, now I want to welcome the user with some of their stats,

    firstname
    lastname

    But when I retrieve their data from the db, it appear as a md5 hash string
    How can I un-md5 data when I retrieve it from the db
    Code:
    <?php session_start(); ?>
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Account Dashboard</title>
    </head>
    <body>
    <?php
    include('dbsettings.php');
    
    $con = mysql_connect("$host","$user","$password");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }
    
    mysql_select_db("$db_name", $con);
    
    $result = mysql_query("SELECT * FROM $tbl_name");
    
    while($row = mysql_fetch_array($result))
      {
      echo $row['firstname'] . " " . $row['lastname'];
      echo "<br />";
      }
    
    mysql_close($con);
    ?>
    <a href="logout.php"> Log Out </a>
    </body>
    </html>

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    MD5 is a hashing algorithm, not an encryption algorithm, so you cannot reverse it. Its also an insecure one at that.
    The only thing you should be hashing is a password, and I'd recommend using sha256 or sha512 for that at the moment.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •