php - Mysql_fetch_data 意外打印

Question

我想用 MySQL 进行密码验证，但不起作用。它不是在 if 子句中进行比较，而是打印 MySQL_fetch_object

public function __construct($userId, $userPassword) {
    $this->userId = $userId;
    $this->userPassword = $userPassword;
    $connect = mysql_connect('localhost', 'php', 'geheim') or exit ();
    $users = mysql_select_db("chat", $connect) or exit ();
    $request = "SELECT userPassword FROM user WHERE userId=$userId";
    $result = mysql_query($result);
    if(mysql_fetch_object($result)->userPassword === $userPassword){
        echo "Right Password";
    }

但它只打印这个，尽管我从未说过它应该回显它:

verificateUser Object ( [userId:verificateUser:private] => 1 [userPassword:verificateUser:private] => 12345 )

我做错了什么？感谢您的帮助!

Answer 1

试试这个

 public function __construct($userId, $userPassword) {
$this->userId = $userId;
$this->userPassword = $userPassword;
$connect = mysql_connect('localhost', 'php', 'geheim') or exit ();
$users = mysql_select_db("chat", $connect) or exit ();
$request = "SELECT userPassword FROM user WHERE userId=$userId";
$result = mysql_query($result);
$userpass =mysql_fetch_assoc($result);
if($userpass['userPassword'] == $userPassword){
    echo "Right Password";
}
}

编辑:如果您对下面的此方法感兴趣

 public function __construct($userId, $userPassword) {
$this->userId = $userId;
$this->userPassword = $userPassword;
$connect = mysql_connect('localhost', 'php', 'geheim') or exit ();
$users = mysql_select_db("chat", $connect) or exit ();
$request = "SELECT userPassword FROM user WHERE userId=$userId";
$result = mysql_query($result);
$userpass =mysql_fetch_assoc($result);
if($userpass['userPassword'] == $userPassword){
   return true:
}
return false;
}

然后你可以这样检查

  if(__construct($userId, $userPassword) == true) { you welcome}
  if(__construct($userId, $userPassword) == false) {do your pass again}