dongrou5254 2018-10-02 18:38
浏览 66
已采纳

为什么回声在php中的SQL查询后没有返回ID?

I have the following code in some php:

$stmt = $connection->prepare("SELECT * FROM users where email = ?");
$stmt->bind_param('s', $email);
if($stmt->execute()){
    $result = $stmt->get_result();
    $isUserFound = $result->num_rows == 1;
    if(isUserFound){
        $row = $result->fetch_row();
        echo "<br>id: " . $row["id"];
}

I know that the user is found because the code inside the second if executes and I have done a manual check also to make sure. Is there something wrong with the syntax I have used? The echo returns just "id: " with no id from the database even though the user exists.

I have tried using single quotes for the id and also tried in capital letters, all return nothing.

  • 写回答

1条回答 默认 最新

  • dqmnueuu459279 2018-10-02 18:45
    关注

    According to the documentation, fetch_row() is used to "get a result row as an enumerated array." This will result in an array like this:

    $row = [
        0 => "2342",
        1 => "user@example.com",
        2 => "User",
    ];
    

    Instead use fetch_assoc() which will "fetch a result row as an associative array" and give you something like this:

    $row = [
        "id" => "2342",
        "email" => "user@example.com",
        "name" => "User",
    ];
    

    Note that if you enabled some error reporting in your development environment you would have seen "undefined index" notices that might have helped you solve this issue.

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

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题