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

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

报告相同问题?

悬赏问题

  • ¥15 TLS1.2协议通信解密
  • ¥40 图书信息管理系统程序编写
  • ¥20 Qcustomplot缩小曲线形状问题
  • ¥15 企业资源规划ERP沙盘模拟
  • ¥15 树莓派控制机械臂传输命令报错,显示摄像头不存在
  • ¥15 前端echarts坐标轴问题
  • ¥15 ad5933的I2C
  • ¥15 请问RTX4060的笔记本电脑可以训练yolov5模型吗?
  • ¥15 数学建模求思路及代码
  • ¥50 silvaco GaN HEMT有栅极场板的击穿电压仿真问题