douying7289 2017-12-07 08:30
浏览 15
已采纳

如何在PHP中回显解密数据

First, i have use aes_encrypt to encrypt the password

enter image description here

Then i have use aes_decrypt to decrypt the password

enter image description here

The issue is when i try to echo out the data in a table using <?php echo $row['pass'];?>, there'll be an error

"Undefined index: pass in"

SQL insert

insert into username (userName,pass) values('$userName', aes_encrypt('$pass','k'))

SQL select

SELECT UserNameID,userName,aes_decrypt(pass,'k') from username

What went wrong?

  • 写回答

2条回答 默认 最新

  • droxy80248 2017-12-07 08:36
    关注

    Don't you need to use an alias here?

    SELECT aes_decrypt(pass, 'k') AS pass_decrypted FROM ...
    

    And then access it with

    echo $row['pass_decrypted'];
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?