php - MySql没有输出

Question

好的，我有这个代码

<?php
$email = htmlentities($_SESSION['user']['dato'], ENT_QUOTES, 'UTF-8');
$username = "mcnsaoia_onsafe";
$password = "XXX";
$hostname = "localhost"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) 
 or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";

//select a database to work with
$selected = mysql_select_db("mcnsaoia_onsafe",$dbhandle) 
  or die("Could not select examples");

//execute the SQL query and return records
$result = mysql_query("SELECT * FROM users WHERE id= '$email'") or die(mysql_error()); 

//fetch tha data from the database 
while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['status'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
//close the connection
mysql_close($dbhandle);
?>

但是当我运行它时，它只是说连接到 MySQL 而它不输出任何东西？？ 我不知道为什么会这样？!

Answer 1

while($row = mysqli_fetch_array($result))

用 mysql_fetch_array() 改变它

while($row = mysql_fetch_array($result))