php - SQL 查询不起作用，store_result 使执行崩溃

Question

    <?php
   //include 'globals.php';

   $mysqli = new mysqli(correct...);

   if ($mysqli->connect_errno) {
      echo "Failed to connect to MySQL: " . $mysqli->connect_error();
   }

   $username = $_POST['username'];
   $password = $_POST['password'];

   if($query = $mysqli->prepare("SELECT password FROM users WHERE username = ?"))
   {
   $query->bind_param("s", $username);
   $query->execute();
   //$query->store_result();

      $result = $query->num_rows;
      echo sprintf("Row: %d", $result);
      if($result != 0)
      {
         $row = $query->fetch_array();
         if(password_verify($password, $row["password"]))
         {
            echo 'Success';
         }
         else
         {
            echo 'Failed';
         }
      }
      else 
      {
         echo 'Empty';
      }

   }
   $mysqli->close();
?>

如果我不执行 store_result() 该行将始终返回 0(也许查询出错了？)但是，如果我在 PHPMYADMIN 上执行查询，它运行良好。

我错过了什么？

Answer 1

找到解决方案。

改为

   $query = $mysqli->prepare("SELECT password FROM users WHERE username = '?'");

做

$query = $mysqli->stmt_init();
$query->prepare("SELECT password FROM users WHERE username = '?'");

感谢所有做出贡献的人。希望这对其他人有帮助。