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.

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

报告相同问题?