Почему количество переменных не соответствует количеству параметров в подготовленном операторе? ⇐ Php

[Anonymous]

if (isset($_POST["submit"])) {

$fullName = $_POST["full-name"];

$email = $_POST["email"];

$password = $_POST["password"];
$repeatPassword = $_POST["repeat-password"];
$passwordhash = password_hash($password,PASSWORD_DEFAULT);
$errors=array();
if (empty($fullName) or empty($email) or empty($password) or empty($repeatPassword)){
array_push($errors,"All fields are required");
}
if (!filter_var($email,FILTER_VALIDATE_EMAIL)) {
array_push($errors,"Invalid email format");
}
if (strlen($password) 0) {
foreach($errors as $error) {
echo "
".$error."
";
}
}
else {
require_once "database.php";
//$sql = "INSERT INTO users (full_name, email, password) VALUES ('?', '?', '?');";
$sql = "SELECT * FROM users WHERE full_name = ? AND email = ? AND password = ?";
$stmt = mysqli_stmt_init($conn);
$prepareStmt = mysqli_stmt_prepare($stmt,$sql);
if($prepareStmt) {
$stmt->bind_param("sss", $fullName, $email, $passwordhash);
mysqli_stmt_execute($stmt);
echo "
Registration successful
";
}else{
die ("something went wrong");
}

}

}


Подробнее здесь: https://stackoverflow.com/questions/790 ... prepared-s