問題描述

慢慢習慣了 PHP 準備好的語句，但仍然出現這個錯誤

slowly getting used to PHP prepared statements, however still get this error

警告:mysqli_stmt::bind_result():綁定變量的數量與第 20 行 C:UsersPCDocumentsXAMPPhtdocslogin.php 中準備好的語句中的字段數不匹配".

"Warning: mysqli_stmt::bind_result(): Number of bind variables doesn't match number of fields in prepared statement in C:UsersPCDocumentsXAMPPhtdocslogin.php on line 20".

 <?php

 $mysqli = new mysqli('localhost', 'c3337015', 'c3337015', 'members');

if (mysqli_connect_errno()) {
    printf("Connect failed: %s
", mysqli_connect_error());
    exit();
    }

 if(isset($_GET['loginEmail'])){

 session_start();

    $stmt = $mysqli->prepare("SELECT Email FROM members WHERE Email=? AND  Password=? LIMIT 1");
    $email = $_GET['loginEmail'];
    $password = $_GET['loginPassword'];
    $password = sha1($password);
    $stmt->bind_param('ss', $email, $password);
    $stmt->execute();
    $stmt->bind_result($email, $password);
    $stmt->store_result();
    if($stmt->num_rows == 1)  //To check if the row exists
        {
            while($stmt->fetch()) //fetching the contents of the row

              {$_SESSION['Logged'] = 1;
               $_SESSION['Email'] = $email;
               header('Location: index.php');
               exit();
               }
        }
        else {
            echo "Wrong Username or Password!";
        }
        $stmt->close();
    }
    else 
    {   
    echo "Something went Wrong";
    }
$mysqli->close();
?>

推薦答案

$stmt->bind_result($email, $password);

您正在綁定 2 個變量，但只要求一個:SELECT Email FROM members.

You are binding 2 variables, but only asking for one: SELECT Email FROM members.

我還建議對 bind_result 使用不同的變量，因為它和 bind_param 都適用于引用.

I'd also suggest using different variables for bind_result, as it and bind_param both work on references.

$stmt->bind_result($userEmail);

這篇關于PHP 準備好的語句問題的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！