dougaoxian8922 2018-01-03 23:27
浏览 72
已采纳

容易| 如何从另一列获取一列的值

Picture of my SQL table.

Hi there. I just wanted to know something for a project I am working on. I'm not a very good PHP coder and however I word the question leads to a bunch of jibberish I don't understand.

If User 1's ID is 1 and login is test, how do I find their ID from the login.

Essentially, how do I find 'id' column when the 'login' column is 'test'.

If anyone can just explain it I'd love that.

  • 写回答

1条回答 默认 最新

  • drvc63490 2018-01-03 23:33
    关注

    Looks like you're using phpmyadmin, and perhaps mysql. Normally, your HTML will have a form that will use POST to send the login (and password) to your PHP script. The PHP script will then have a $_POST variable containing all the data that was POSTed to it, including their login. $_POST is an array with named elements, and what name your login field is in depends on what you named the input field in the html.

    After that, to get their ID it's a simple matter of querying your database with a SELECT query such as SELECT id, login FROM your_table . Look up how to run mysql queries in PHP and access the query results:

    http://php.net/manual/en/mysqli.query.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 关于用python写支付宝扫码付异步通知收不到的问题
  • ¥50 vue组件中无法正确接收并处理axios请求
  • ¥15 隐藏系统界面pdf的打印、下载按钮
  • ¥15 MATLAB联合adams仿真卡死如何解决(代码模型无问题)
  • ¥15 基于pso参数优化的LightGBM分类模型
  • ¥15 安装Paddleocr时报错无法解决
  • ¥15 python中transformers可以正常下载,但是没有办法使用pipeline
  • ¥50 分布式追踪trace异常问题
  • ¥15 人在外地出差,速帮一点点
  • ¥15 如何使用canvas在图片上进行如下的标注,以下代码不起作用,如何修改