2017-12-07 08:30
浏览 15


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?

图片转代码服务由CSDN问答提供 功能建议

首先,我使用 aes_encrypt 来加密密码 \ n

然后我使用 aes_decrypt 来解密密码 \ n

问题是当我尝试使用 &lt;?来回显表中的数据时 php echo $ row ['pass'];?&gt; ,会出现错误

“Undefined index:pass in”

SQL insert

插入用户名(userName,pass)值('$ userName', aes_encrypt ('$ pass','k'))

SQL select

SELECT UserNameID,userName 来自用户名<,aes_decrypt(传递,'k') / p>


  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

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'];
    打赏 评论
  • douba3378 2017-12-07 08:37

    In your result set is the password column named as used function. All you need is to set an alias of that column such as: aes_decrypt(pass,'k') as 'pass':

    SELECT UserNameID, userName, aes_decrypt(pass,'k') as pass FROM username

    Your PHP code expect the column 'pass' in result set..

    打赏 评论

相关推荐 更多相似问题