问电子邮件激活链接未按预期工作

EN

    if (isset($_GET['email']) AND isset ($_GET['vkey'])){

    if ($stmt = $link->prepare('SELECT email, vkey FROM members WHERE email = ? AND vkey = ?')) {
    $stmt->bind_param('ss', $_GET['email'], $_GET['vkey']);
    $stmt->execute();
    // Store the result so we can check if the account exists in the database.
    $stmt->store_result();
    if ($stmt->num_rows ==1) {


    if ($stmt = $link->prepare('UPDATE members SET status = 1 WHERE email = ? AND vkey = ?')) {
    // Set status to 1
    //$status = 1;
    $stmt->bind_param('ss', $_GET['email'], $_GET['vkey']);
    $stmt->execute();
    echo 'Your account is now activated. You can now login.<br><a href="login.php">Login</a>';
    }
    } else {
        echo 'Your account is already activated or doesn\'t exist!';
    }
}