php - 我在 php mysql 中的属性 num_rows 中遇到错误

Question

我在num_rows属性中遇到错误php mysql

我的代码：-

<?php 

require ('connect.php');

$inputemail = $_POST['email'];

$sql =  "SELECT*FROM accounts WHERE Email='$inputemail' ";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

  die ("Email is already registered....");

}

else {

  echo "Congrats!!";

}


?>

错误：-

Notice: Trying to get property 'num_rows' of non-object

但这是有效的： -

<?php 

require ('connect.php');

$inputemail = $_POST['email'];

$sql =  "SELECT*FROM accounts ";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

  die ("Email is already registered....");

}

else {

  echo "Congrats!!";

}


?>

为什么？？

标签： phpmysql