试图通过PDO检查用户是否存在
$wantedusrnm = $_POST['new-usrnm'];
$userExist1 = "SELECT * FROM users WHERE username=:wantedusrnm";
$userExist = $handler->prepare($userExist1);
$userExist->execute(array(':username' => $wantedusrnm));
$userExist = ($userExist->rowCount());
出于某种原因,它出错了,不知道为什么,有什么原因吗?
更改:
$userExist->execute(array(':username' => $wantedusrnm));
自:
$userExist->execute(array(':wantedusrnm' => $wantedusrnm));
因为,在您的查询中,您有:wantedusrnm
,但在执行数组中您有:username
.