dongtazu3080 2010-10-29 22:20 采纳率: 100%
浏览 30
已采纳

php - 在mysql中存储加密的字符串

I need to store the customers' driver license # (most of the time) (or personal ID) so when they come to pick their product they can identified themselves based on their id. This is usually the way it is handled everywhere in my country (unfortunately). However, I would like to store this #'s encrypted in mysql. I now I can make use of AES_ENCRYPT, but, my question is, if I hard code the $key, then an attacker who gains access to the server can easily decrypt all of the fields having the key. How can I deal with this?

What I had in mind was to use perhaps openssl_public_encrypt and have a public and private key, but not sure how to implement it. (any good links for explanation?) maybe Asymmetric Key RSA?

I have several physical servers available that I can make use of, if needed.

Any help will be appreciated.

  • 写回答

3条回答 默认 最新

  • dqknycyt92288 2010-10-29 22:28
    关注

    Why do you need to encrypt these licenses asymmetrically?

    1. Validate that the user is providing a valid license.
    2. sha1 the license and save to database.
    3. When you are looking up the license, sha1 the user input and check if it matches.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
  • ¥15 关于#Java#的问题,如何解决?
  • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算