我有一个登录数据库,我有很多用户,当我尝试使用数据库中第一个列出的用户登录时,它可以完美地工作。然而,当我和另一个用户一起登录时,它不起作用,看起来只会选择第一行。我的查询出了什么问题?
$username = $_POST['Username'];
$salt = substr($username, 0, 2);
$password = crypt($_POST['Password'], $salt);
$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
$query = $dbh->prepare("SELECT * FROM `7Ducklings` WHERE Username = ? AND Password = ?");
$array = array($username, $password);
$query->execute($array);
$numrows = $query->fetchColumn();
if($numrows == 1)
{
echo "success";
}
else
{
}
$dbh = null;
编辑:成功打印$numrows时,我得到1,否则我得到0。可能是盐的问题吗?
修改if语句以检查是否为空或TRUE/FALSE。fetchColumn()从结果集的下一行返回一列,如果没有更多行,则返回FALSE。PDO提取列
$username = $_POST['Username'];
$salt = substr($username, 0, 2);
$password = crypt($_POST['Password'], $salt);
$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
$query = $dbh->prepare("SELECT * FROM `7Ducklings` WHERE Username = ? AND Password = ?");
$array = array($username, $password);
$query->execute($array);
$numrows = $query->fetchColumn();
if(!empty($numrows))
{
echo "success";
}
else
{
}
$dbh = null;