这是我使用PHP和SQLite的注册代码。当用户确实不存在时,它会继续使用语句"用户已经存在"。我检查数据库中的用户名是否大于1(如果存在),结果不大于1,但如果我回显出计数,它总是说它等于1…
$checkUser = $db->prepare('
SELECT COUNT(*)
FROM users
WHERE
user = ?
');
$checkUser->setFetchMode(PDO::FETCH_ASSOC);
$checkUser->execute(array($user));
$numrows = count($checkUser);
if ($numrows == 0) {
try {
$reg = $db->prepare("
INSERT
INTO users
(user, pass, email)
VALUES
('$user', '$pass', '$email')
");
$reg->setFetchMode(PDO::FETCH_ASSOC);
$reg->execute();
} catch (PDOException $e) {
print_r($e->getMessage());
}
echo ('success...');
}
else {
die ('user already exists');
}
我不使用SQLite,但你看起来像你的$numrows
只是检查执行实际运行成功(boolean true/false
)。尝试更新这一点:
// I like to name "count" otherwise returned as "COUNT(*)" in the array key
$checkUser = $db->prepare('
SELECT COUNT(*) as count
FROM users
WHERE
user = ?
');
// Execute with bind
$checkUser->execute(array($user));
// Fetch an associative array
$result = $checkUser->fetch(PDO::FETCH_ASSOC);
// The count will be here as a numeric
if ($result['count'] == 0) {